I have a particular problem where I want to delete some data from a day light saving spreadsheet (please see attached sheet). I want to delete cells E1, F1, G1, H1 and I want the data to wrap around so that it pulls in values CS211, CT211, CU211, CV211 at the bottom of the spreadsheet. The way it works for me is it just pulls blank values (CS1, CT1, CU1, CV1) in the same row which i dont want.
Is there a manner where you can tell excel to wrap to different rows.
Regards,
Fintan
Bookmarks