Hi,
I am looking for a macro to copy a cell and autofill it down the column until it gets to a non-blank cell. When it reaches that cell it needs to then copy the new cell down until it reaches another non-blank cell . I want it to stop until it reaches the last cell in column B.
I have attached an example file of what I want. If anybody could give me a hand.
Here is one way:
http://www.ozgrid.com/Excel/excel-fill-blank-cells.htm
It can be done in 2 ways.
1) By using Data Selection>>Goto>>Spectial>>Blanks>>=abovecell>>Ctrl+Enter>>Copy and paste the selection as values.
2) or by macro
Which method you would like?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Something like this (thanks to AlphaFrog)
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks