ROBINSON_US
New Member
- Joined
- Feb 27, 2006
- Messages
- 25
I've conquered some pretty crazy stuff with vba but this one is a doozy... Not sure if this can even be done with vba, but, I need to insert a pdf file into my worksheet, based upon a cell's value - which is the corresponding pdf file name. I've attached a test sheet image; xl2bb seemed to screw up the layout and format. In cells A3, A7, A11 & A15, I have an invoice number. Below each of those cells, is another, with the text "Total Price Diff Charge". Right under that cell, I need to insert the pdf file that corresponds to the value in the cell above it.
I need to mention that I have a bunch of these sheets, all with 1500 or more entries. The layout is consistent, and doesn't change. So, the invoice number will always start with A3, and continue to A7, A11, A15, (every 4 rows, etc.), until the end of the worksheet.
Any insight would be considered a life saver!
Thanks
I need to mention that I have a bunch of these sheets, all with 1500 or more entries. The layout is consistent, and doesn't change. So, the invoice number will always start with A3, and continue to A7, A11, A15, (every 4 rows, etc.), until the end of the worksheet.
Any insight would be considered a life saver!
Thanks