Solved

Excel automated task Help

Posted on 2013-10-31
3
165 Views
Last Modified: 2013-10-31
I have a sheet in Excel 2013, and use it for a daily schedule. To generate the sheet, I put a number (from 1 to 31) in cell C1, and all the cells in the sheet update automatically. I then print out the page and go to the next number (so first I enter 1, print, then 2, print, then 3, print, etc.)

I would like to automate this task, so that I can just click GO and excel will fill in the numbers 1 to 31 in the sheet, and print out the sheet (on the default printer) for each number.

Can someone help me create this automated task?
0
Comment
Question by:Lev Seltzer
3 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 39613611
Hi,

Could you send an example?

Regards
0
 
LVL 12

Accepted Solution

by:
Harry Lee earned 500 total points
ID: 39615100
WEBuilder,

Try this code.

Sub PrintDailyReport()
Dim I As Integer

For I = 1 To 31
    Range("C1").Value = I
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
        IgnorePrintAreas:=False
Next

End Sub

Open in new window

0
 

Author Closing Comment

by:Lev Seltzer
ID: 39615303
Perfect. Thank you very much for your quick response!
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question