Hi
I have a workbook with several sheet in it, one being “Prices”
This needs to be updated and at the moment the prices are sent to me on another workbook
what I have to do is highlight the prices on the sheet on the master price list and copy then paste into the “Prices” sheet on my workbook
what I want is vba that will be available as a macro in my workbook to import the latest prices from the master prices sheet in the other workbook and overwrite the “Prices” in my workbook
suggestions please
I have a workbook with several sheet in it, one being “Prices”
This needs to be updated and at the moment the prices are sent to me on another workbook
what I have to do is highlight the prices on the sheet on the master price list and copy then paste into the “Prices” sheet on my workbook
what I want is vba that will be available as a macro in my workbook to import the latest prices from the master prices sheet in the other workbook and overwrite the “Prices” in my workbook
suggestions please