Hi UK,
I think the attached VBA code will do what you want as far as updating the four cells is concerned. You should insert it into the VBA module FOR THE WORKSHEET CONTAINING THE DATA - right-click on the worksheet tab & select "View Code"
You can edit the following line to suit the address of the cell into which you will be entering the data:
As far as transferring the data from the fifth cell is concerned, you'll have to give me some more information. The value will need to be entered automatically (using VBA code) into its new destination - i.e. it will not be "moved" using formulas etc., so please let me know where it needs to be stored (e.g. at the end of another list? - note, placing it at the end of a list is slightly less involved than placing it at the beginning.)
Hope this is of some assistance to you - please let me know how you get on.
regards,
Greg M
Bookmarks