Free Microsoft Excel 2013 Quick Reference

Booklet Results


I've used Excel many times before, but am no where near proficient. Can you please provide a solution to this application?

I have a sheet which contains first name, last name and table number. I'd like to create 2 lists in booklet form with two columns on each page, sorted by last name and then other list sorted by table number (like a table of contents).

I tried to visualize doing this with word using a "mail-merge" solution with the excel sheet as the datasource but I doesn't appear that is the best approach.

I'm using excel 2007. What would be the best way to render the "booklet list" from my excel [COLOR=blue ! important][COLOR=blue ! important]data[/COLOR][/COLOR]?

Any suggestions would be appreciated.

Note: I am not looking for you to do this for me, a solution suggestion, or topics covering the solution would be appreciated. For example if there was such a thing as a 'booklet list' function or macro - simply stating that this solution would work and suggesting that I read the documentation on it would be very helpful to me.


I have Windows Excel and would like to convert the current list of names and addresses into a booklet format. Data on page 1 and 20, page 2 and 21, page 3 and 22 etc.

What is the technique for converting this database over?
V. Ouellette

Is there a way to have a Word document print in a booklet form?
Example; have it print landscaped two columns to a page which can then be folded in half to form a booklet.
And if so, do I have to manipulate display so that I can get page numbers at the bottom of each page and when folding after print it is in the right order (using duplex printing)?
Finally, can I save the document so that print selection is maintained when sharing the document?
Thanks for any help.

i need to do a booklet of song titles for karaoke booklets but thgey need to
be done in alphabetical order, any ideas what i need ?

I have a booklet with about 20 sheets. I would like to unprotect and protect
the sheets together, not one at a time. Protecting the workbook doesn't
protect the cells.

Is there such a function?


Rather strange request. I need to print a booklet of 8 sheets with the final page different for each one and these contained on separate pages of an excel worksheet. Does anyone know how I can get it to print how I require?

Many thanks


