copying cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to copy data down. I need to fill each of the empty cells with
the data that appears above it before the occurance of the next data item.

For example:

9B0B4C504A70A90B14DFDAB0ADBE477D
-
464EED0D421A8763AE9E539B278257FC
-
-
5B0AB65A11D4BA460000459400000000
-
-
B2D45E0211D550F10100D58698469B02
-

Becomes:
9B0B4C504A70A90B14DFDAB0ADBE477D
9B0B4C504A70A90B14DFDAB0ADBE477D
464EED0D421A8763AE9E539B278257FC
464EED0D421A8763AE9E539B278257FC
464EED0D421A8763AE9E539B278257FC
5B0AB65A11D4BA460000459400000000
5B0AB65A11D4BA460000459400000000
5B0AB65A11D4BA460000459400000000
B2D45E0211D550F10100D58698469B02
B2D45E0211D550F10100D58698469B02
 
Test this first on a small sample so you are sure you get it right

select the range, press F5, select special and blanks.
Now type in

=A1

(where A1 is the first cell counting from the top, replace it with your
first cell,
i.e. the cell that in your examle holds 9B0B4C504A70A90B14DFDAB0ADBE477D)

press Ctrl + enter

Finally select the new range and copy it, then paste special as values in
place to remove the formula

Done!

Regards,

Peo Sjoblom
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VB code 5
Getting Text data using the Data - Subtotal feature 1
Excel Move or Copy Stopped Working? 0
Reference Formula Help 1
Need macro to move to first blank cell in column 6

Back
Top