Hi,
I generate reports (via Chrystal) of varying length each day/month/whenever, all are formatted the same way, "product codes" are my rows and "Customer name" are my columns.
Each product code is designated 2 rows, the row directly to the right of the product code (let's call it row A) shows the number of items purchased and directly under row A (let's call it row B) shows the average cost of the product. This is replicated across the entire report under each of the Customer Name columns. This culminates in a total units sold per period (row A) and average price overall in row B
I want to write a macro (i understand it may be a number of macros) that moves row B to the right hand side of row A, which requires inserting a column beside customer name. There are a number of other smaller macros I may be able to write but the biggest hurdle I have is..HOW do I get the macro to redo itself or is the term loop around so I can hit the start button and ZIP it's all re-formatted.
Cheers