How to link two excel sheet in same excel file

Question

I have two excel sheets

Sheet 1

Sheet 2

 

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

Answer 1

It would be best if you made sheet 2 a power query of sheet 1. Look at some examples of power queries in excel. steps.

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

I hope this helps you.