Search results

If I can find a way to get the last row number scrolled that should work. Thank you very mucj.

I thought that since the top row number is shown when the scroll bar is moved that there might be a fucntion that tracks the row number. Thank you for working on this

Narayank991, Finally got your sheet to work. I didn't realize i had to change the active cell. This does work but unforunantly my users probably won't be clicking on the cells, they will just scroll down to see the data. Is there a way of just monitoring the row number and changing A2 when a...

Narayank991, It shows the year when the sheet is openned but doesn't change it. I tried deleteing the 2011 from A2 then scrolling but it dosen't show up again. I was hoping there was a cell formula I could use but it looks like I'll have to go VBA. Thanks for all your work on it.

If you put the year 2010 in A8 I need the year in A2 to change to 2010 when A8 reaches the freeze line and goes off the screen

My apologies. The second line of my post should be: Then when year 2010, which would be in A8 reaches the freeze line to change A2 to 2010. not: Then when year 2010, which would be in A8 reaches the freeze line to change A2 to 2011. Late night, didn't proof-read well.

No. what I want is when the user scrolls down and the year 2011 in A3 scrolls off the screen to display the year (2011) in A2. Then when year 2010, which would be in A8 reaches the freeze line to change A2 to 2011. This way the user always knows which year is being displayed at the top. I...

I have a spreadsheet where I have Jan-Dec in Columns B-M listing quantities per month. Column A list the items. The Items are spaced by year. example: 2011 Jan Feb Mar ... item 1 124 233 169 item 2 344 310 336 item 3 223 111 111 2010 item 1 123 563 540...

Is there a formula that will dynamically give the current row number directly below the freeze line as the data is scrolled?