Example:
Main Data Sheet
Column: 17
A B C d

Region Reps Jul Aug etc(all months
accross)
18 Allied
Cumulative 07 25,000 42,000
Forecast 08 28,000 50,000

Summary: Columns 4
A b c d
Region Reps YTD Plan YTD 07
18 Allied 28,000 (jul) 25,000 (jul)

I hope you can understand what I am trying to do now. As I enter the
information in the main data sheet for aug I want the summary sheet column c
and d to change automatically with the aug amounts I am putting in.

Thanks
"Otto Moehrbach" wrote:

Liz
You have to understand that no one knows your business but you and the
people you work with. To get help with Excel, you have to use generic
terminology. For instance, you say:
"...I have the dollar amounts broken down monthly in different
categories...". This means something to you because you built the workbook
and you have it in front of you. Without that, it means very little.
Say things like:
I have 5 columns with headers in row one of this, this, this, this, and
this.
I don't know how you would explain "broken down .... in different
categories", but try.
You say:
"but the amounts I need for the summary are cumulative sales 07 and
Cumualtive Forecast sales 08." Where are these values? How can they be
found?
You say "putting = ". I take this to mean that you are typing an equal sign
in some cell. What cell? What is the significance of that cell? In what
column is that cell?
You say: "putting = then going into the main sheet and hitting the current
month." I understand the mechanics of building a formula, but I don't
understand what constitutes the "current month". You said that your data is
broken down "monthly" but you are clicking on one cell. Is this a summation
cell? Where is it?
I sincerely want to help you but I have to understand what you have, what
you want, and how you want to get there.
If you are reluctant to divulge your data, simply fake the data. I need
just the layout of your data. HTH Otto


"Liz" wrote in message
...
In the main sheet I have the dollar amounts broken down monthly in
different
categories but the amounts I need for the summary are cumulative sales 07
and
Cumualtive Forecast sales 08.

In the summary sheet i have the headings as YTD Plan and YTD 07. right
now
I am getting the figures over by putting = then going into the main sheet
and
hitting the current month. I want for this to change automatically as I
enter the data (if possible) I hope you understand what I am trying to
do.
Thanks

"Otto Moehrbach" wrote:

Liz
Your explanation is a bit hazy. You have a Main sheet into which you
enter data. That sheet has months across the heading row and dollar
amounts
down the columns. That's clear. I take it that you want to enter a
dollar
amount in some column and you want this value to be reflected in the
summary
sheets. What summary sheets? Are they named the months? Do you want
the
dollar amount to go to the same sheet who's name is in the header of the
column into which you entered the dollar amount (if the sheets are named
months)? Into what column and what row? If the summary sheets are not
related to the header of the column into which you entered the dollar
amount, how do you find the right summary sheet? HTH Otto
"Liz" wrote in message
...
Hi,

I am working on a large workbook with many worksheets. The main
worksheet
that i have is where i enter all my info on. The heading for the
columns
are
the months of the year. on the rows are the dollar amounts. The dollar
amounts I have them flowing into my summary sheets. Right now I am
having
to
change the summary formula every month because I need the new month to
reflect. I need to know if there is a formula ormacro that I can put
in
that will change to current month I am working on automatically.

Any help you can give me I would appreciate.

Thanks