Transposing a Magazine Imposition

[mrhooper]

I transpose a lot of impostions for magazines into workable worksheets for people to track. I have tried to create a macro to do this as the conversion is almost the same every time. I have given up and simply do it manually for each row at a time. This is the way they make them and have resisted my suggestions to reformat to save time. Im sure that someone who works with macros would not have any problem figuring out how to do this. Any suggesstions would be appreciated... I attached the starting file and the finished file to look at.

thanks in advance

[protonLeah]

The macro below populates all but column F (Store). I don't know where you get that info from on the sheet.

Please Login or Register  to view this content.

[mrhooper]

Excellent job, it works perfect except for one thing I cant figure out. The attached file shows where I ran the macro and for some reason it skipped some cells. I tried reformatting and copying to a new file but with no luck.

[protonLeah]

The problem was with the line Set PointerToBox = .Find(BoxID). Notice that cell E6 has LOCAL AD Lafayette 148

So, when the counter in the loop got to 8 it found that cell instead of cell A7, when the counter got to 14 and 48, it found that same cell. Since the cell above it is blank no data was copied.

The code below fixes that by forcing the .Find to look at the entire contents of the cell.

Please Login or Register  to view this content.

[mrhooper]

Well you make it seem so simple! I see what happened after your explanation.
Thank you again for your help, saved me some time and gave me a better understanding of macros in excel.

Cheers!