Button/Macro to copy data from one sheet to another (price list data to quote)

[redwood88]

Hi,

My excel skills are very limited so I was hoping someone could assist.

I have a spreadsheet containing price list data for a few thousand products i sell. When producing a quote, i copy and past data from selected cells between to two documents/tabs to produce a quote. I was looking to add a button/macro to each row of data, so that if i want to add that item to the quote i could click the button and it would automatically populate the second spreadsheet (quote) with the data in the correct columns automatically. It would also need to do this in a new row each time as to not overlap data on the same row.

Is this achievable?

Spreadsheet attached (prices changed due to privacy).

[AlphaFrog]

With the code below; when you double-click on an item in column A or B on the parts sheet, it will add it to the next empty row on the quote sheet and select the quote sheet quantity cell for your input.

To install the code:

• Right-click on the 2020 $AU sheet tab.
• Select View Code from the pop-up context menu.
• Paste the code from below in the worksheet's code module.

Please Login or Register  to view this content.

Note: don't put anything in column A at the bottom of the quote sheet. If you do, the code will have to be modified.

[redwood88]

Thank you for this,

You have saved me hours of work.

I have added another column (J2:J1433) with images (jpg) of each item. Is there anyway to get this to copy over into a picture column on the quote (H)? I'm struggling with this as the image is not technically data in the cell, more of an image floating over the cell.

[AlphaFrog]

Please Login or Register  to view this content.

[redwood88]

Champion. Thanks Mate!!