Forum Discussion
Connect one sheet to another
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...
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.