Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sgreen
 
Posts: n/a
Default How do I combine two worksheets in Excel?

We are needind to combine data from sevral spreadsheets into one or somehow
create a link that can help keep us updated in order to keep track of what is
going on with production and where our jobs are standing? can anybody help or
walk me through this I am still newto excell. Thank you for anything you can
offer
  #2   Report Post  
Bill Ridgeway
 
Posts: n/a
Default

If you have several spread-sheets for a particular task you are likely to
have duplicated data. This is not only wasteful of inputting but also prone
to discrepancies from mis-keying and from spread-sheets being updated out of
sync. Also any 'structural' change to a spreadsheet may cause a knock-on
discrepancies on other spread-sheets. It is, therefore, far better to have
all data on one particular task in a single spread-sheet. I would assume
you have experienced at least some of these symptons.

A general comment is that, in the long term, it would, probably, be better
to redesign the spreadsheet from first principles. Although this may take
longer you will have a much more stable spread-sheet. Mucking about with a
quick fix now will probably result in you forever having to meddle with it
and it may never be right. That's not to say that if you do start again
that it will never need to be changed. It's just that ongoing changes can
be better implemented.

Getting to answer your question more directly is difficult without further
information. Please email me off list.

Regards.

Bill Ridgeway
Computer Solutions

"Sgreen" wrote in message
...
We are needind to combine data from sevral spreadsheets into one or
somehow
create a link that can help keep us updated in order to keep track of what
is
going on with production and where our jobs are standing? can anybody help
or
walk me through this I am still newto excell. Thank you for anything you
can
offer



  #3   Report Post  
Sgreen
 
Posts: n/a
Default

Maybe you can give me an idea of what to do. We have several spreadsheets
that are used in shared files. We are looking for a more efficent way of
handleing this. We have to link the 3 main ones to track production,
blueprints, and drafting documents, I think there is a way to do this in
excell but am not sure of how. I have basic skills nothing beyond that. Any
thoughts would be helpful. Thank you
Very Sincerely,
Sandra Green

"Sgreen" wrote:

We are needind to combine data from sevral spreadsheets into one or somehow
create a link that can help keep us updated in order to keep track of what is
going on with production and where our jobs are standing? can anybody help or
walk me through this I am still newto excell. Thank you for anything you can
offer

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
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Want Excel to break links between worksheets in same file eclectic_kx Excel Worksheet Functions 1 May 25th 05 06:38 PM
How do you toggle back and forth between worksheets in Excel? Rocki Excel Worksheet Functions 1 May 10th 05 05:22 PM
Linking Excel Worksheets Anne Excel Worksheet Functions 2 December 10th 04 02:45 PM
Combine Mutiple Worksheets into one Dean F Excel Discussion (Misc queries) 11 November 27th 04 05:18 PM


All times are GMT +1. The time now is 10:37 AM.

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"