Hello,
Please see attached excel sheet. I need to auto fill the blank spaces on column A with the previous value. So for example, I need to fill A2-A3 with the value of A1 (i.e. 9) and A6:A17 wwith teh value of A5 (ie 13) and so on until the end of the column.
Is there a formula that can do this?
Thanks!
Last edited by nmss18; 03-04-2011 at 11:29 AM.
- Select A2:A4778
- Press F5...Special...Blanks
- Enter = followed by the up cursor key (=A2 will appear in formula bar)
- Confirm the formula with Ctrl+Enter
- Select A2:A4778 again and copy...paste special...values
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thank you both. Worked like a charm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks