View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deskpilot Deskpilot is offline
external usenet poster
 
Posts: 6
Default Updating a reference ROW

My spreadheet has the entire MLB N/L schedule
COLUMNS are TEAM
ROWS are DATE
Each mmorning, W/L are updated.
Summary section contain cell the look for MAX and MIN
'E188" =MIN(E18:E103) E103 represents were the last new data is entered.
I would like to automate the reference to the last row filled in.
The referenced columns for games NOT YET PLAYED result in #N/A. This is
needed for graphing purposes. I curretly have to use the <Ctrl +H function
to update the ending cell across the MIN and MAX rows.
Thanks in advance for your support