Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
Hi,
I try to learn how to write macros€¦ having problem with arranging a cycle. I have a data that looks like that: Column A consist accounts #, rows B through M the $ value, meaningfully attached to the cells B2, C2€¦M2. A B C ... M 06/01/31 06/02/28 March - Nov 06/12/31 1111111 26000 28000 30000 22000 2222222 11000 10500 10000 12500 3333333 13000 11500 20000 21000 I need to rearrange my data to look like that: 1111111^06/01/31^26000 1111111^06/02/28^28000 €¦ 1111111^06/12/31^22000 The same has to be repeated 12 times for every next account until the end of the sheet. How would I do a macro for that? Any help will be appreciated, Thanks a lot, Lu. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
Macros inside macros, and pasting into macro code. | Excel Programming | |||
convert lotus 123w macros to excel macros | Excel Programming | |||
Open workbook-macros enabled, opening another with macros | Excel Programming | |||
Macro Size Limit / open macros with macros? | Excel Programming |