need help with a function
 

I'm making a spreadsheet with names and addresses on "Sheet1".
This is in a particular format, and cannot be changed. From this sheet
I want to put the names and address in a "label printing" format. To do
this I need to grab the names and address off of the first sheet.
On sheet1 the names appear starting on column B row 3, 15, 27 then
continues in a +12 pattern. To pull these names to "Sheet2" I tried
just writing =Sheet1!BX where X is the row #. This would be
monotonous and time consuming since I have nearly 1000 names.

Is there a function I can write that would pull every 12th cell and
place it appropriatly on sheet2?


--
takingbackjordo
------------------------------------------------------------------------
takingbackjordo's Profile: http://www.excelforum.com/member.php...o&userid=34858
View this thread: http://www.excelforum.com/showthread...hreadid=546077

need help with a function
 

In cell B1 on Sheet2 enter:

=INDIRECT("Sheet1!B" & 12*(ROW()-1)+3)
and copy down

The will pick every 12th row from Sheet1 starting with row 3
--
Gary's Student


"takingbackjordo" wrote:


I'm making a spreadsheet with names and addresses on "Sheet1".
This is in a particular format, and cannot be changed. From this sheet
I want to put the names and address in a "label printing" format. To do
this I need to grab the names and address off of the first sheet.
On sheet1 the names appear starting on column B row 3, 15, 27 then
continues in a +12 pattern. To pull these names to "Sheet2" I tried
just writing =Sheet1!BX where X is the row #. This would be
monotonous and time consuming since I have nearly 1000 names.

Is there a function I can write that would pull every 12th cell and
place it appropriatly on sheet2?


--
takingbackjordo
------------------------------------------------------------------------
takingbackjordo's Profile: http://www.excelforum.com/member.php...o&userid=34858
View this thread: http://www.excelforum.com/showthread...hreadid=546077

need help with a function
 

you saved me a ton of time....thanks a million

-jorda

--
takingbackjord
-----------------------------------------------------------------------
takingbackjordo's Profile: http://www.excelforum.com/member.php...fo&userid=3485
View this thread: http://www.excelforum.com/showthread.php?threadid=54607