L
leo
Hi there,
Using a macro to update values that changed;
In a workbook (PRICELIST) I keep multiple sets of three columns holding data;
Interesting now is the second and third column which hold product and price.
A separate workbook (PRODUCT MANAGMENT) holds the products and prices for
changed products only, but separated with some more colmns in between prod-no
and price. (description/weight/size etc) The later file has management of the
prices and I want to update the first workbook (PRICELIST) with the changed
prices from the second file (PRODUCT MANAGEMENT)
There may be only three lines (three changes) or 100 lines depending on the
volume of changes.
Products starting cell B7 (due to headings etc) and prices starting H7
I want PRODUCT MANGEMENT to update PRICELIST with the PRICE.
Could a macro help here? And how?
Nowadays I manually do finds on productnumber and type the new price behind
it.
Thanks for helping out
Using a macro to update values that changed;
In a workbook (PRICELIST) I keep multiple sets of three columns holding data;
Interesting now is the second and third column which hold product and price.
A separate workbook (PRODUCT MANAGMENT) holds the products and prices for
changed products only, but separated with some more colmns in between prod-no
and price. (description/weight/size etc) The later file has management of the
prices and I want to update the first workbook (PRICELIST) with the changed
prices from the second file (PRODUCT MANAGEMENT)
There may be only three lines (three changes) or 100 lines depending on the
volume of changes.
Products starting cell B7 (due to headings etc) and prices starting H7
I want PRODUCT MANGEMENT to update PRICELIST with the PRICE.
Could a macro help here? And how?
Nowadays I manually do finds on productnumber and type the new price behind
it.
Thanks for helping out