View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Smiffie72 Smiffie72 is offline
external usenet poster
 
Posts: 3
Default Data change as scrolling

Hi,
Just been told how to use Freeze pane option so my days of the week scroll
down the worksheet. My A column has the months in it. I.E I have January in
A1 and April in A10. B1, B2 etc has the days of the week. How do I get the A1
cell to change to a different month as the row scroll down to it? Thanks