Hi,
I want to be able to associate the first row and first column of Sheet 2 to Sheet 1.
I need to make sure the data in each row stays next to its corresponding cell in the first column, even with changes in the first column.
The data that is not the labels in row 1 and column 1 are different between Sheet 2 and Sheet 1, however.
To clarify what I'm looking for, I attached an example excel file where I manually entered stuff for each cell that describes what I want to have automated:
The first row and first column of Sheet 2 are always equal to the first row and first column of Sheet 1. However, the data in between them is different.
When I add the 'bb' cell into Sheet 1, the 'bb' cell needs to be automatically updated into Sheet 2 and a new row is inserted in both sheets.
It is important that the corresponding data for each of a, b, c, d stays next to a, b, c, d, respectively in both sheets (i.e. I want a blank row next to the 'bb' cell in both sheet 1 and sheet 2).
It is kind of hard to explain so please reply if this didn't make sense.
I would really appreciate any help, especially if you could describe what you did to achieve what I was looking for.
Thanks
EDIT: In the file that I have attached, there are four sets of data all on one sheet.
In reality the 'Sheet 1' set would start on top left corner of Sheet 1 and the 'Sheet 2' set would start on top left corner sheet 2, I just put them this way so you can see them all at once.
Bookmarks