Hello,

I have an excel file with 3 worksheets:
  • Summary Sheet
  • Data Entry Sheet 1
  • Data Entry Sheet 2

The Column titles in all three sheets are the same.

Everytime a record is entered in data entry worksheet 1 or 2, I want that same record to appear (just below the last entered record) in the summary worksheet.

How do I do this?