Ahhh ok almost.
A quick explanation as to how my file works, the copy paste tranpose part of the macro is basically collecting 1 or 2 ID numbers and dropping them into the display sheet (Measure Overview). These two numbers drive the information that appears on this sheet At this point I need the macro to PDF the Measure Overiview page before it goes to the next copy and paste loop.
The copy paste transpose part of the macro has to be pasted into cell S2 (Measure Overview) each time. I think VBA above is copying the data into S2 then T2 then U2 etc and then PDFing which is not quite what I want.
Bookmarks