Is this possible? Excel 2000

[DrDan1]

Is it possible to do the following:

I have a workbook with several sheets, one for each month of the year. I would like an additional sheet that has all the information that's on the monthly sheets. When I add a line to, say October, I would like the same line to automatically copied or updated in the Master Sheet.

Is it possible and if it is, can it be done thru excel options or does it require a lot of code?

Thanks very muchly
--Dan

----------------------------------------
Knowing is not enough, we must apply. Willing is not enough, we must do.
--So said the ever wise Bruce Lee
Memorize and live by it!

 

[MakeItSo]

It's relatively easy:
Write a [blue]
Sub Workbook_Change()
Dim mySheet As String
Dim myVal

mySheet = ActiveSheet.Name
myVal = ActiveCell.Value
Sheets("your master sheet name&quot.Activate
'Select your desired Range
Range(whatever) = myVal
Sheets(mySheet).Activate
End Sub[/blue]

This should already suffice. The code is fired whenever you make changes.

Regards,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[xlbo]

Before Skip steps in here, I'll go first. This is bad design. You should have a master sheet where the data is collected with functionality to create monthly reports from there - not vice versa. It is much easier to split a master into sections than to update the sections to the master.

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[BlueHorizon]

Hi,
I've used the SUMIF function on a worksheet where I have individual worksheets that represent months of the year and each worksheet had different categories on it. I wanted a Master Sheet that totalled up each month and each category. It looks something like this:

=SUMIF(June!$D$5:$D$26,A19,June!$C$5:$C$26)

Lookup SUMIF in the Help menu for a better explanation.
Maybe this will help you too.
Good Luck,
BlueHorizon