There is a monthly report run, where the number of columns are the same each month, but the amount of data (rows) is different
Columns A - AI are from the monthly report run
A and B are Key fields that will need to be copied to each group of columns
Beginning with column C, every 3 columns are a group (e.g.columns C-E)
Columns A-B need to be copied and inserted before each group of columns (e.g. before column F, then before the next group, which shifts, so it would be column L, and so on). I've got this working in VB
Then each column group, which is now 5 columns (A-E, F-J, etc) needs to be cut and pasted at the last row of data in columns A-E. Because the amount of data (rows) is different each month this is causing me trouble creating a script
Any assistance is appreciated
Columns A - AI are from the monthly report run
A and B are Key fields that will need to be copied to each group of columns
Beginning with column C, every 3 columns are a group (e.g.columns C-E)
Columns A-B need to be copied and inserted before each group of columns (e.g. before column F, then before the next group, which shifts, so it would be column L, and so on). I've got this working in VB
Then each column group, which is now 5 columns (A-E, F-J, etc) needs to be cut and pasted at the last row of data in columns A-E. Because the amount of data (rows) is different each month this is causing me trouble creating a script
Any assistance is appreciated