-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma
>
> *Sent:* Tuesday, August 21, 2012 6:27 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet**
> **
>
> ** **
>
PFA
Siraj
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh Kumar Sharma
Sent: Tuesday, August 21, 2012 6:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet
Dear Noorain,
Plz find
it can be done with consolidation function
venus
On Aug 21, 2012 5:18 PM, "Rakesh Kumar Sharma"
wrote:
> Dear Experts,
>
> Is there any way to merge or combine data of two sheets on a single sheet.
>
>
>
>
>
>
> --
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-9971024741
>
>
> --
> Join off
hi,
Try below Ashish code...
Sub m()
Dim i, j, k, s As Long
s = Sheets.Count
For i = 1 To s
Sheets(i).Select
'change upper row here in this case it will start copying from second row
j = 2
' it will copy till last used row automatically
k = ActiveSheet.UsedRange.Rows.Count
Rows(j & ":" & k).Cop
Sent: Tuesday, August 21, 2012 9:27 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet
Dear Noorain,
Plz find the sample file.
I need to combine data on last sheet.
& in also that case when the data is on different workbooks
On
Dear Noorain,
Plz find the sample file.
I need to combine data on last sheet.
& in also that case when the data is on different workbooks
On Tue, Aug 21, 2012 at 5:57 PM, NOORAIN ANSARI wrote:
> Dear Rakesh,
>
> Can you share your sample workbook with us.
>
>
> On Tue, Aug 21, 2012 at 5:17
Yes.
Have you tried looking?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
Dear Rakesh,
Can you share your sample workbook with us.
On Tue, Aug 21, 2012 at 5:17 PM, Rakesh Kumar Sharma wrote:
> Dear Experts,
>
> Is there any way to merge or combine data of two sheets on a single sheet.
>
>
>
>
>
>
> --
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-9971024741
>
>
>
There are many ways...
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Rakesh Kumar Sharma
Sent: Tuesday, August 21, 2012 6:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Merging Two excel sheets on single sheet
Dear Experts,
Is there an
