Afternoon all
First time poster so I m hoping you can help me out.
I have a spreadsheet and I need the Command Button to do the following
1. Create a new Sheet with a DATE as the Tab title
2. Copy the NEW Stock on Hand to the SOH sheet from the Order Sheet
3. clear the Order sheet for use the next day.
I've got the Date and Clearing of the sheet part down pat, but I need it to look at the SHEET "Order Sheet, Compare the Number in cells A4 to A27 to the data in the SOH sheet Cells A2 through to A69 and then when matched the total Quantity from the matched A column number to the SOH sheet Column C.
I hope that makes sense….
Here is what I have
Hope someone can help me out if possible
First time poster so I m hoping you can help me out.
I have a spreadsheet and I need the Command Button to do the following
1. Create a new Sheet with a DATE as the Tab title
2. Copy the NEW Stock on Hand to the SOH sheet from the Order Sheet
3. clear the Order sheet for use the next day.
I've got the Date and Clearing of the sheet part down pat, but I need it to look at the SHEET "Order Sheet, Compare the Number in cells A4 to A27 to the data in the SOH sheet Cells A2 through to A69 and then when matched the total Quantity from the matched A column number to the SOH sheet Column C.
I hope that makes sense….
Here is what I have
Hope someone can help me out if possible