If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 A11000, 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 A11000, 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lookup values in multipul sheets and show value in another sheet | Kim | Worksheet Functions | 3 | June 17th, 2005 01:56 PM |
splitting 1 sheet to multiple sheets | dfeld71 | General Discussion | 5 | June 9th, 2005 07:51 PM |
Combine multiple sheets into one sheet? | Blueluck | General Discussion | 2 | June 8th, 2005 08:56 AM |
Return Maximum Value from multiple sheets | NickMinUK | General Discussion | 1 | August 24th, 2004 06:14 PM |
multiple sheet selection | Vasant Nanavati | Worksheet Functions | 0 | October 18th, 2003 04:58 AM |