Andy Walker
New Member
Hey Guys
Here's my problem.
I click on a thumbnail image and a copy of it is immediately copied and pasted into my printable document constructed on an Excel sheet.
At the same time we jump to a sheet referenced by the macro behind the image that contains a matrix price list for the item clicked on.
All working perfectly thanks to your help yesterday, ref clicking on images.
Now, what I need to do is click on the cell in the matrix with the price required for that size of item and the value selected is carried back and inserted in a cell in the printable document beside the image.
The Column number is constant at (7) but the row would be between 1 and 20 depending where the active cell remained when we jumped.
Any thoughts please, on how to collect the number from the matrix cell and reference the row and column on the Printable document to paste it in the correct position.
Many thanks for reading this.
Andy
Here's my problem.
I click on a thumbnail image and a copy of it is immediately copied and pasted into my printable document constructed on an Excel sheet.
At the same time we jump to a sheet referenced by the macro behind the image that contains a matrix price list for the item clicked on.
All working perfectly thanks to your help yesterday, ref clicking on images.
Now, what I need to do is click on the cell in the matrix with the price required for that size of item and the value selected is carried back and inserted in a cell in the printable document beside the image.
The Column number is constant at (7) but the row would be between 1 and 20 depending where the active cell remained when we jumped.
Any thoughts please, on how to collect the number from the matrix cell and reference the row and column on the Printable document to paste it in the correct position.
Many thanks for reading this.
Andy