1vanY
New Member
- Joined
- Aug 19, 2014
- Messages
- 7
So we sell bare roots that have different pricing when you buy bulk.
Generally, If you buy 1-2 plants, they're $4 each. If you buy 3-11, they're $3 each. 12-35 = $1.75/ea. 36-99 = $1.25.
When we export an Inventory report out of our Order Processing software into Excel, Excel thinks that the price breaks (4-3) is actually a date of 4/3.
I'm aware that you can create custom formats for cells, but we have so many price breaks that it seems to be too large of a string to fit all the price breaks.
Is there a way to create a table and use that as a reference to format cells?
"Price Matrix Legend": Shows example of how the report Should look
"Custom Format":
* Original Report Worksheet: Shows how the original report exports into Excel from our order processing software
* PRICE MATRIX Worksheet: Shows the custom formatting that we need to use
* PRICE MATRIX pic: Shows the custom formatting I'd like to choose, so Excel knows how to interpret values
If this exceeds Excel's limitations, then maybe a mass 'Find and Replace' method would work better...
My apologies if this sounds confusing or left anything out!
Thank you in advance!
Also posted here Is there a way to create a table and use that table to format cells
Generally, If you buy 1-2 plants, they're $4 each. If you buy 3-11, they're $3 each. 12-35 = $1.75/ea. 36-99 = $1.25.
When we export an Inventory report out of our Order Processing software into Excel, Excel thinks that the price breaks (4-3) is actually a date of 4/3.
I'm aware that you can create custom formats for cells, but we have so many price breaks that it seems to be too large of a string to fit all the price breaks.
Is there a way to create a table and use that as a reference to format cells?
"Price Matrix Legend": Shows example of how the report Should look
"Custom Format":
* Original Report Worksheet: Shows how the original report exports into Excel from our order processing software
* PRICE MATRIX Worksheet: Shows the custom formatting that we need to use
* PRICE MATRIX pic: Shows the custom formatting I'd like to choose, so Excel knows how to interpret values
If this exceeds Excel's limitations, then maybe a mass 'Find and Replace' method would work better...
My apologies if this sounds confusing or left anything out!
Thank you in advance!
Also posted here Is there a way to create a table and use that table to format cells
Attachments
Last edited by a moderator: