Oct 25 2021 05:21 AM
Hello Community!
I would like to make one sheet connected to another sheet. IF I delete data in Sheet 1 and paste new data into this, I want Sheet 2 to bring through only data with those headings.
Is this possible?
Sheet1:
Sheet2:
Many thanks!
Oct 31 2021 04:31 AM
Oct 31 2021 10:27 AM
In general it depends on what you are going to do with the data in second sheet. If use it as is, when yes, Power Query or dynamic array formula is enough. If to add one or more columns with any information (e.g. comments) to the data in second sheet, when some ID for the data required which allows to connect and sync both sheets.