How to copy info into blank cells within a column (going up the co

M

Marty

Hello.
I know how to copy info into blank cells within a column going down the
column. The blank cell fills in with the info till the info changes . . .
But, how can I go up the column instead of down?
Example, blank cells are A2 and A4 and the information I want copied is in
A6. Blank cells are A8, A10, A12, A14 and information I want copied is in
A16 . . .
 
S

Sheeloo

Try this
1. Select the range A1:A16
2. Press F5, Click on Special, choose Blanks and click OK
3. CTRL-Click on A14
4. Type =A16
5. Press CTRL-ENTER
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find the first & subsequent cells to contain text in a column & re 28
Using conditional formating to copy range of cells 1
how to copy the contents from last cell 2
How to fill in range of blank rows wth data fr last row previos ra 1
how to use an formula to transpose a list(left) to be like the right? 2
How to sort AlphaNumeric Data sequentially with spaces 4
Remove specific cells in a column. 2
repeating cells 2

Top