I have two excel sheets

Sheet 1

sheet 2

My question is how to joins this two excel sheet for when I delete sheet 1 first record (Dr.John BHRM 11213 Principles of Management) then need to delete first record in second sheet automatically

Anyone can help me

CodePudding user response：

You should make sheet 2 be a powerquery of sheet 1. Look at some examples of powerquery in excel. steps.

1. Convert the data in sheet 1 to a table
2. Follow the steps 1 & 2 here
3. Rename & reorder columns.
4. click close and load.
5. You can set refresh conditions under the Data tab.