Reverse offset (or indexing)

I am attempting to make a print out of stickers from a whole work book of information in a standard layout of columns and rows.

However the stickers are 2 x 4 on an 8.5" x 11" sheet, and the stickers are going to be in a very different layout from the "master" sheet.

Since I will need about 300-600 stickers I would like to just auto-fill the stickers with with the pull down option. So in conclusion, I have an input form my master sheet at 1 row per item, where as my stickers are about 7 rows per item. I don't know of an option with offset that lets me have an output at a different row level then my input.

Let me know what you guys have done with this sort of problem,

thank in advance,

-M

Welcome to the Forum Pronautic !

It is very difficult to picture this based on your text description. Do you mean that the "master" sheet has some text in, say, A2, and you want that to be replicated in stickers on another sheet in, say, A7:G7? You would put a formula like

=master!$A2

in A7, and drag to the right to G7. But the formula may be different depending on how the two sheets map.

How will this work out to hundreds of stickers?

It is hard to give a more concrete answer without understand your mapping of what cells on the master sheet map to what cells on the sticker sheet. Can you give more specific details, with cell addresses?

If the file is not private then you can attach it here for a more comprehensive answer. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

This proposal employs two helper columns (G and J) which may be moved and/or hidden for aesthetic purposes.
Column G is populated using: =COUNTIFS(A$2:A2,"Drawing*")
Column J is populated using: =SUM(MAX(G$2:G$27),COUNTIFS(D$2:D2,"Drawing*"))
Cell B3 is populated using: =IF(A3="","",INDEX(Sheet1!$A$2:$D$11,MATCH(G3,Sheet1!$A$2:$A$11,0),MATCH(A3,Sheet1!$A$1:$D$1,0)))
Once entered drag the fill handle down to B6 (Change the formatting in B5 to general).
Select B3:B6 and copy (Ctrl + c)
Select B10 and paste (Ctrl + v)
Continue down column B and then over to column E (i.e. E3, E10 …)
Note that some of the column headers on Sheet1 are changed to match row headers on Sheet2.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

Try these modifications to the formula:
In column B it should read:

Formula:

Please Login or Register  to view this content.

In column E it should read:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Attached
Let us know if you have any questions.

You're Welcome, glad that things worked out. I hope that you have a blessed day.