two doubts

JBeaucaire · #1 12-31-2011, 01:10 PM

1) No idea about that.

2) 'MANY SHEETS TO ONE SHEET
Here's a macro for merging data from multiple sheets into a "consolidation" sheet where the source sheets are the same layout.

Sheets to One Sheet - Part 1

There's a sample file there, too, to make it easy to try it out.

gsrikanth · #2 01-06-2012, 05:55 AM

Quote:

Originally Posted by JBeaucaire

1) No idea about that.

2) 'MANY SHEETS TO ONE SHEET
Here's a macro for merging data from multiple sheets into a "consolidation" sheet where the source sheets are the same layout.

Sheets to One Sheet - Part 1

There's a sample file there, too, to make it easy to try it out.

JBeaucaire in every sheet last row is not comming suggust or any other code plz