Yeah, up to 3 in this example but in reality it could be 15 classes, we are looking at increasing it to have a better database and filter-ability (is that a word?). However if I get help with 3 I can adapt the code to the other 15 or however many we will end up at.
The first 6 digits are the BILLTO, the next 3 are the SHIP to. However addresses can be the same or different and that is what makes it tricky. Sometimes the companies have a headoffice where it's billed, but shipped to their separate companies.
so yes your 000 and 001 example of same first 6 digit and different addresses can happen. that is a preferred situation, it's when they are the same is what is annoying and would like them on 1 line instead of 2.
As for your chart, it would work, I was just brainstorming with a coworker and they brought up another obstacle. But to continue with your chart idea, I always look at the main 6 digits, then look for the price class (level). So i would look for 012345 then shoot my eyes across to 0000 or 0004. so your method would work. I would look for the first 6 digits, then for the norm, discount or government column to see the dash 000 or 001 etc.
my coworkers obstacle is that, sometimes the account numbers can be 012345 and 234567 but they have the exact same company name and address 1/2. so I would also want that in the same row, but now what do we do if we have 2 or more account #'s with price class (level) of 0000?
Is it possible to have those account #s in 1 row, but ALT+Entered into a cell? so if you click on the cell, they are on separate lines, but in the same cell.
I hope that made sense. I have tried to adapt your table to visually show what I mean.
Account #
Company Name
Address 1
Address 2
Norm Pricing
Discount Pricing
Government Pricing
012345
234567
ABC Shop
123 Fake Street
STE 204
012345-000
234567-000
234567-002
012345-001
234567-001
056789
DBC Shop
425 Fake St
56789-002
051256
DEF Shop
100 Street
51256-005
I have attached a real sample from my database to show you.
Reply With Quote