Hello Forum
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
thanks
pukks
Re: Retaining Data From Worksheet Being Refreshed
pukks,
With Excel and Ozgrid, there is almost certainly a way. First, we need to know what the relationship of B, C, D, and E is to the data in column A. For example, does B-E change? When, how, why? Can a list of the things in B-E be made and used as a lookup table for the things in column A? Sometimes the best thing is to post an example of the data before and after the changes.
Jim
Re: Retaining Data From Worksheet Being Refreshed
Hello Jim
Workbook attached.
the data in columns b,c,d and e are just pure text entries.You can see that after the report has refreshed the text entries remain in there original place.New part numbers naturally do not have entries beside them as the user hasn't updated the sheet.
Now the part numbers PORTP015CPS and PORTP022DRS have dissapeared but the text in cells B12 - E15 are the same as they were in B3 - E6.
Hope this is clear
pukks
Re: Retaining Data From Worksheet Being Refreshed
How did the stuff in B-E get populated in the Before scenario in the first place? If someone just types it in, could you store the Before entries and just add the NEW After entries so someone can type stuff in for them?
Jim
Re: Retaining Data From Worksheet Being Refreshed
Hi Jim
Don't think thats possible, the list will be 300 part numbers long,some the same , some different. We dont know which part numbers will be there until after the report has been refreshed. Hope this is clear.
pukks
Don’t have an account yet? Register yourself now and be a part of our community!
