One more for today:
I have a workbook with two worksheets, both having similar data in the columns.
I want to set this up so that if I insert new rows into Sheet1 they are also insterted automatically into Sheet2 in the same place.
The rest of the sheets will have formulas and calculations but for simplicity they are not included on the attached book.
I hope to set up a quite large workbook and several people would use it, so ideally I'd like this to happen without the user knowing it. I think if it was a macro, they would need to perform an action to run the macro - but that's not what I'm after.
Is there a way to do this?
Bookmarks