Afternoon all,
Just a quick point in the right direction if you dont mind...
I have two workbooks Book1 and Book2. Book1 is a list of shop names in Col A and total sales in Col B. Book2 is the weekly update I get with the figures, at present what i am doing is manually going through the list of stores in Book2 on each line and adding the total to the list in Book1.
What I'm after is some brief code to be used as part of a wider VBA tool to lookup the store name in Book2, locate it in Book1 and add the value already in Book1 to Book2 thereby giving me a running total of sales.
I'm sure this is pretty simple code, but i just need a quick start in the right direction.
much appreciated
colin
Just a quick point in the right direction if you dont mind...
I have two workbooks Book1 and Book2. Book1 is a list of shop names in Col A and total sales in Col B. Book2 is the weekly update I get with the figures, at present what i am doing is manually going through the list of stores in Book2 on each line and adding the total to the list in Book1.
What I'm after is some brief code to be used as part of a wider VBA tool to lookup the store name in Book2, locate it in Book1 and add the value already in Book1 to Book2 thereby giving me a running total of sales.
I'm sure this is pretty simple code, but i just need a quick start in the right direction.
much appreciated
colin