My problem is thus.
I have a workbook linked to an external source that is refreshed once a week.
All the refreshed data is populated in column A. User defined text is typed into columns B,C,D and E.
As the report increases or reduces in column A the text in B,C,D and E becomes out of sync with its original data in column A.
Is there a way of keeping the data and tagging it somehow?
Moderators.Please move this if its in the wrong forum