0

I have two excel sheets

Sheet 1

enter image description here

sheet 2

enter image description here

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

Lochana Liyange
  • 47
  • 6

1 Answers1

2

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.
Shane S
  • 1,747
  • 14
  • 31