VBA beginner here, thanks for helping.
What we are essentially trying to accomplish is creating a form-like table (Sheet 1) for EACH row (n=5000+) of Sheet 2, and saving each result as a .pdf.
So I am trying to write a macro to:
-Copy data from select cells of a single row of Sheet 2
-Paste data to select cells (different range than Sheet 2) of Sheet 1
-Save Sheet 1 as .pdf with cell A3 value as filename
-Move to next sequential row of Sheet 2 and repeat process to last row.
I've written the part to save as .pdf and it works, but need help with the rest.
Below are listed the Sheet 1 cells with the Sheet 2 columns that need to be copied FROM for each row.
Also have attached a simplified version of the workbook (Sheet 1 cells currently have formulas for Sheet 2 values, which is how we have semi-manually been creating the Sheet 1 results). macro_test.xlsm
If someone could get me started in the right direction with an approach or piece of sample code that would be great!
[Sheet 1 CELL] = [Sheet 2 COLUMN]
A3 = F
D3 = J
F3 = K
A6 = H
D6 = B
F6 = BN
A9 = G
A12 = L
A21 = X
B21 = Y
C21 = Z
D21 = AA
E21 = AB
F21 = AC
G21 = AD
A25 = AE
B25 = AF
C25 = AG
D25 = AH
E25 = AI
F25 = AJ
G25 = AK
A29 = AL
B29 = AM
C29 = AN
D29 = AO
E29 = AP
F29 = AQ
G29 = AR
A33 = AS
B33 = AT
C33 = AU
D33 = AV
E33 = AW
F33 = AX
G33 = AY
A37 = AZ
A43 = BG
B43 = BH
C43 = BI
D43 = BJ
E43 = BK
F43 = BL
A47 = BM
Bookmarks