Hi,
I am hoping someone can help me build this macro. I am trying to filldown rows with information on the previous row till a change happens and then fill down rows with the new value till a change and fill down .. and so on.. till the last row
To make it simpler, here's how my spreadsheet looks -
NUMBER DATE
1 3/4/2010
3/5/2010
3/5/2010
3/5/2010
2 3/4/2010
3/5/2010
3/5/2010
3/5/2010
3/5/2010
4 2/25/2010
3/5/2010
3/5/2010
So, I want to fill (in Column 1), rows 2-4 with value 1; row 6-9 with value 2, row 11-12 with value 4. so on.
Thanks!
Bookmarks