98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Consolidating data
Consolidating data
Resolved · Low Priority · Version Standard
Linda has attended:
Excel Introduction course
Consolidating data
Thanks Rajeev for your reply. I think my question was too general. What I have is one spreadsheet with three pages. Page one contains peoples' names, contact details etc, collected before 5 Sept 2007; page two the same but collected between 5 Sept and 31 Dec; page three 1 Jan onwards.
I need to keep these pages separate but also have one list in which all the 150 + entries are integrated.
The three pages already have the same layout. The entries are for academics listed under subject area, which is the heading of column A. Some of them have more than one subject area and so make multiple appearances on the list - this should be preserved in the integrated list.
Can you help?
Thanks
Linda
PS I hope you got your phone back.
RE: Consolidating data
Hi Linda,
I hope you don't mind me answering on Rajeev's behalf.
Presuming the data does not change on sheets 1 or 2, and perhaps only changes on sheet 3, I think the answer to this may be relatively simple. On the worksheet where you want to hold the entire list of 150+, set the headings to mirror those of the other worksheets. Then in the first blank cell, type and equal sign, then use your mouse to choose the first cell with data in the first worksheet, and hit the enter key. You can then use your mouse to copy the data down and across (hover your mouse over the bottom right of the cell that you want to copy, until your pointer becomes a plus sign, then click and drag your mouse down, and then across). Once you have copied the data from sheet 1, you can start at the first blank cell, and copy the data from sheet 2 in the same manner.
Will this help with what you are trying to do? If it doesn't, please feel free to reply to this message with any further details you may have, and I will be glad to assist more. If it does resolve your question, could you please mark your question as "resolved"?
Have a great day.
Kind regards,
Mara
Microsoft Office Specialist Master Trainer
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Checking if a calculation adheres to Order of PrecedenceWhen writing formulas you must make sure that results will be calculated as you intended. |