B
bsharp
I am trying to create a template so I can have 6 photos load automatically to
one of the worksheets. The photos will come from a folder on my hard drive
and Excel will look in the folder based on my input of one cell. The photos
will be labelled with numbers 1-6. So the path will be exactly the same each
time, the only variable will be the one folder name.
I have created a large worksheet to track my real estate properties for
sale, and one of the worksheets is a flyer. So the pictures need to be placed
precisely where they are supposed to go. I realize Publisher is a better
flyer program, but I have everything else in Excel, and this way the price,
address, etc. will auto-fill for me based on what I input on the first
worksheet. I save all the workbooks as the property address, so I was hoping
to just insert the address into the filepath to go grab pictures #1, 2, etc.
one of the worksheets. The photos will come from a folder on my hard drive
and Excel will look in the folder based on my input of one cell. The photos
will be labelled with numbers 1-6. So the path will be exactly the same each
time, the only variable will be the one folder name.
I have created a large worksheet to track my real estate properties for
sale, and one of the worksheets is a flyer. So the pictures need to be placed
precisely where they are supposed to go. I realize Publisher is a better
flyer program, but I have everything else in Excel, and this way the price,
address, etc. will auto-fill for me based on what I input on the first
worksheet. I save all the workbooks as the property address, so I was hoping
to just insert the address into the filepath to go grab pictures #1, 2, etc.