Thread: Automatically enter a percent for each month of the year.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jman Jman is offline
external usenet poster
  
Posts: 110
Default Automatically enter a percent for each month of the year.
In A1 thru L1 i have months: A1=Jan, B1=Feb, C1=Mar etc
In A2 thru L2 will be total for each month.


In A19 i have a percentage ex "34%" that varies up and down every day..
In A20 i have "today()" date ex 3-23-08

At the end of the Month i want the percentage in A19 "34%" to automatically
log in to the corresponding month ex. today date 3-23-08 to C2 March

Is there a formula for this?

Reply With QuoteReply With Quote