automatically updating sheet

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Automatically updating sheet 2, when sheet 1 is completed

Automatically updating sheet 2, when sheet 1 is completed

resolvedResolved · High Priority · Version 2007

Shahirul has attended:
Excel Intermediate course
Excel Advanced course

Automatically updating sheet 2, when sheet 1 is completed

I have a spreadsheet which collects data of lettings made by 33 partners on 33 sheets. I would like to have a master sheet which collects all the lettings made as and when each of the other 33 sheets are updated.
For example, if partner 1 had three lettings made today, I would complete the sheet for partner 1, but would want the master sheet to be automatically updated with these three lettings. If partner, 5 and 6 had some lettings, I would complete their respective sheets but would want the master sheet to automatically be updated with all these lettings.

RE: Automatically updating sheet 2, when sheet 1 is completed

Hi Shahirul,

Thank you for your question and welcome to the forum.

Are all the sheets identical? If so, you can use 3d formulas where you use sum and sum the identical range between the first sheet and the last sheet.

Alternatively you could use Data Consolidation.

I hope this answers your questions.

Regards

Simon

Tue 25 Dec 2012: Automatically marked as resolved.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips


Server loaded in 0.16 secs.