filling datat to another sheet

S

static69

i have a list of peoples names, hundreds long, that need to get inpute
to another sheet in the same workbook, but each name has a differen
spot to go to. They are seperated by about 15 lines each, with dat
between? How to do this without cut and paste
 
B

Bernie Deitrick

Static,

How you do this depends on whether you're trying to add the list to an
already filled column that has a blank spot every 15 rows, or to a
completely blank column.

For the completely blank column:

Suppose your list starts in A1 of Sheet2. In A1 of Sheet1, use the formula

=INDIRECT("Sheet2!A" & INT((ROW()-1)/15)+1)

Select cells A1:A15, copy, then select A16 toAXXX, where XXX is 15 times the
count of the names in your long list, and paste.

If you are adding this to a filled column with blanks every 15 rows, select
the used portion of the entire column, use Edit | Goto.. Special, Blanks;
then type in the above formula, and press Ctrl-Enter.

HTH,
Bernie
MS Excel MVP
 
Top