Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multiple sheets vs. 1 sheet
is it better to spread my data over mulitlpe sheets or keep them on
one sheet. (ei...) I want to access truck data, so I access the information from sheet 1 A1:D1000, now I want to access customer data. do I creat a new sheet for customer data, or just put it in sheet 1 F1:K1000, does it make any difference either way? Thanks Wally |
#2
|
|||
|
|||
I would create the customer data on another sheet, and put dropdowns on your
truck data sheet. I assume many trucks to one customer? ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Wally" wrote in message ... is it better to spread my data over mulitlpe sheets or keep them on one sheet. (ei...) I want to access truck data, so I access the information from sheet 1 A1:D1000, now I want to access customer data. do I creat a new sheet for customer data, or just put it in sheet 1 F1:K1000, does it make any difference either way? Thanks Wally |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
How do I change one cell across multiple sheets? | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |