I am brand new to Macros - in fact, I really do not know what I am doing with them at all.
I would like to see if I can create a macro to even more simplify the repetitive tasks that I need to do. This will reference the Macro solution that was given to me in Post #4 on this link: http://www.excelforum.com/excel-gene...ml#post3679700
I gave a simplified version of what I am actually trying to do because I didn't expect as awesome of an answer as I got - and, it seems, with using a Macro, I could get Excel to do even more for me.
Here is a table of exactly what I am looking at
SHEET 1
That is the basic setup and it goes for about 500,000 rows and I have almost 5,500 workbooks. So the idea of automating my tasks as much as possible is extremely appealing
A B C D E Date&Time Ask Price Bid Price Ask Volume Bid Volume 2007.03.25 21:00:03.496 1.64845 1.64785 1 1
Following the pattern on the link that I gave above, I would like the following:
ASK (This is Sheet #2 having been renamed)
(concatenation of Time, Ask Price, & Ask Volume...all separated only by a ";")
A B 20070325 210003;1.64845;1
BID (Rename of Sheet 3)
(concatenation of Time, Bid Price, & Bid Volume...all separated only by a ";")
A B 20070325 210003;1.64785;1
And, with the answer, could you also share with me precisely how I am supposed to enter this Macro into excel and also if there is some way of being able to this in a batch, rather than each file individually?
thank you very much and I deeply appreciate any help that anyone is able to give to me.
Bookmarks