Hello everyone, and thanks in advance for the help.

I sell a number of items and am using an excel sheet to keep track of
them. I currently have it set so that a number of buttons I click
increment a column of numbers that show how many I need to make of that
item (to replenish stock). I then have a 3rd column keeping track of how
many I have sold of that item. Here is an example:

Item A | 5 | 103

In this example, I have recently sold (and need to make) 5 of item A.
In the past I've sold 103 total.

Currently, I'm doing it all manually. I need a macro that will add the
numbers in column B into column C and then delete column B.

So in the example above, after running the macro, it would look like:

Item A | 0 | 108

I have a large number of rows I need this done on, and more rows may be
added in the future.

If you need any more information, please let me know.


--
Onyx
------------------------------------------------------------------------
Onyx's Profile: http://www.thecodecage.com/forumz/member.php?userid=290
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93859

Hi

Add another button to "Update Totals", and call this macro (change the
Sub name as required. In my example qunatities recently sold is in
B2:B10.

Private Sub CommandButton1_Click()
Dim TargetRange As Range
Dim Cell As Range
Set TargetRange = Range("B2:B10")
For Each Cell In TargetRange
Cell.Offset(0, 1) = Cell.Offset(0, 1) + Cell.Value
Cell.Value = 0
Next
End Sub

Hopes this helps.

---
Per

On 6 Maj, 19:19, Onyx wrote:
Hello everyone, and thanks in advance for the help.

I sell a number of items and am using an excel sheet to keep track of
them. I currently have it set so that a number of buttons I click
increment a column of numbers that show how many I need to make of that
item (to replenish stock). I then have a 3rd column keeping track of how
many I have sold of that item. Here is an example:

Item A | 5 | 103

In this example, I have recently sold (and need to make) 5 of item A.
In the past I've sold 103 total.

Currently, I'm doing it all manually. I need a macro that will add the
numbers in column B into column C and then delete column B.

So in the example above, after running the macro, it would look like:

Item A | 0 | 108

I have a large number of rows I need this done on, and more rows may be
added in the future.

If you need any more information, please let me know.

--
Onyx
------------------------------------------------------------------------
Onyx's Profile:http://www.thecodecage.com/forumz/member.php?userid=290
View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=93859