View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Liz Liz is offline
external usenet poster
 
Posts: 133
Default Linking worksheets

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