Hi All,
Please see attached file for my issue. As you can see I have a horizontal array of data from F3:X222. I need to take the data and make it sequential in a continuous format in Column F. So currently I have to copy the data from G3:G222 and Paste in cell F223 and so on with each half hour. Does anyone know an easier way to do this. This is one of many days of data27-Feb.xlsx.
Thanks,
Sage
Last edited by mshirschy; 03-29-2013 at 09:44 AM.
I wrote this macro to do this job. Is this what you want?
There is more work to do before it is applied to other tabs (with more half hours)
This is fantastic! Thank you rcm!
Paste this in F223 and drag across.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks