I'm using a workbook with multiple sheets of data...
Trying to insert pictures onto Sheet 1 (horizontally across a row - cells A1 thru F1) using external references found on Sheet 2 (located in vertically in Column A, rows 1 thru 6) - see below:
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
Each "http" link is separately contained in a cell on Sheet 2 in Column A, rows 1 - 6; if hyperlinks are "clicked" - they currently open a picture in a separate window; I'm trying to auto-input their "picture output" into cells on the first row of Sheet 1...
i.e. Sheet 1 - cell A1 ("actual picture") should correlate to source data ("http://...") found in Sheet2 cell A1; Sheet 1 - cell B1 ("actual picture") should correlate to source data ("http://...") found in Sheet2 cell A2
The one variable is that only cells on Sheet 1 should be filled (with a picture) if there is a reference on Sheet 2; for example, if only cells A1 through A4 contain external source data (i.e. A5 and A6 are empty or "0") - then only the corresponding cells on Sheet 1 should contain pictures (i.e. A1, B1, C1 & D1) while cells E1 and F1 should remain blank or empty...
Is this possible?
Can anyone help me to create this macro/picture bridge?
I'm inexperienced w/macros & visual-b - have tried some hyperlinking, etc. as well as some macros - but continue to have difficulty with creating consistent, efficient output and/or macros that do not require debugging.
Many thanks in advance!
BrettF
Trying to insert pictures onto Sheet 1 (horizontally across a row - cells A1 thru F1) using external references found on Sheet 2 (located in vertically in Column A, rows 1 thru 6) - see below:
| http://www.trendmls.com/AssetLocator/getAsset.ashx?EntityType=Listing&AssetType=Image&BusinessPartnerID=1&ImageNumber=1&ImageVersion=LRG&MlsNumber=6092513 |
| http://www.trendmls.com/AssetLocator/getAsset.ashx?EntityType=Listing&AssetType=Image&BusinessPartnerID=1&ImageNumber=1&ImageVersion=LRG&MlsNumber=6104375 |
| http://www.trendmls.com/AssetLocator/getAsset.ashx?EntityType=Listing&AssetType=Image&BusinessPartnerID=1&ImageNumber=1&ImageVersion=LRG&MlsNumber=6107512 |
| http://www.trendmls.com/AssetLocator/getAsset.ashx?EntityType=Listing&AssetType=Image&BusinessPartnerID=1&ImageNumber=1&ImageVersion=LRG&MlsNumber=6207986 |
| http://www.trendmls.com/AssetLocator/getAsset.ashx?EntityType=Listing&AssetType=Image&BusinessPartnerID=1&ImageNumber=1&ImageVersion=LRG&MlsNumber=6216526 |
| http://www.trendmls.com/AssetLocator/getAsset.ashx?EntityType=Listing&AssetType=Image&BusinessPartnerID=1&ImageNumber=1&ImageVersion=LRG&MlsNumber=6237933 |
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
Each "http" link is separately contained in a cell on Sheet 2 in Column A, rows 1 - 6; if hyperlinks are "clicked" - they currently open a picture in a separate window; I'm trying to auto-input their "picture output" into cells on the first row of Sheet 1...
i.e. Sheet 1 - cell A1 ("actual picture") should correlate to source data ("http://...") found in Sheet2 cell A1; Sheet 1 - cell B1 ("actual picture") should correlate to source data ("http://...") found in Sheet2 cell A2
The one variable is that only cells on Sheet 1 should be filled (with a picture) if there is a reference on Sheet 2; for example, if only cells A1 through A4 contain external source data (i.e. A5 and A6 are empty or "0") - then only the corresponding cells on Sheet 1 should contain pictures (i.e. A1, B1, C1 & D1) while cells E1 and F1 should remain blank or empty...
Is this possible?
Can anyone help me to create this macro/picture bridge?
I'm inexperienced w/macros & visual-b - have tried some hyperlinking, etc. as well as some macros - but continue to have difficulty with creating consistent, efficient output and/or macros that do not require debugging.
Many thanks in advance!
BrettF
