Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Want Excel to break links between worksheets in same file | Excel Worksheet Functions | |||
How do you toggle back and forth between worksheets in Excel? | Excel Worksheet Functions | |||
Linking Excel Worksheets | Excel Worksheet Functions | |||
Combine Mutiple Worksheets into one | Excel Discussion (Misc queries) |