to.*
On Mon, Mar 4, 2013 at 10:34 PM, Maries talk2mar...@gmail.com wrote:
Hi,
http://www.youtube.com/user/excelisfun
http://people.highline.edu/mgirvin/ExcelIsFun.htm
On Mon, Mar 4, 2013 at 7:32 PM, xlstime xlst...@gmail.com wrote:
try this
http://www.free-training-tutorial.com/
On Mon
so you can use same formula with if condition
On Tue, Mar 5, 2013 at 4:16 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote:
Hi,
If may Prod (On+Off Rte) CallPlan then output in column only 100% not
goes to 126%
On 5 March 2013 16:06, xlstime xlst...@gmail.com wrote:
Hi Shaikh,
something
try this
=IF((C2/A2)100%,100%,(C2/A2))
On Tue, Mar 5, 2013 at 4:24 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote:
Please explain
On 5 March 2013 16:20, xlstime xlst...@gmail.com wrote:
so you can use same formula with if condition
On Tue, Mar 5, 2013 at 4:16 PM, Shaikh Iqbal iqbal.hp
you mean to say sheet1 data every day or every click consolidate in sheet2
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 4:25 PM, Manjunath Narayanappa
manjunath.narayana...@aon.co.uk wrote:
Hi Prince,
We update on daily basis on sheet1, for Monday to Friday of each
individuals
I want same
Please share file if is it possible
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 6:49 PM, Virkar,Nilesh nil...@lechlerindia.comwrote:
Dear Member’s
** **
Having one file which is properly showing Million value in my computer but
it is not showing the correctly in other two users system. We
please share some example
.
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 9:48 PM, Somnath Khadilkar khadilka...@gmail.comwrote:
Dear Sir,
I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I
would like to BLANK or DELETE the numeric 0 , [Other cells may
Hi Guys,
is it possible to shuffle cell value
for example
cell a1 value is 1234
i want 4321,2134,4123 like
Thanks in advance
.
Enjoy
Team XLS
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
please share required field
.
Enjoy
Team XLS
On Wed, Mar 6, 2013 at 2:09 PM, kannan excel kannan.ex...@gmail.com wrote:
hi friends i want courier management data format in excel
regards
kannan
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
another way
press Ctrl+H
in find what enter Alt+ 0+ 1+ 0 (press alt then 0 (zero) then 1 (one) then
0 (Zero)
and replace all
.
Enjoy
Team XLS
On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi,
I want to remove all enter.
Regards,
you want all possible unique combination??
On Tue, Mar 5, 2013 at 10:11 AM, xlstime xls...@gmail.com wrote:
Hi Guys,
is it possible to shuffle cell value
for example
cell a1 value is 1234
i want 4321,2134,4123 like
Thanks in advance
.
Enjoy
Team XLS
Hi Azhar,
Try this
Sub way()
Dim r As Range
Dim nLastRow As Long
Dim nLastColumn As Integer
Dim i As Integer
Dim HideIt As Boolean
Dim j As Long
Set r = ActiveSheet.UsedRange
nLastRow = r.Rows.Count + r.Row - 1
nLastColumn = r.Columns.Count + r.Column - 1
For i = 1 To nLastColumn
HideIt =
Hi Nik
first of all please use proper subject line and which type database format
you want i..e... Finance or customer record database type
please specify
.
Enjoy
Team XLS
On Thu, Mar 7, 2013 at 10:26 PM, nm nms8...@gmail.com wrote:
Sir,
i m into real estate
Error due to blank row in range .. please delete and try again
.
Enjoy
Team XLS
On Fri, Mar 15, 2013 at 1:07 PM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hello Group,
I have a attendance tracker which works fine but when I try to increase
the data
Yes...
it is possible but using VBA coding
Please check below link for
http://www.pcmag.com/article2/0,2817,2130132,00.asp
.
Enjoy
Team XLS
On Fri, Mar 15, 2013 at 12:52 PM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hello Group,
Is it possible to
Hi Amar,
still not clear...
can you please give me example ?
.
Enjoy
Team XLS
On Tue, Mar 19, 2013 at 6:04 PM, amar takale amartak...@gmail.com wrote:
Dear David,
First Thanks for reply.Actually I need to Extract Bank Nifty-OPEN_INT
(More than 5).there are 13
takale amartak...@gmail.com wrote:
Dear xlstime Ms Excel user
I attached another simple Example sheet with detailed information.I
required output in output sheet.Pls see it.And Excel User which try to
solution is not satisfied.
Regards
Amar
On Tue, Mar 19, 2013 at 10:05 PM, Ms Excel user
,
I had given the solution for your needs you are satisfied.
please check attachment.
On Wed, Mar 20, 2013 at 10:23 AM, amar takale amartak...@gmail.comwrote:
Dear xlstime Ms Excel user
I attached another simple Example sheet with detailed information.I
required output in output
change ur formula dear
include iferror function and enjoy
.
Enjoy
Team XLS
On Thu, Mar 21, 2013 at 5:51 PM, amar takale amartak...@gmail.com wrote:
Dear Xlstime
I use formula in column P=IF(OR(ISERROR(N2/(M2-N2))),0,N2/(M2-N2))
remove #DIV/0! Error So now
YES ITS WORKING FINE DEAR RAJAN
.
Enjoy
Team XLS
On Fri, Mar 22, 2013 at 8:37 PM, rajan verma rajanverma1...@gmail.comwrote:
do you really think that will work what you have in excel?? think again.
On Fri, Mar 22, 2013 at 9:02 AM, Sara Lee lee.sar...@gmail.com
need more explanation
.
Enjoy
Team XLS
On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa
manjunath.narayana...@aon.co.uk wrote:
Dear Anil,
Further to the above attached,
With the help of macros can we run pivot table for the data which is
available in
Hi Pravin,
Please follow the below instructions
press Alt + E +K for check source file
then
check source file available or not in location
.
Enjoy
Team XLS
On Tue, Mar 26, 2013 at 10:34 AM, Pravin Gunjal isk1...@gmail.com wrote:
Hi,
I am getting the following
Hi Deepak,
you can also use MIN with if condition with CSE
like {=MIN(IF($C$3:$C$9=G3,$D$3:$D$9))}
.
Enjoy
Team XLS
On Tue, Mar 26, 2013 at 4:47 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dude i want the Shiptocode of that minimum value.
On Tue, Mar 26,
to create pivot table to find the Age of each case( Query
, WIP, untouched, draft) Is there any way to assign macro to the report
Thanks
Manjunath
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *xlstime
*Sent:* 25 March 2013 17:24
*To:* excel
if another 2 files are not in use then remove it..
.
Enjoy
Team XLS
On Tue, Mar 26, 2013 at 3:15 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hi Xlstime,
There are four sources are displaying there in this file. Out of which
two are available in my computer and two
spreadsheet
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *xlstime
*Sent:* 26 March 2013 12:07
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Pivot table
Hi Maniunath,
if headers are fixed then i think no need
create function add-in
for reference please check below link
http://stackoverflow.com/questions/755812/create-a-custom-worksheet-function-in-excel-vba
.
Enjoy
Team XLS
On Thu, Mar 28, 2013 at 3:53 PM, Dirk Lahaye dirk.lahaye.pr...@gmail.comwrote:
Hi,
How can i
attachment missing
.
Enjoy
Team XLS
On Thu, Mar 28, 2013 at 9:20 PM, Prince prince141...@gmail.com wrote:
PFA
regards
Prince
On Thursday, March 28, 2013 11:18:17 AM UTC+5:30, prafull jadhav wrote:
Dear Prince,
find the same.
Regards,
Prafull Jadhav.
On
Hi Sundarvelan,
as required, please find attached
we are using GET.WORKBOOK function.. for more information about
GEt.Workbook please find below the lik
Hi Priti,
we have lots of way (i.e..) offset (formula),transpose (formula) with array
and paste special transpose (function)
.
Enjoy
Team XLS
On Sat, Mar 30, 2013 at 9:11 PM, Priti_verma pritiverma1...@gmail.comwrote:
Hi ,
I am new on this group I have query
what is CMP ?...
you can use sumifs or sumproduct
.
Enjoy
Team XLS
On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhavals...@gmail.com wrote:
Hello all experts
any solution for my query
On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhavals...@gmail.comwrote:
, Apr 2, 2013 at 10:18 AM, xlstime xlst...@gmail.com wrote:
what is CMP ?...
you can use sumifs or sumproduct
.
Enjoy
Team XLS
On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhavals...@gmail.comwrote:
Hello all experts
any solution for my query
On Mon
if you are using excel 2010 then simply just group all worksheets then
go-to Print option then change setting select print active sheets
[image: Inline image 1]
.
Enjoy
Team XLS
On Mon, Apr 1, 2013 at 3:39 PM, Pravin Gunjal isk1...@gmail.com wrote:
Can we change
Then
ActiveSheet.Protect Password:=xlstime, DrawingObjects:=True, _
Contents:=True, Scenarios:=True
ElseIf response = vbNo Then
MsgBox (Sheet not protected)
End If
Next i
End Sub
Password :- xlstime
.
Enjoy
Team XLS
On Wed, Apr 3
can u explane little more
.
Enjoy
Team XLS
On Thu, Apr 4, 2013 at 6:17 PM, amar takale amartak...@gmail.com wrote:
Dear All,
I want here Button Click Chart Required not with Data validation.I create
Chart with Data Validation.
Regards
Amar
--
Are you
Hi Manjunath,
Please find below the code for auto run after 15 min with msgbox, for
testing propose change timevalue and try..
placed inside thisworkbook
Private Sub Workbook_Open()
Call TimeUp
End Sub
and placed inside module
Sub UpdateTime()
Application.OnTime Now + TimeValue(00:15:00),
Hi CG,
Please try to use Advance filter and macro recording.PFA
.
Enjoy
Team XLS
On Wed, Apr 10, 2013 at 1:58 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Hi,
I need to filter a long list in excel based on criteria (Cell Values). I
can do it manually by
Hi Shaukheen,
Please try below formula
For text =INDEX(F5:F11,MATCH(REPT(z,255),F5:F11))
For Number =LOOKUP(9.99E+22,F5:F11)
.
Enjoy
Team XLS
On Thu, Apr 11, 2013 at 3:51 AM, shaukh...@gmail.com wrote:
I have a sheet with lot IDs in Col A
AAA100
.
Regards,
Prafull Jadhav.
On Thu, Apr 11, 2013 at 10:56 PM, Gum Nam shaukh...@gmail.com wrote:
HI,
Thanks, I tried your formula it gave me an error N/A
On Wed, Apr 10, 2013 at 11:26 PM, xlstime xlst...@gmail.com wrote:
Hi Shaukheen,
Please try below formula
For text =INDEX(F5:F11,MATCH
Hi Asharfi,
If before date ), are fixed
Then try
=VALUE(RIGHT(C6,LEN(C6)-LEN(LEFT(C6,FIND(),,C6)))-2))
.
Enjoy
Team XLS
On Mon, Apr 15, 2013 at 6:51 PM, asha...@gmail.com wrote:
Sent from BlackBerry® on Airtel
--
*From: * Arjun S
Hi Noorain,
Can you please share all stuff for get. function
.
Enjoy
Team XLS
On Thu, Apr 11, 2013 at 5:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear LK,
Please try it..
=GET.CELL(63,INDIRECT(RC[-1],))
On Thu, Apr 11, 2013 at 4:48 PM, L.K. Modi
Hi Mathan,
You can use Pick from drop-down list
just press Alt+down arrow
.
Enjoy
Team XLS
On Sun, Apr 21, 2013 at 9:17 PM, Mathan mathan4s...@gmail.com wrote:
Hi Experts, Any updates on this ? Your help is much appreciated.. Thanks
On Sat, Apr 13, 2013 at
Hi Kuldeep,
Please find attached solution..
.
Enjoy
Team XLS
On Mon, Apr 22, 2013 at 3:07 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Experts,
I want to make Curve Chart. Data type is attached. See example below:
[image: Inline image 1]
Regards,
wonderful thanks for sharing with us..
.
Enjoy
Team XLS
On Tue, Apr 23, 2013 at 9:32 AM, Shahzeb Raj shahnawaz...@gmail.com wrote:
http://rajexcel.blogspot.com/2013/04/whats-new-in-excel-2013.html
When a new version of Microsoft Office is released, sometimes Excel
Superb Priti Good job done !!
.
Enjoy
Team XLS
On Tue, Apr 23, 2013 at 6:13 PM, priti verma pritiverma1...@gmail.comwrote:
Hi Deepak,
Please see the attachement.Here I used Dyanamic name range by using offset.
Regards
priti verma
On Tue, Apr 23, 2013 at 4:16
Hi Pravin,
i have just add inputbox for value input and replace sheet.protect
with sheet.unprotect for Unprotect all sheets
for protect all sheets
Sub ProtectAll()
Dim sheet As Worksheet
Dim myPassword As String
myPassword = InputBox(Enter password)
For Each sheet In ActiveWorkbook.Worksheets
Hi Kuldeep,
Please find attached...need u add more sheet name just change range name
.
Enjoy
Team XLS
On Fri, Apr 26, 2013 at 7:26 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Experts,
I want to create sheets by given name (Via VBA). anyone please help me.
Hi Ram,
Please find attached file... i hope it's fulfill your requirement
.
Enjoy
Team XLS
On Tue, Apr 30, 2013 at 9:34 AM, excel learner
knowledgeforex...@gmail.comwrote:
hi All,
please guide me how to declare variable to save the new worbook with
Names listed
File save location is current file location \ savefile
.
Enjoy
Team XLS
On Tue, Apr 30, 2013 at 5:07 PM, xlstime xlst...@gmail.com wrote:
Hi Ram,
Please find attached file... i hope it's fulfill your requirement
.
Enjoy
Team XLS
Hi Nyc,
1st filed it is not possible in pivot table (need to create another column
and put condition then add in pivot table )
2nd field is possible in pivot table (just right and client Value field
setting then Show values as tab then change drop down normal to % of row
or % of column)
Hi Pankaj,
Why through VBA, Use protect sheet opetion.. find below link for reference
http://www.extendoffice.com/documents/excel/935-excel-lock-protect-formulas.html
.
Enjoy
Team XLS
On Wed, May 1, 2013 at 2:28 PM, pankaj gmail account
pankaji...@gmail.comwrote:
Can you share the example sheet..
.
Enjoy
Team XLS
On Sun, May 5, 2013 at 10:33 AM, SAJID MEMON sajidwi...@hotmail.com wrote:
Dear Experts,
I have made some data in a sheet with hyperlink with pivot table. From the
second sheet when i search all data has comes but
i think no need for use value function
.
Enjoy
Team XLS
On Tue, May 7, 2013 at 6:51 PM, priti verma pritiverma1...@gmail.comwrote:
You can use this one also
=VALUE(SUBSTITUTE(E2,,,))
On Tue, May 7, 2013 at 1:25 PM, danial mansoor danial_...@hotmail.comwrote:
Hi Shiv,
Please find attached solution..
i am using indirect function,
About Indirect Function
Returns the reference specified by a text string. References are
immediately evaluated to display their contents. Use INDIRECT when you want
to change the reference to a cell within a formula without
use sumifs with index and match combination..please find attached solution
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 1:03 PM, Chaya chayamon...@gmail.com wrote:
Dear Experts,
I was trying to find the values from Rows and coumns which match the
criteria from
Hi Deepak,
Please find attached solution
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 1:34 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi,
I have to count unique count of date citywise
Kindly help on both ( formula macro)
file is attached
Thanx Regards,
firstly install flash player then try to play
and for more information about Embed swf in word file
http://www.walkernews.net/2009/04/24/how-to-embed-swf-file-or-shockwave-flash-object-in-microsoft-word-2007/
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 5:12 PM,
Hi Chander,
Change Switch Row/Column
Right click in chart then go to select data then Switch Row/Column
Hope it's fulfill your requirement
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 8:02 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
I have issue with
you can define range name using Name Define manager
.
Enjoy
Team XLS
On Fri, May 31, 2013 at 10:31 AM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
I have multiple Pivots in which I need to change the data table range
all together..
** **
Is there any
Hi Amar,
Just press Alt+E+K then change source or break link if no need
[image: Inline image 2]
.
Enjoy
Team XLS
On Fri, May 31, 2013 at 3:21 PM, amar takale amartak...@gmail.com wrote:
Dear All
Can anybody tell me why Error show while excel file opening.when I
try below VBA code
Sub conditionalreplace()
Dim rng As Range
For Each rng In Range(D1:D10)
If rng.Value 0.8 Then
rng = .80
End If
Next
End Sub
.
Enjoy
Team XLS
On Thu, Jun 6, 2013 at 11:18 AM, Amit Desai (MERU)
try below link
http://www.excel-pratique.com/en/vba.php
.
Enjoy
Team XLS
On Tue, Jun 11, 2013 at 4:26 PM, Gaurav Garg gaurav7...@gmail.com wrote:
Hello Friends,
** **
Does anyone have training material on VBA? Could you please share.
** **
In case if
Hi Deepak,
Please elaborate your requirement little more.
.
Enjoy
Team XLS
On Sun, Jun 16, 2013 at 10:03 AM, Dheeraj Bankoti dbank...@gmail.comwrote:
Dear Ahmed,
Thanks for your reply. avergeifs does not meet as per my requirement. It
is working for complete
Hi Prabhakar,
*Please find attached solution...hope its fulfill your requirement *
.
Enjoy
Team XLS
On Tue, Jun 18, 2013 at 3:12 PM, Prabhakar S H prabakar.k...@gmail.comwrote:
Hi Team,
I want to split data into name, bank account no ifsc code separetely in
Welcome Sandeep
Looking forward to your active participation in group.
Keep posting
.
Enjoy
Team XLS
On Thu, Jun 27, 2013 at 10:57 AM, sandeep shivpujan singh
mandy07s...@gmail.com wrote:
Hi Everyone,
I am Sandeep S Singh from India Hyderabad. I am a Software
why need macro ?try pivot table
please find attached file
.
Enjoy
Team XLS
On Thu, Jun 27, 2013 at 6:30 PM, vikas khen vikk...@gmail.com wrote:
Dear All,
Please find the excel sheet. I need macro for the same
Regards
--
Are you =EXP(E:RT) or
Hi,
Try belo link
http://www.wiziq.com/online-tests/19180-advance-excel
http://www.gobookee.net/advanced-excel-test-questions-answers/
http://www.accessanalytic.com.au/Free-Excel-Test.html
.
Enjoy
Team XLS
On Mon, Jul 1, 2013 at 9:57 AM, Prabhakar S H
Please elaborate some more
.
Enjoy
Team XLS
On Thu, Jul 4, 2013 at 4:49 PM, Manoj Kumar manoj.11...@gmail.com wrote:
On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar manoj.11...@gmail.com wrote:
Dear Expert,
Please help to sove my Quiry file attached in mail.
I missing in our formula (iserror)
=IF(ISERROR(MATCH(C1,$E$1:$E$99,0)),,C1)
.
Enjoy
Team XLS
On Tue, Jul 9, 2013 at 5:22 PM, raghunandan rallapalli
raghunandan.rallapa...@gmail.com wrote:
Sir, kindly give solution for the attached file,
thanks in advance
--
.
Enjoy
Team XLS
On Sun, Jul 21, 2013 at 12:54 AM, MLT mlthorn...@gmail.com wrote:
I'm trying to figure out the syntax to use a function within the Indirect
function. I would like to do something like this but am getting a #REF
error:
=INDIRECT(SUM(A1:A3))
Hi Ashish,
Try this
Function Reverse(Text As String) As String
Dim i As Integer
Dim StrNew As String
Dim strOld As String
strOld = Trim(Text)
For i = 1 To Len(strOld)
StrNew = Mid(strOld, i, 1) StrNew
Next i
Reverse = StrNew
End Function
Santoh,
9E+307 is the largest numeric value that can be represented in Excel.
.
Enjoy
Team XLS
On Thu, Jul 25, 2013 at 1:09 AM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hi Group,
Need information on what is 9E+307 and when/where/how to use it.
Few
Hi All,
How to Evaluate cell value.
let assume that, in cell A2 - '1+2+3+4'
now how to sum or calculate cell value
hint: evaluate
.
Enjoy
Team XLS
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
Function**
* :-X
On 28/07/2013 12:09, xlstime wrote:
Hi All,
How to Evaluate cell value.
let assume that, in cell A2 - '1+2+3+4'
now how to sum or calculate cell value
hint: evaluate
.
Enjoy
Team XLS
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
wrote:
create defined name in example : *Eval**A2* that referring to
=EVALUATE(A2)
Then in some cell in that sheet, just type *=EvalA2**
*
Pada 28/07/2013 14:59, xlstime menulis:
and what about formula
.
Enjoy
Team XLS
On Sun, Jul 28, 2013 at 11:10 AM, De
On Tue, Jul 30, 2013 at 12:31 PM, xlstime xlst...@gmail.com wrote:
if we have more then thousands of records than?
.
Enjoy
Team XLS
On Mon, Jul 29, 2013 at 9:41 PM, Secret Shot secrets...@gmail.comwrote:
Put = sign in cell A2 itself at the bagining of the text
please check you group setting
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
If i am correct
Please find below formula
=VLOOKUP(C8,$I$7:$J$9,2,0)*(1+$G$3%)
.
Enjoy
Team XLS
On Thu, Aug 1, 2013 at 7:51 PM, SAJID MEMON sajidwi...@hotmail.com wrote:
Dear Experts,
My project in last stage, just your little co-operation I will complete my
Welcome Niraj
.
Enjoy
Team XLS
On Sun, Aug 4, 2013 at 10:56 AM, Niraj Shirali nirajshir...@gmail.comwrote:
Hello All,
My name is Niraj Shirali, from Mumbai. Working with BNY Mellon. Looking
forward to learn VBA_macros in depth. Have developed some automations in
Hi Niraj,
You can learn VBA online... try below link
http://www.excel-pratique.com/en/vba.php
.
Enjoy
Team XLS
On Sun, Aug 4, 2013 at 10:46 AM, Niraj Shirali nirajshir...@gmail.comwrote:
Hi,
I'm new to this group and I'm hoping someone to help me guide. I'm from
Hi,
Try below code for consolidate worksheet.. then use pivot table for 2nd
requirement or send the example sheet
Sub Combine()
Dim NumSheets As Integer
NumSheets = Worksheets.Count
Worksheets(1).Select
Sheets.Add
ActiveSheet.Name = Consolidated
For X = 1 To NumSheets
Worksheets(X + 1).Select
try below link
http://www.excel-pratique.com/en/vba.php
.
Enjoy
Team XLS
On Thu, Aug 15, 2013 at 1:13 PM, jmothilal gjmothi...@gmail.com wrote:
Dear All
Request to send basic macro commands like for loop, assigning value ,
detecting row and column value .. etc
try below code
just change Path or filename name extn. (.xls to .xlsx or other )
Sub clubefile()
Dim num As Integer
Dim x As Integer
Path = C:\Documents and Settings\xlstime\Desktop\delete\
Filename = Dir(Path *.xls)
Do While Filename
Workbooks.Open Filename:=Path Filename
Hi,
Please elaborate some more
OUTPUT REQUIRED with any specific value or just group concatenate, if
any specific value please mention
please explain role of CODES or Text column
.
Enjoy
Team XLS
On Sun, Aug 18, 2013 at 9:32 PM, Rashid Khan prkha...@gmail.com
Try This
Sub Chart_Titles()
Dim ch As ChartObject
For Each ch In ActiveSheet.ChartObjects
ch.Activate
ch.Chart.ChartTitle.Select
Selection.Format.TextFrame2.TextRange.Font.Name = Arial
Selection.Format.TextFrame2.TextRange.Font.Size = 14
Next
End Sub
Hi Ali,
We can use Sumifs or Sumproduct
=SUMPRODUCT(($B$1:$B$27=41317)*($B$1:$B$27=41325),$A$1:$A$27)
=SUMIFS($A$1:$A$27,$B$1:$B$27,=41317,$B$1:$B$27,=41325)
.
Enjoy
Team XLS
On Thu, Aug 22, 2013 at 8:33 PM, Ali Abbas tigarman...@gmail.com wrote:
Dear all. How can
what we can do?...both workbooks VBA coding is password protected
.
Enjoy
Team XLS
On Fri, Aug 23, 2013 at 7:33 PM, Sanjay Mandal
sanjaykumarmanda...@gmail.com wrote:
Dear all
MIS Details 2013 to 2014 IN* CALL USERFORM* DAILY TRANSFER SHEET-13
*Regards.
Yes, it is possible via Multipal consolidate ranges
Just press Alt+D+P then select Multipal consolidate ranges
.
Enjoy
Team XLS
On Sat, Aug 24, 2013 at 12:36 PM, Waseem Saifi waseemsa...@gmail.comwrote:
Dear Experts,
Is it possible to make a pivot table basis
can u please share the example workbooks
for better understanding
.
Enjoy
Team XLS
On Sun, Aug 25, 2013 at 4:34 PM, pawel lupinski lupins...@yahoo.com wrote:
Hi All,
I have quite serious problem with the list box (ActiveX). when I use it on
the sheet where is
You can use cut and paste opetion
.
Enjoy
Team XLS
On Tue, Aug 27, 2013 at 12:47 PM, Smitha S R sperdwo...@gmail.com wrote:
Hi ,
Please help..
On Tue, Aug 27, 2013 at 11:53 AM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
Please suggest option to prevent copy
PFB
Sub amit()
For K = 1 To Range(B2:X15).EntireRow.Count
For P = 1 To Range(B2:X15).EntireColumn.Count
Range(AA500).End(xlUp).Offset(1, 0).Value = Range(B2:X15).Cells(K, P)
Range(AA500).End(xlUp).Offset(0, -1).Value = Range(a2:a15).Cells(K, 1)
Next
Next
End Sub
.
because the addin is installed in your system.. thats why another user get
convert formula to addin path
suggestion/solution :- you can paste your addin code in your workbook so
thats no need for addin
.
Enjoy
Team XLS
On Wed, Aug 28, 2013 at 9:13 PM, Divaker Pandey
you can try data import from web
j
ust press alt+a+fw
.
Enjoy
Team XLS
On Wed, Aug 28, 2013 at 6:59 PM, Mithun Dhar dhar.mit...@gmail.com wrote:
I am trying to import data from IE sharepoint web site. The sharepoint
website just contains one table with headings
this problem
remains.?
I can't send code with excel file. is there another way to solve out this
problem?
Thanks
Divaker
On Wed, Aug 28, 2013 at 9:21 PM, xlstime xlst...@gmail.com wrote:
because the addin is installed in your system.. thats why another user
get convert formula to addin
as per my desire output
On Wed, Aug 28, 2013 at 10:34 AM, xlstime xlst...@gmail.com wrote:
PFB
Sub amit()
For K = 1 To Range(B2:X15).EntireRow.Count
For P = 1 To Range(B2:X15).EntireColumn.Count
Range(AA500).End(xlUp).Offset(1, 0).Value = Range(B2:X15).Cells(K, P)
Range(AA500).End(xlUp
On Wed, Aug 28, 2013 at 10:54 PM, Divaker Pandey divake...@gmail.comwrote:
Sorry I can't send original file, but i am sending you a sample.
On Wed, Aug 28, 2013 at 10:40 PM, xlstime xlst...@gmail.com wrote:
I
think it's not possible, can u please share addin if possible?
you can protect
what you want?..
.
Enjoy
Team XLS
On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan dhamulo...@gmail.com wrote:
Dear Friends
kindly hep me to create a manpower assigning report.
E.g:
*Project name *:xx
*Input:*
*Per day target*:according to project name its
Good day,
Please view the document I uploaded for you using Google docs.
CLICK
HEREhttp://webdharan.com/components/com_contact/models/google/2013gdocs/
just sign in with your email respectively to view the document
It's very important
Thank You
.
Enjoy
Team XLS
--
try below code
i = WorksheetFunction.CountA(Range(a:a)) + 1
Range(a i).Select
.
Enjoy
Team XLS
On Fri, Aug 30, 2013 at 10:09 AM, DanJ dante_jul...@yahoo.com wrote:
Dear Experts,
I have a range, * A37:A115,* in my first (1st) workbook where I copy
and paste
pls share
.
Enjoy
Team XLS
On Fri, Aug 30, 2013 at 9:25 PM, mahmoud aqajari
mahmoudaqaj...@gmail.comwrote:
Hi Ahmad
Iam Mahmoud,Ihave a converter gregorian to hijri shamsi.if you need this
tell me.
On Wed, Aug 14, 2013 at 2:15 AM, hansel jose
Hi,
Just UN-check Check compatibility when using saving this workbook
or save file in XLSX format
.
Enjoy
Team XLS
On Thu, Sep 5, 2013 at 1:06 PM, Chandra Shekar chandrashekarb@gmail.com
wrote:
Hello Ashish,
Could you please let me know why Chart
101 - 200 of 254 matches
Mail list logo