shaelyntai
New Member
- Joined
- Oct 9, 2020
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
Hello!
I'm pretty new to Excel Macros but absolutely love them (very recently learned how to save as a PDF using the value in a cell, small wins!)
I have a pretty big ask I'm hoping someone can help with:
Essentially looking to have the values of invoice ids (column A, Sheet1) be copied into my invoice template (D2, Sheet2) [where a vlookup takes place], only if Billing = "No" (column K, Sheet1) , and then save as a pdf (name based on B5 and B12 in Sheet2). I would like this to loop through all of the rows where Column K in Sheet1 has "No"
Appreciate any assistance or insights if this would be possible, thank you!
I'm pretty new to Excel Macros but absolutely love them (very recently learned how to save as a PDF using the value in a cell, small wins!)
I have a pretty big ask I'm hoping someone can help with:
Essentially looking to have the values of invoice ids (column A, Sheet1) be copied into my invoice template (D2, Sheet2) [where a vlookup takes place], only if Billing = "No" (column K, Sheet1) , and then save as a pdf (name based on B5 and B12 in Sheet2). I would like this to loop through all of the rows where Column K in Sheet1 has "No"
Appreciate any assistance or insights if this would be possible, thank you!