Send me the file and I’ll take a look
From: Jeff
Sent: Tuesday, September 27, 2011 12:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Create report & print based on cell value
I have a list that is used to track when people are issued uniforms.
I'd like to create a macro that can look at the date in the cell that
indicates when they get their next set and prints out a list of all
employees where that date is past the current date.
My sheet has 4 columns - Employee Name/number, Hire Date, Last Issued
Date, Next Issue Date.
Based on the results of this, I then want to print out a pre-defined
order form for each employee on the list.
Any suggestions/help would be appreicated.
Thanks
Reply Reply to author Forward
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "$$Excel-Macros$$ Create
report & print based on cell value" by dguillett1
dguillett1 View profile Translate to Translated (View
Original)
More options Sep 27, 9:41 am
From: "dguillett1" <dguille...@gmail.com>
Date: Tue, 27 Sep 2011 08:41:42 -0500
Local: Tues, Sep 27 2011 9:41 am
Subject: Re: $$Excel-Macros$$ Create report & print based on cell value
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
Attach your file
- Hide quoted text -
- Show quoted text -
-----Original Message-----
From: JMac
Sent: Monday, September 26, 2011 7:32 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Create report & print based on cell value
I have a list that is used to track when people are issued uniforms.
I'd like to create a macro that can look at the date in the cell that
indicates when they get their next set and prints out a list of all
employees where that date is past the current date.
My sheet has 4 columns - Employee Name/number, Hire Date, Last Issued
Date, Next Issue Date.
Based on the results of this, I then want to print out a pre-defined
order form for each employee on the list.
Any suggestions/help would be appreicated.
Thanks
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
