Forum Discussion
Solved
Multi-worksheet Comparison ingestion
Hi, I am setting up a workbook that needs to simply ingest new data that is to be compared to old data. So, in the 2019 sheet I have variables and the same variables exist in the 2023 sheet. As y...
- oops, my bad. totally missed that. lol.
do you know how to create tables and use structured references? I recommend that if you can.
Excel
New data will be copied in manually I believe but in the same format. So for 2023 it will be copy and pasted with the same column order as in the sheets i've shared.
Fully functional - a user cna just copy in the data and it'll all line up in the comparison sheet
Ok great, thanks!
New data will be copied in manually I believe but in the same format. So for 2023 it will be copy and pasted with the same column order as in the sheets i've shared.
Fully functional - a user cna just copy in the data and it'll all line up in the comparison sheet
Ok great, thanks!
You didn't answer the question of Excel vs sheets
In excel I would recommend converting the tables to be 'Format as a Table' and name those tables something like NewData and OldData and then use structured references accordingly and use Column sorting
In sheets I would change the reference to be 'open ended' like A1:G to indicate start with cells A1:G1 and include everything to the last data row in those columns. Then as you paste data of different length it will include all that data.
In excel I would recommend converting the tables to be 'Format as a Table' and name those tables something like NewData and OldData and then use structured references accordingly and use Column sorting
In sheets I would change the reference to be 'open ended' like A1:G to indicate start with cells A1:G1 and include everything to the last data row in those columns. Then as you paste data of different length it will include all that data.
- At the beginning of my answer I mentioned Excel, won't be doing it in sheets.
That's great thanks, I will try it out!- oops, my bad. totally missed that. lol.
do you know how to create tables and use structured references? I recommend that if you can.No worries! I can't say I'm familiar but I will look into it as a potential solution 🙂 Thanks for all of your help!