Ideas for a current project @ my new job, please!

S

suziiiiiii

I just started a new job, and I'm researching why some items aren't shipping
correctly. Well, they've asked me to create a detailed spreadsheet with about
10 columns of information. But I've got a problem....The information in each
column per item only takes one row, except for one. It's the location. But
for each item, we have random numbers of locations. And so, while entering
information, I'm getting annoyed @ the one column taking up extra rows, since
it has more than one row worth of information. I wish I could explain it
better! Hmm. For example, there are three columns: "Date" "Item Number"
"Locations" . Now you just have one date to enter, one item number, but when
you put in all the locations, you've used like 4 row below it. Now there is
all that blank space between the rows (except on the location column) and I
think it looks terrible! Any creative suggestions for this? I was considering
a drop down list, but I wanted to see what the experienced users might think.
 
J

John C

If that is the extent of your information, you could have 4 columns and
labeled as Location 1, Location 2, Location 3, Location 4, and just leave
blank if they don't have second, third or fourth locations.
However, if you have more data such as quantities, then you probably want
the multiple rows, because you might have 5 of the item in location 1, and 15
in location 2, etc. If this is an inventory tracking question, and I presume
it is, then you want and most likely need those extra 'rows'. Note: You
should populate the part number and other pertinent information in the second
and third rows as well.

Hope this helps.
 
S

Sean Timmons

First, congratulations on the new job!

Drop-down may be nice. Actually sounds like it may even be better in Access.
You can have the first two in one table, then link them to a third table
where locations are input. But, that's up to your new company!
 
O

Otto Moehrbach

Suzi
I think your solution will depend on what you plan on doing with this
sheet full of data. If it's just for viewing by someone, then the Drop-Down
cell for location sounds OK except that setting up all those drop-down cells
is tedious and time consuming. However, if you are planning on manipulating
this data in some way, I would recommend that you think about putting all
that data, locations and all, in one row per item number. Since the number
of locations is variable and all the other entries are singles, I would say
to put the locations after (to the right) of all the other data. Again,
what you will be using this data for is the important factor. HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top