pcorpz
Active Member
- Joined
- Oct 29, 2004
- Messages
- 324
Hi MVP's! Hoping to find a macro solution that will automate several manual adjustments I need to do in our Sales Report everytime. Here's a link of my report screenshot for your reference!
https://www.dropbox.com/s/i55v6gnh1c016mb/excelsalesreport.PNG?dl=0
1) Some Credit Memo line items do not show a negative sign, but some do. I would like all credit memo line items to have a negative sign (on columns R, S, T, U, V, W).
2) If the FormatCode (column AA) is 412010000000 or 411500000000 or 412000000000, I would like to adjust the Unit Cost (column T), Total Cost (column V) and Gross Profit (column W) of these items. The Unit Cost should be 80% of the Unit Sales (column S), so it has a set 20% gross margin. This applies to both Invoice and Credit Memo line items. There's also 3 items that belongs to a different format code that needs to be adjusted as well. I've highlited these items (LABOR-KIS MNGD etc).
3) Lastly, there are invoice items that has a negative quantity (column R), I would like add a negative sign on columns R, S, T, U, V, W for these items.
I appreciate any help and tips! Thank you
https://www.dropbox.com/s/i55v6gnh1c016mb/excelsalesreport.PNG?dl=0
1) Some Credit Memo line items do not show a negative sign, but some do. I would like all credit memo line items to have a negative sign (on columns R, S, T, U, V, W).
2) If the FormatCode (column AA) is 412010000000 or 411500000000 or 412000000000, I would like to adjust the Unit Cost (column T), Total Cost (column V) and Gross Profit (column W) of these items. The Unit Cost should be 80% of the Unit Sales (column S), so it has a set 20% gross margin. This applies to both Invoice and Credit Memo line items. There's also 3 items that belongs to a different format code that needs to be adjusted as well. I've highlited these items (LABOR-KIS MNGD etc).
3) Lastly, there are invoice items that has a negative quantity (column R), I would like add a negative sign on columns R, S, T, U, V, W for these items.
I appreciate any help and tips! Thank you
Last edited:
