I'm a newbie to macros I'm afraid. I'm using Excel 2011. I'm trying to merge data from 4 sheets into a single sheet. I've looked at a number of macros but can't seem to find one I can use. Problem is I really don't feel confident enough to adapt existing ones.
This is what I have and would like to do:
1. I have 4 sheets with different columns (characteristics) and rows (items)
Number of rows (excluding top row of column headers):
Sheet 1: 1204
Sheet 2: 1159
Sheet 3: 1011
Sheet 4: 752 (& 128 columns!)
2. The first column in each sheet contains the unique item ID
3. Each sheet has the same column headers and the different sets of data are listed below the relevant column
4. This is the bit I'm really stuck on:
Not all the items (rows) appear in each sheet. Therefore I don't have a complete set of characteristic data for each item (row) across all the sheets. Unfortunately, there are no gaps between the rows, so I can't just do a simple copy & paste!
I have something like this (actual headers currently pretty long!):
Sheet 1:
<tbody>
</tbody>
Sheet 2:
<tbody>
</tbody>
Sheet 3:
<tbody>
</tbody>
Sheet 4:
<tbody>
</tbody>
I would like to have:
<tbody>
</tbody>
etc...
I hope this makes sense!
Any help would be very gratefully received as I feel like I've spent days and days trying to sort this out and really don't want to rely on hand inputting stuff!
jocl1
This is what I have and would like to do:
1. I have 4 sheets with different columns (characteristics) and rows (items)
Number of rows (excluding top row of column headers):
Sheet 1: 1204
Sheet 2: 1159
Sheet 3: 1011
Sheet 4: 752 (& 128 columns!)
2. The first column in each sheet contains the unique item ID
3. Each sheet has the same column headers and the different sets of data are listed below the relevant column
4. This is the bit I'm really stuck on:
Not all the items (rows) appear in each sheet. Therefore I don't have a complete set of characteristic data for each item (row) across all the sheets. Unfortunately, there are no gaps between the rows, so I can't just do a simple copy & paste!
I have something like this (actual headers currently pretty long!):
Sheet 1:
ID | Size | Weight |
XX01/001 | 84 | 1 |
XX01/009 | 84 | 1 |
XX03/014 | 71 | 2 |
XX05/031 | 75 | 1 |
<tbody>
</tbody>
Sheet 2:
ID | DDL |
XX01/001 | 100 |
XX03/011 | 100 |
XX03/014 | 95 |
<tbody>
</tbody>
Sheet 3:
ID | AT | PET | RT | CT |
XX01/001 | Yes | Yes | ||
XX01/009 | Yes | No | Yes | No |
XX03/011 | No | |||
XX03/014 | Yes | Yes | ||
XX05/031 | Yes | No | No | No |
<tbody>
</tbody>
Sheet 4:
ID | ADDT | DDT | RET | GaLa | Br | SXTP | SXTP_OTH |
XX01/009 | 15/07 | 16/07 | GA | R | M | ||
XX03/014 | 21/06 | 23/06 | Yes | GA | L | O | T |
XX03/021 | 13/01 | 14/01 | GA | R | W | ||
XX05/031 | 01/12 | 04/12 | LA | R | W |
<tbody>
</tbody>
I would like to have:
ID | Size | Weight | DDL | AT | PET | RT | CT | GaLa | Br | SXTP | SXTP_OTH |
XX01/001 | 84 | 1 | 100 | Yes | Yes | ||||||
XX01/009 | 84 | 1 | Yes | No | Yes | No | GA | R | M | ||
XX03/011 | 100 | ||||||||||
XX03/014 | 71 | 2 | 95 | Yes | Yes | GA | L | O | T | ||
XX03/021 | GA | R | W | ||||||||
XX05/031 | 75 | 1 | Yes | No | No | No | LA | R | W |
<tbody>
</tbody>
etc...
I hope this makes sense!
Any help would be very gratefully received as I feel like I've spent days and days trying to sort this out and really don't want to rely on hand inputting stuff!
jocl1