Partsguy100
New Member
- Joined
- Nov 12, 2018
- Messages
- 6
I have a spreadsheet that is being used as a PO template. I would like to create a poor-person database of past purchases by having this information copied to another tab on the workbook then finally, copy all the non-zero values to another spreadsheet where I would like to continue to add data after every PO is created.
PO Excel sheet
Info automatically copied to tab 2 from PO body ( above)
There are 10 lines on the PO and I want a macro to ONLY copy the lines that are non zero and past to a MASTER spreadsheet that would continue to be appended with each PO that is created. Just wondering if can write a macro to perform this task.
PO Excel sheet
Info automatically copied to tab 2 from PO body ( above)
There are 10 lines on the PO and I want a macro to ONLY copy the lines that are non zero and past to a MASTER spreadsheet that would continue to be appended with each PO that is created. Just wondering if can write a macro to perform this task.