Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Wally
 
Posts: n/a
Default 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   Report Post  
Anne Troy
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Append the data given in diff sheets of an Excel File to one sheet sansk_23 Excel Worksheet Functions 3 May 10th 05 02:00 AM
Multiple worksheet queries liam Excel Worksheet Functions 3 February 16th 05 07:52 PM
How do I change one cell across multiple sheets? bobby„¢ Excel Discussion (Misc queries) 1 January 26th 05 01:22 AM
Linking sheets to a summary sheet in workbook gambinijr Excel Discussion (Misc queries) 4 December 16th 04 09:13 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 08:43 AM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"