I would like to get input on how to create a document to lay out the tabs and have a list type data entry table/form that will auto populate the tabs in the correct position and quantity.

I am sometimes in need of 100 tabs and sometimes in need of 5.

I am understanding that a macro would be the way to develop this, possibly through vba.

the macro could have input in a list, then loop through all the divider text entries and create a separate page for each entry and put the "next" item in the next cell on each page cycling through the tab positions.



If anyone has any idea how to make this work rather efficiently please let me know!

Your post is confusing. First you refer to tabs, then to a data entry form to populate them, then to divider text entries then, finally, for the output to generate separate pages. A little more perspicacity wouldn't go astray.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Input titles in either form/list then have a macro place those titles on the tabs of the card dividers with a quantity of pages that is equal to the total sum of titles input. Thus, having multiple pages of dividers.

The dividers are directly printable and in a 5tab setup

I have a layout template for manual entry though this only allows for 5 at a
Time. If you have any questions please let me know. I Apologize for my erratic posting as it was don in haste. Multiple thoughts not congruent.

Your explanation doesn't make it any clearer. I have no idea what you mean by "multiple pages of dividers" or "a 5tab setup". This is not normal Word terminology.

I suspect you're trying to do something for which Word uses label stationery (see Mailings>Labels) and you want to use these with some kind of list, for which a label mailmerge might be the appropriate solution, but that's far from certain.

Perhaps you could attach a document to a post with some representative data, including your dividers & tabs, plus the data that's to go into them and an indication of the desired layout? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Laura L.


PULLED FROM http://www.linkedin.com/groups/Using...84.S.225713381



Principal Consultant/Programmer
Ultimately, your stick on labels will probably be much easier, but you can make a template for the dividers you print on directly.

For printing directly onto the card dividers I have set up a template in Word where I made the document landscape then added a 1 row table across the top with the number of columns that I had for the dividers (5 in my case). I made sure the cells were aligned so that text in them printed on each divider tab.

If you only need to do a few at a time, you just type the divider text in the table cell that matches up with the position of the divider you're putting in the printer.

If you need a lot of them though, I think you'll need a macro. When I did this it was for a client so I used VBA to develop a macro to let the typist type in the list of label names. The macro then looped through all the divider text entries and created a separate page for each entry and put the "next" item in the next cell on each page, cycling through the positions. My client could then put a stack of dividers in the printer and as long as the top divider started in the same spot as the text in the table cell they were good to go.

Attached Files

Tab 1.docx (32.8 KB, 13 views)

Personally, I'd do this as a mailmerge, which doesn't require the use of any macros.

Attached is a revised version of your document and a dummy Excel data source for the merge. To use them, simply save both files to the same folder, then open the document and choose Mailings>Select Recipients>Use existing list, then navigate to and select the workbook. Once you've done that, click on Finish & Merge>Edit Individual Documents>OK. Word will then generate 24 pages of dividers, with 'Label 1' through 'Label 24', each offset on their respective pages.

This attachments are just a demo. You can change the label content and the number of labels by editing the workbook (close the Dividers document first) - but don't change the 'LabelData' heading. When updating the workbook, be careful to delete all empty rows below the final label. You can also edit the font size, alignment & and positions of the divider labels (bearing in mind that you need to leave a 1/4in paper-handling margin for most printers).

As you will see, the Dividers document consists of a 2*5 table. To see how the mailmerge determines which label to output in a given position, open the Dividers document and press Alt-F9 to reveal the field codes in the right-hand table column.

Attached Files

	Dividers.docx (16.6 KB, 22 views)
	LabelData.xlsx (8.2 KB, 47 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]