PFA OR
=IFERROR(VLOOKUP(A2,CHOOSE({1,2},Contacts!$B$2:$B$13,Contacts!$A$2:$A$13),2,
0),UNKNOWN NUMBER)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of M.Rafique MRU
Sent: Sunday, October 27, 2013 9:57 PM
To: excel-macros
Subject: $$Excel-Macros$$
Dear Experts,
I have 100 worksbooks which contains worksheet (i.e. Profitability) so I
want to consolidate all the worksheets in one workbook. This worksheet data
is linked from other worksheets so I want that data in as it is in
consolidated workbook.
Kindly help me in this VBA.
Thanks
Thanks, will check the same do the needful.
Regards,
Amit Desai - MIS Manager
M: +91 9867232534
[cid:image001.jpg@01CED3DA.DC1D6BD0]http://www.merucabs.com/mobile/
[cid:image002.jpg@01CED3DA.DC1D6BD0]goo.gl/gHTB5E[cid:image003.jpg@01CED3DA.DC1D6BD0]goo.gl/QNQP51
From:
Thanks Ravinder this formula works for me.
Thanks and regards, Rupesh
On Mon, Oct 28, 2013 at 12:20 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
PFA OR
** **
=IFERROR(VLOOKUP(A2,CHOOSE({1,2},Contacts!$B$2:$B$13,Contacts!$A$2:$A$13),2,0),UNKNOWN
NUMBER)
** **
*From:*
hi Sagar*.*
*First** all of i want's tell, I am new on this forum so excel, so may be
this link will help you or you want through it, *
http://www.wikihow.com/Consolidate-in-Excel*
*
*
*
*thanks *
On Mon, Oct 28, 2013 at 12:32 PM, Sagar Kasangottuwar
sagarkasangottu...@gmail.com wrote:
Dear
Dear Rupesh,
I want to copy worksheett from various workbooks to single workbook.
Thanks Regards,
Sagar
On Mon, Oct 28, 2013 at 1:00 PM, Rupesh Patil patil.rupesh1...@gmail.comwrote:
hi Sagar*.*
*First** all of i want's tell, I am new on this forum so excel, so may
be this link will
Try this one.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sagar Kasangottuwar
Sent: Monday, October 28, 2013 1:06 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for consolidate worksheets from various
workbook to specific
Dear Experts I am very thankful to all of you by taking time solved my
problem very quickly. This Forum is so much responsive. Thanks to this
forum too.
On Sunday, October 27, 2013 9:27:29 PM UTC+5, MRafique Ujjan wrote:
Dear Friends,
I have attached Workbook here with the name of call
Hi Friends,
I have attached a workbook which is enabling me to send the selected sheet
as an attachment thur mail.
i need a small modification in the VBA, in the same mail(using to send mail
attachment) body i need to peast Summary sheet in the same mail.
I.e. Sheet Debit will be as
Dear Ravindra,
Run time error 9 is showing after running macro. Kindly send me the macro
for copy sheets from various workbooks to single workbook.
Thanks ,
Sagar
On Mon, Oct 28, 2013 at 2:26 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
Try this one…
** **
*From:*
Did you put path in range b2 of first sheet.?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sagar Kasangottuwar
Sent: Monday, October 28, 2013 5:20 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for consolidate worksheets from
Yes, I put the path of file and this was not worked so I put the path of
folder also.
But it is not working.
I want various sheets in single workbook.
Sagar
On Mon, Oct 28, 2013 at 5:26 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
Did you put path in range “b2” of first sheet.?
**
Dear All,
Very Good Morning ..and Have a Great Day Ahead!
I got below Function from our group . I have modified it . We can put Space
between word
for example
PrafullJadhav then output is Prafull Jadhav
AjayNareshRane then output will be Ajay Naresh Rane
MY question is Can we create Macro by
PFA OR BELOW CODE
Sub putspace()
Dim rng As Range
Set rng = Application.InputBox(Please Select Range, Type:=8)
For Each T In rng
k = T
For i = 1 To Len(T)
j = Mid(T, i, 1)
If j = UCase(j) Then
k = WorksheetFunction.Substitute(k, j,j)
End If
T.Offset(0, 1) = WorksheetFunction.Trim(k)
PFA OR BELOW CODE
Sub putspace()
Dim rng As Range
Set rng = Application.InputBox(Please Select Range, Type:=8)
For Each T In rng
k = T
For i = 1 To Len(T)
j = Mid(T, i, 1)
If j = UCase(j) Then
k = WorksheetFunction.Substitute(k, j,j)
End If
T.Offset(0, 1) =
PFA OR BELOW CODE
Sub putspace()
Dim rng As Range
Set rng = Application.InputBox(Please Select Range, Type:=8)
For Each T In rng
k = T
For i = 1 To Len(T)
j = Mid(T, i, 1)
If j = UCase(j) Then
k = WorksheetFunction.Substitute(k, j,j)
End If
T.Offset(0, 1) =
Hi exports
I have sheet with some columns name of the columns is Mis No, Mob No,
Student name, email id, others. what i need is take sheet from local system
and validate the column such as Mis No and Mob No should be number only,
proper email id like that. I have been through some code but not
Dear All,
Thanks to Everybody...It is really working fine...
Regards,
Prafull Jadhav
9920553518
On Tue, Oct 29, 2013 at 10:11 AM, Prafull Jadhav
prafulltjad...@gmail.comwrote:
Dear All,
Very Good Morning ..and Have a Great Day Ahead!
I got below Function from our group . I have modified
Pls give some example file so
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rupesh Patil
Sent: Tuesday, October 29, 2013 10:43 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Validation Micro
Hi exports
I have sheet with some
Dear Ravinder,
I am really thankful your interest on this thread.
you were ask me sample file, so Please find in attachment.
Thanks Ruepsh,
On Tue, Oct 29, 2013 at 11:12 AM, Ravinder ravinderexcelgr...@gmail.comwrote:
Pls give some example file so
** **
*From:*
20 matches
Mail list logo