Free Microsoft Excel 2013 Quick Reference

Create command button to print multiple worksheets in a excel file

I have never worked with a macro in excel.
I have a file with 5 worksheets.
I want to create a command button in Worksheet 1 so I can print worksheets 2
through 4 all together.
Please help.

Marco


Post your answer or comment

comments powered by Disqus
I have set up a macro to print several worksheets in a Excel workbook.
How do I omit a sheet fom printing if it reflects a zero value in a certain
cell

Hi there,

I need to save multiple worksheets in an excel file to individual CSV files. Right now, I am doing this manually once a week, but since there are over 30 worksheets, this is obviously quite cumbersome.
Attached is an example of the logic.

I have 2 "master sheets" in the workbook that do the heavy lifting of the analysis, populating the 30 worksheets with updated data, once I ran my update links etc. What I would need is some sort of VBA code that can easily save each worksheet as a CSV file in the same folder that the master file resides in, using the worksheet name as the file name, requiring no human interaction.

Do you think that is possible?

All worksheets that need to be exported start with the word "CSV", so that could be an automatic criteria for the macro to understand which sheets need to get exported.... I couldn't find a similar solution in the forum unfortunately, which struck me as weird, as I don't believe to have such a unique requirement. If there's anything out there already that does what I need, please post the link, it's very much appreciated!

Best regards,
Titus

I want to create a worksheet that have a different number of columns in
different sections. If I create a new worksheet for each section, can I
print multiple worksheets on the same page within the same workbook?

Can I use different column formats within the same worksheet? For example
the top part of my form is only 4 columns the sections to follow are 5 to 7
columns wide.

Hello!

I want to create a button to print out specific worksheets in my workbook. I have a workbook with about a dozen worksheets in it. I want to be able to have three print options (a button with three options, or three buttons) to print certain worksheets for 'internal', 'customer', or 'supplier'.

I only know the basics of excel, so I'm not even sure where to start really. I think I should be able to create a macro for a print button...

Thanks for your help!
Rochelle

Dear Sir,

I have a workbook which contains 62 worksheets. Can a macro be created so
that if I want to print multiple (different) worksheets, it can be printed by
giving just one macro command.

Thanks n regards
Anil Sharma

needing a vba/macro command button that when pressed will print all workbooks in a folder eg.

main workbook is where you enter data and then it autofills relevant information in 10 other workbooks.

i want command button placed in main workbook that will then print all workbooks contained in the folder.

these will not be open.

Let's say I have a workbook containing multiple worksheets, each a separate
materials requisition. I want to find out when (and details) I last ordered
a particular item. Other than selecting each worksheet one at a time and
then using "find," is there a search that would look through all the
worksheets in that particular workbook?

I'm trying to print multiple worksheets in color. The default setting of our
printer is black and white, so I highlight all the worksheets, go to file
print, select properties, and change the black and white setting to color.
The first worksheet prints out correctly, but the other sheets use the
default settings of the printer.

As a test I tried doing the same thing, but instead of changing color I told
it to duplex. Once again the first worksheet was duplexed and the rest of
the worksheets were not. I've tested this issue on a HP 4100 and a Canon
Image Runner 4080. Any Ideas?

Is there a way to print multiple worksheets at a time but have their
numbering stay true to the tab? Say you have 4 worksheets in a workbook.
The first worksheet is 5 pages, the second 4, the third 8. Right now if I
click ctrl and choose all the worksheets to print it totals all the pages and
in the footer it starts printing 1 of 17 etc. What I would like for it to do
is print 1 of 5, 2 of 5 etc for the first worksheet; 1 of 4, 2 of 4 etc for
the second worksheet.... Is there a way to make Excel do this?

Let's say I have a workbook containing multiple worksheets, each a separate
materials requisition. I want to find out when (and details) I last ordered
a particular item. Other than selecting each worksheet one at a time and
then using "find," is there a search that would look through all the
worksheets in that particular workbook?

Is there a way to format multiple worksheets in a workbook to have the same
custom footer without having to setup each worksheet separately?

I need to have multiple worksheets use a single worksheet to do
calculations.the calculation worksheets needs to get info from the indivdual
worksheets. can you use varables in the formulas. ex ='WEEK 1'!B3 can you use
a varible for 'WEEK 1'!

Is it possible to have multiple worksheets in a template so when I
insert this template into a new workbook all the pages will come
along?

It seems that when I try and do this all my named ranges really get
messed up.

--
reddog9069
------------------------------------------------------------------------
reddog9069's Profile: http://www.excelforum.com/member.php...o&userid=24458
View this thread: http://www.excelforum.com/showthread...hreadid=388354

How do I create an index or TOC for worksheets in an excel workbook?

If you have a single workbook with individual worksheets is it possible to
print multiple worksheets on a single page.

how to populate many worksheets in a workbook.
I have a 15 workbooks with 30 sheets each and i want the same formula in the
same cell in all 450 sheets.
eg =counta(d9:d5000,"*") in cell aa2 in each work sheet.
I don't mind putting it in 15 times but hopefully not 450 times

Thanks

Is there a way to run a search to find multiple dates in a column?

How do I run a search of column C & find the dates that have multiple entries for that date? Can this be done using the AutoFilter or AdvancedFilter or Find feature? How?

Thanks for any feedback.

Excel 2007 SP2 crashes when attempting to select multiple values in a pivot with lot of values

Hello,
I have a problem with both Excel 2003 and Excel 2007.
We work with a pivot table sourced from a Analysis Services cube.
When I put the dimension attribute in the row area and try to select multiple values I get a bug.
In Excel 2007, the bug will happen only if the list has many values (17000 in this case)
If I select 2 or 3 or more values in the list, Excel 2007 SP2 crashes immediately.

With Excel 2003 SP3, the bug is different, it simply ignore the multiple select and always shows everything. Furthermore, there is a private hotfix kb947648-fix that repairs this bug.

Is there any hotfix to repair the Excel2007 version of this bug?
Thanks,
PhilippeThanks/Regards,Philippe Cand

I am balaji i had some querry in excel 2002.

1. how to arrange a worksheet in a excel 2002 workbook?

2. how to know no of worksheet in workbook ?

Is it possible to have multiple worksheets in a template so when I insert this template into a new workbook all the pages will come along?

It seems that when I try and do this all my named ranges really get messed up.

Hi

I am learning VBA code now through a book. Can someone please tell me what code to write when i want to select all worksheets in a workbook?

From marco recording, it was
But what to write when i actually enter the code myself?

Thanks.

Hi,

How to sort multiple columns in a pivot table. I can able to sort one column at a time in Pivot table. If i want to sort two or more columns at a time, how to achieve that. Please help. Thanks in advance.

Hi Guys,

Can someone send me the code to:
combine multiple worksheets into a master file (sheet)
automatically when client sheets are closed

Thanks
Albert

hi there
How do I output to the same position in a Text file everytime? I want to
dump data for a given Date so I'd like to put it in the same row for that
Date everytime, and so overwrite the existing data in that row?

I'm using the following command:

Write #3, logfactor(dateline, 1), logfactor(dateline, 2),
logfactor(dateline, 3)

'where dateline is today's date in Excel date code e.g. 40010

I want to be able to overwrite the existing data for line 40010 in my text
file, and replace it with new data.

Hope that it clear!!!!
thank you
Bernard.


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