#1
|
|||
|
|||
Merging two or more sheets in the same work book
Hi,
I've an excel file in which a few sheets are present. I've to copy the data in the sheets excluding the headers (Header is marked with Yellow Color in each sheet) to a format called Wardwise. Please refer to the attached sheet. I've to copy the data in Column B in the Sheet 98 to Column B in the Sheet in Wardwise. Then I've to copy and paste below the data in Column B in the Sheet 100 to Column B in the Sheet in Wardwise. Then I've to copy and paste below the data in Column B in the Sheet 101 to Column B in the Sheet in Wardwise. Then I've to insert a column called Part and paste the sheet numbers (Name of the sheet). ie for the data in the sheet 98, 98 has to be pasted and for the data in the sheet 100, 100 has to be pasted and then for the data in the sheet 101, 101 has to be pasted. Then remaining columns in each of the sheet has to be copied to the sheet Wardwise as it is. Then the sheet Ward wise has to be sorted thorugh Columns D,C & B respectrively. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merging all data between two sheets into a third one without duplicates or rows or columns | Ricko_uk | Excel | 4 | 08-27-2020 01:16 AM |
Merging mulitple sheets into one. | c991257 | Excel Programming | 0 | 08-09-2016 11:50 PM |
Work book freeze problem | markg2 | Excel | 4 | 02-27-2014 06:40 AM |
[EXCEL 2010] Merging data from three different sheets | bremen22 | Excel | 1 | 08-20-2013 10:00 AM |
Good book other reference work on VBA | Jennifer Murphy | Word VBA | 1 | 01-30-2012 10:57 AM |