Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ideas for a current project @ my new job, please!
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ideas for a current project @ my new job, please!
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. -- John C "suziiiiiii" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ideas for a current project @ my new job, please!
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! "suziiiiiii" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ideas for a current project @ my new job, please!
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 "suziiiiiii" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
Accessing current project path | Excel Discussion (Misc queries) | |||
Trying to report the current phase of a project | Excel Discussion (Misc queries) | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
Can I automatically enter the current date or current time into a | New Users to Excel |