I have a 4 sheet Excel document that I need to print as a booklet (11" x 17"
paper, with two 8 1/2" x 11" pages side-by-side on the front and two 8 1/2" x
11" pages side-by-side on the back. I'm using Microsoft Office Excel 2003.

How can I print an excel spreadsheet as a booklet?

Hi all, Forgive my ignorance, I'm fairly new to this. I have a workbook with three seperate worksheets. I need to print them all in a booklet, front and back. It will do this, but I get three seperate booklets. I need one big booklet with the worksheets like chapters. Where I can flip through the booklet and see all three worksheets in order. Can this be done??? Thank you in advance.

I am new to this forum but hope to participate frequently.

I searched for help on this topic but found none.

I want to create a 5 1/2 by 8 1/2 booklet and am having difficulty in find out how to do that. Can any one help --- or refer me to source.

TIA. Greatly appreciated.

Hi, I have a workbook that my department uses to track our projects with 20+ tabs. This workbook has a main page called "Dashboard", and then subsequent pages are only titled with numbers. I.e. "1", "2", "3", etc.

What I would like, is that every tab except "Dashboard" is hidden, and can only be accessed by clicking the hyperlink on the "dashboard". Once the user gets to a subsequent tab the "dashboard" tab would be hidden and then they can click on the "home" button to take them back to the dashboard and then that tab will be re-hidden.

I have used the code posted in this forum (and it worked in my blank test booklet), but for some reason it will not work in my actual project workbook. It gives me a runtime error "9" and I can not for the life of me figure out why it wont work.

I've attached the actual workbook I am using so you can see the problem first hand.

I extremely green when it comes to VBA so I am hoping someone can help me solve this.

Thank you so much,




I am trying to paste a 10X10 matrix (A1:J10) from one booklet (sheet1) into another (sheet2) repetedly at a rate of once every 0.5 seconds. The location of the paste into sheet2 varies so that each new paste appends the last. For example, at the 0.5 second mark sheet2 will consist of the matrix from sheet1, at the 1 second mark sheet2 will consist of both the 0.5 second past and another paste of the sheet1 matrix below (total A1:J20), and so on. Any help that you offer will be greatly appreciated!


I am brand new to VBA and really only need to know how to create one macro: I have a spreadsheet with 8 columns with various text headings. Each column has different data (some show dates, some show only figures, some show text). Specifically, column E (entitled "Sub Item Reference") has various text entries (e.g. "Newsletter" or "Booklet"). I am hoping to find a simple macro that will search column E and delete any rows where that column contains the text "Cover" or "Label". I'm sure it's the simplest thing going but I can't seem to work it out. Many thanks.

I'm working on a spreadsheet which uses three dropdown menus all linked via data validation and the Indirect function.

Everything works lovely until my middle menu chokes on the "A4" selection.

Any ideas?

[Item] [Description] [Format]
Advert A4 ?

[Item] [Description] [Format]
CD Booklet Mono



is there a formula that can count all rows of coding with text in them?

I have a booklet of information and lots of tabs, and I was hoping there was a formula to go thru and count all the rows in all the tabs and add them all up.

Any help would be much appreciated.

Hi I am using the following code to transfer data from multiple workbooks inside a folder. i would like to transfer the data in cells B8, C8, D8 E8 G8 H8 and I8 into a master table in another booklet.

I am Using this coded but it will only transfer the first 5 numbers B8 C8 D8 E8 and G8 and not the last two. can you help me alter the code so that i can transfer the other numbers

Sub pull_data()
Dim a, c,e As Integer
Dim f, b,d As String
Cells(2, 1).Select
f = Dir("C:Documents and SettingshughesdDesktopNew Folder" & "*.xls")
Do While Len(f) > 0
ActiveCell.Formula = f
ActiveCell.Offset(1, 0).Select
f = Dir()
x = Cells(Rows.Count, 1).End(xlUp).Row
For a = 2 To x
b = "Sheet1"
For c = 2 To 6
d = Choose(c - 1, "B", "C", "D", "E", "G", "H", "I")
e = Choose(c - 1, 8, 8, 8, 8, 8, 8, 8)
Cells(1, 1) = "='C:Documents and SettingshughesdDesktopNew Folder[" & Cells(a, 1) & "]" & b & "'!" & d & e
Cells(a, c) = Cells(1, 1)
Next c
Next a
End Sub


Thank you again for helping me with the formula below. I hoping you can help
me with one more twist. I only need the formula to count to 500. There are
only 500 tickets in the booklet. If the count goes higher than 500 I do not
want it to count an out of sequence or just leave the cell blank. Does this
make sence?

Thank you for the assistance!

Assuming you are happy with Gary's solution, try this modified version which
gives range of missing tickets i.e. 15-16 in your example in row 3:

=IF(A2=B1+1,"", B1+1 & "-" & A2-1)

"mmock" wrote:

> You are correct......thank you again, I would have another ticket missing!!
> "Toppers" wrote:
> > Shouldn't that be 11 tickets sold (numbers to 1 to 11 inclusive)?
> >
> > "mmock" wrote:
> >
> > > Maybe to clarify more. On same days I will use or sell more than one ticket.
> > > Line B1 - A1 = C1 (or 10 tickets sold). Is the +1 used only for when it is
> > > 1 above the previous number?
> > > Thanks,
> > > Mark
> > >
> > >
> > > "mmock" wrote:
> > >
> > > > Prior to sending this post, I have read many posts and have not quite found
> > > > the answer I am looking for. I hope someone can help me with a formula.
> > > >
> > > > I need to track tickets used. More importantly, I need to know if a ticket
> > > > in a sequence is missing. I will be tracking start & stop numbers and
> > > > tickets used. I'm looking for an indicator of some sort to tell me when a
> > > > ticket is missing or out of sequence.
> > > > Example
> > > >
> > > > A1=1 B1=11 C1=10
> > > > A2=12 B2=14 C2=2
> > > > A3=17 B3=20 C3=3 (FLAG the 2 missing tickets 15 & 16)
> > > >
> > > > Any assistance would be apprciated.
> > > > thanks,
> > > > Mark
> > > >

I have four worksheets that I'd like to print as a one-fold landscape
booklet. This means I need to print two worksheets on one side of a page,
but I can't figure out a way to do this within Excel (PC v2002, btw). Is
this possible, preferably without VB?

Hi all,

I have created an staffing list with organisation charts in Excel, it runs
to about 40 pages. I need to do a presentation of this info.

Doing the presentation in Excel looks a bit unprofessional, too many
toolbars, space wastage, grid lines etc.
Is there any package (apart from Adobe Acrobat too expensive) or way, that I
can display the spreadsheet in more of a booklet presentation. With a table
of contents, index, better page numbering than Excel, jump to page number,
looks clearer etc. With the possibility of a real-time link between the
spreadsheet and the output source.
I've tried some of the PDF driver software but its mostly limited in that u
can't create bookmarks, proper page number, and embedding. (thou if anyone
knows of a really good one for say £35 ($60) that would be cool, or any
software that does the job at that cost-but free would be better)

Any help is greatly appreciated.


I woul;d like to convert a list of names and addresses into a booklet format.
How do I do this please?

No luck finding an answer? You could always try Google.