Hi Everyone

I'm looking for advice from the experts as I do not really know the best way to go. So any advice is appreciated.

I have a spreadsheet where staff enter data in Sheet 1
Sheet 2 breaks down the information more, data from the input sheet is currently coppied using formula to second sheet. I need the data duplicated on both sheets to save the viewers of the second sheet jumping back and forward. Most users only knowledge of excel is to view data.

I would like code to copy the data entered on sheet 1 over to the appropriate range in sheet 2 (dynamic range) and copy the rows formula down.

Is this a possible I have been recording macros to get an idea of how to do this but I am unsure the best way to go.

Thanks in advance