Inserting series every 4th cell?

G

Grativo

I'm trying to label cells, B001...B002...B003, etc on a column, but I need to
do this every 4th cell. What's the best way to do this? Thanks in advance for
any help.

Grativo
 
P

Peo Sjoblom

Easiest way is probably to put B001 in a cell, leave 2 cells and in the 4th
put B002,
now if you started in A1 with B001 and B002 is in A4, select A1:A6, grab a
hold in the corner of A6 and copy down as long as you need
 

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

Need a Macro 2
Blank Page After Envelope-Label Wizard 5
Word VBA - Automatic change content of a cell in table using dropdown list 5
Copy addition formula of non-consecutive horizontal cells 2
Word VBA - Want to test if Full Name is NOT Present in document 0
Insert Multiple Fields without Dialog closing between each... 0
Average range of discontinuous cells 1
Selecting every 4th row 3

Top