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