On Sheet 1, I have a table that gets copied onto Sheet 2. Sheet 2 then has the entire table with some additional information that is manually inputted with each row. Currently I have it set up in each column where it is just ='Sheet1!'A1 for every cell.
I get my information from Sheet 1 from an outside source. My issue is that I will be recopying sheet 1 periodically and the rows will fluctuate and not be in the same order each time I copy and paste to sheet 2. This means that the information that has been manually inputted on sheet 2 could be on an incorrect row when I re-copy and re-paste.
I need a way to prevent this from happening. Please let me know if it does not make any sense. Thanks!
I get my information from Sheet 1 from an outside source. My issue is that I will be recopying sheet 1 periodically and the rows will fluctuate and not be in the same order each time I copy and paste to sheet 2. This means that the information that has been manually inputted on sheet 2 could be on an incorrect row when I re-copy and re-paste.
I need a way to prevent this from happening. Please let me know if it does not make any sense. Thanks!
