Tracking due dates of numerous worksheets

jloudermilk

New Member
Joined
Jan 27, 2005
Messages
1
Currently I am responsible for organizing a large amount of documents for my companies strategic planning cmte. A recent task has left me completely stumped. I use Excel on a daily basis but admit to not knowing it 100%. Here is what I am trying to do:

I have 15 different "action plans", the template has been created in excel, and each cmte mbr has completed their related action plan (filled in the blanks). I need to take each of these plans and monitor the due dates, person responsible, and completion dates.

Is it possible to have a "master" worksheet that will automatically update the needed info when I make changes to each individual action plan that will each be on an individual sheet (one action plan per sheet). My intention is to have all of this info in one excel book, to include 16 sheets (15 w/ an action plan, and a Master sheet)

I hope that have communicated this well, and I would appreciate any advice, my effectiveness on the job depends on it.

thanks, Jennifer Loudermilk
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
Not sure exactly what level of knowledge you have. Let's start with the basics.

You can easily have a worksheet reflect changes in another.
1. Put your 15 sheets into 1 workbook.
2. Make a master sheet
3. click a cell in the master sheet and type = (equals sign).
4. Go to another sheet and click in a cell there.
5. Press enter key.

You end up with a formula like :-
=Sheet2!A1
when the cell will show whatever is in cell A1 of a worksheet called "sheet2".
 

Forum statistics

Threads
1,148,053
Messages
5,744,531
Members
423,881
Latest member
Nguyen Vu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top