Abs reference? offset?

S

Scottmk

What would be the best way to list "1" in a column for 27 rows, then
after a few spaces the digit "2" 27 rows, etc.etc. thanks for any
help.
 
M

Max

One way to try ..

Put in any starting cell, say in D3: =INT((ROW(A1)+26)/27)
Copy down 54 rows to D56
(This'll return 27 consecutive 1's and 2's)

Kill the formulas in D3:D56 with an in-place:
Copy > Paste special > Values > OK

Insert the desired number of empty rows at the breakpoint,
i.e. select cell D30 and click Insert > Rows
 
T

Tushar Mehta

Select the cells that should contain the '1'. Type the number 1 and
complete data entry not with the ENTER key but with the CTRL+ENTER
keys.

Skip a few spaces (only you can decide how many is the right number)
and repeat the process but this time type 2 rather than 1.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
B

BenjieLop

It is probably easier and FASTER for you to

1. manually enter "1" in cell A1 and copy down until you reach the 27t
row.
2. skip a few cells down
3. manually enter "2" in the next available and copy down until yo
reach the
27th row again.
4. etc.,etc.,etc.

Writing a code for this will possibly take longer than manually doin
the process... only my humble opinion.
 
Top