LinkBack URL
About LinkBacks
I am in the process of creating a spread sheet containing monthly data. As this is an ongoing report dating back to 2011 there are several hundred thousand rows of data. Not every month has been recorded in the same way so it involves column manipulation. Each column is thousands of rows long. As you could imagine its very time consuming. I have searched for Macros online and have found one that is close but not quite what I am after. Just wondering if you or anyone else might be able to help?
So the macro needs to detect and rename columns where required as well as reordering and copying and pasting.
The Master should read as an example:
A B C D E F G H
However some months might be
A B C E D F G H
(Where some columns are out of order)
or
A BB C D E FF G H I
(Where some columns are named slightly differently or there are additional columns.
The intent is to not only reorder existing info (hundreds of thousands of lines of it) but to have a macro which will sort the new data as it comes to hand.
Im aiming to have the first tab as a master sheet with the cumulative information being added and then with subsequent sheets showing individual monthly data.
Can anyone help me please?
Register To Reply
Bookmarks