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

How to delete ALL cells containing the same data --- REVISED 0
Remove specific cells in a column. 2
add multiple letters to the end of multiple cells 1
How to count non blank cells with a condition? 1
Find the first & subsequent cells to contain text in a column & re 27
how to use an formula to transpose a list(left) to be like the right? 2
How to delete ALL cells containing the same data 1
Using conditional formating to copy range of cells 1

Top