Hi Guys,
I have a real strange query here.
Basically, I need to copy and paste the data from Sheet1 to Sheet2 to the corresponding column names.
But here is the catch:
1.Sheet1 has about 100 columns with ID in the First column. But the ID in first column repeats with different data corresponding to them.
2.Sheet1: Row-1 has all the headers.
3.Sheet 2 has TWO header rows present, one in Row-5 and Row-8.
4.For Sheet2: Row-8 headers, I have to paste the data copied from Sheet1 and match the column names(which are jumbled) from Row-10 onwards till where the same ID is repeating.
5.For Sheet2: Row-5 headers, I need paste values ONLY for the cells: "D6, J6, L6, P6, Q6, U6, V6, Z6, AA6 and AR6" from Sheet1 data by matching the column names.
6.I have to repeat the same process(4 and 5) in Sheet3 for the second ID in the Sheet1.
Sheet1 will look like this:
Row-1 Account # *Record Type Source Node # Install Date
Row-2 ID+1 D FS Fox 3/20/1991
Row-3 ID+1 D FS Fox 03/20/1991
Row-4 ID+1 D FS Fox 03/20/1992
Row-5 ID+1 D FS Fox 03/20/1992
Row-6 ID+1 D FS Fox 03/20/1992
Row-7 ID+1 D FS Fox 03/20/1993
Row-8 ID+1 D FS Fox 03/20/1993
Row-9 ID+1 D FS Fox 03/20/1994
Row-10 ID+2 D FS Vesp 03/20/1982
Row-11 ID+2 D FS Vesp 03/20/1982
Row-12 ID+2 D FS Vesp 03/20/1982
Row-13 ID+2 D FS Vesp 03/20/1982
Row-14 ID+2 D FS Vesp 03/20/1982
Row-15 ID+3 D FS Prep 03/20/1982
Sheet2 should look like this:
Row-1 *1 2 3 4 5 6
Row-2 X Y Z A B C
Row-3 V ABC DEF IJK 2 NNN
Row-4 *1 2 3 4 5 6
Row-5 *Record Type IDs Type Name Sys Name Network
Row-6 H Non-HW DCS System Non-HW DCS System Foxboro I/A Series System Non-HW DCS System
Row-7 *1 2 3 4 5 6
Row-8 *Record Type Source Barcode Build Cabinet Comments
Row-9
Row-10 D FS
Row-11 D FS
Row-12 D FS
Row-13 D FS
Row-14 D FS
Row-15 D FS
Row-16 D FS
Row-17 D FS
Truncated the columns to 6 here in example.
Any help would be greatly appreciated.
Bookmarks