Hi,
I am trying to find a way to achieve the following without VBA if possible. I want to use one sheet where users just paste data in a predefined format (source sheet). Then have another sheet which essentially just references\takes\copies all of the data from the source sheet (processing sheet). On the processing I'll be creating new fields with formulas appended on to the source data. I don't want users touching this sheet. Would prefer to have them simply paste the data into the source sheet and not have to worry about affecting formulas etc, Then the processing sheet will be automatically updated with all of the new fields.
Just wondering what the smartest way to do this is. I'm trying to avoid creating a macro to copy the data.
Many Thanks
Bookmarks