Quote:
Originally Posted by UbinTook
Maybe someone can direct me on how to create this:
I have zero experience with Excel( if someone wants to knock this out i would be eternally grateful)
My wife has an Extensive inventory of high end beads she need to inventory.
each page will have a header that she can type a generalized description:
"Loom beads, seed size 8" for example (Left justified but add about 10 spaces from left margin)
Each page will have 3 columns
the top of the following page will be a continuation of the bottom of the previous page.
(ignore dashes this is the only way i could get it to format here)
Quantity ------------Color Number----------Description
0-999 ----------------8 alphanumeric---------Typed description
The "color number" (column 2) needs to control sorting, BUT the whole line to include columns 1(quantity) and 3 (description)for that line need to move with it .
The "color numbers" are in a number of formats
Numerical
34
Alpha Numerical in various forms:
X345
XX345
3456X
X34567X
She would like to sort first by the first numeral in the item number
then start to consider the Alpha in this order
345
345X
X345
XX345
X345X
Column 1 needs to accommodate 3 digits at most (0-999)
Column 2 needs to accommodate 8 digits
Column 3 can be set to be as wide as necessary to take up the rest of the space on that side of the page for description
there should be delineation for each line, but not each column (like lined paper)
_________________________________________________
_________________________________________________
but data in each column should be (invisibly)justified to the left in that column they all start "In Line"
She needs to be able to add a line ( a new addition to the inventory and insert it wherever she needs to and have the spreadsheet re-sort accordingly).
Finally these need to print nicely so they are easy to reference.
I appreciate any advice or direction on how to accomplish this.
Sorting is dead easy. You just select the columns you want to sort and use either the Sort or Filter function. It's very powerful and quite user friendly.
However your desired sort criteria are pretty convoluted compared to standard A-Z or High-Low. I'm sure it's technically possible, but it's going to be a challenge to implement. If possible, I would suggest adopting a new system of coding to conform to standard alphabetical sorting.
Alternatively, by using the Sort and Filter functions together, you may be able to achieve what you are looking for in another way. For instance, sort descending by quantity on hand, then filter for only the model #s that you are interested in.