stirlingmw1
Board Regular
- Joined
- Jun 17, 2016
- Messages
- 53
- Office Version
- 2016
- 2013
- 2010
- 2007
- Platform
- Windows
I have a Workbook I am using to record ammunition allocation for some of my ships. Basically when I click the Add button quantities are selected from one worksheet that correspond to what has been selected in two comboboxes. it then sends that data to a new worksheet "WSName1". This all works fine until I am allocating for another ship. How do I add the new amounts to the previous amounts?
The VBA I am using to transfer the data is:
thanks in advance
Steve
The VBA I am using to transfer the data is:
VBA Code:
If CmboAsset.Value = "OPVB1" And CmboApr.Value = "OPVB1 OST" Then
Worksheets(WSName1).Range("C3:C" & Lastrow3).Value = Worksheets("Requirements").Range("I3:I" & Lastrow).Value
End If
thanks in advance
Steve