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