Hi Guys,
This is probably very simple for those of you with a bit of experience but here goes.
I have stock list, there is a column of data on one sheet 1 for orders and the orders has various stages (work in progress, paid, on the way, arrived). I also have a column of data on sheet 2 for stock held. At the moment I have to manually delete all of the stock from the column on sheet 1 when the status becomes "arrived" and add it to the stock held column on sheet 2. There are many rows of stock so its easy to make mistakes and time consuming having to do it manually.
Can someone please tell me how to set up a macro/VBA code so that when I click a button a calculation is preformed where it goes down the column on sheet 1 and adds the numbers to the column on sheet 2. There is the same amount of items on both sheets and the positioning if each is the same only the data starts a few rows lower on sheet 1,but apart from that the layout identical. Hope that makes sense.
To illustrate as a one off calculation on a button click I want to add:
(bold references are on sheet 1, plain on sheet 2)
G5 + C2
G6 + C3
G7 + C4
G8 + C5
etc etc right down to G57 to C54
Help much appreciated,
Michael
Bookmarks