How do I combine two worksheets in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top