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<https://mail.google.com/group/excel-macros/post?hl=en&inreplyto=01851e4fbc853733&reply_to=group&_done=%2Fgroup%2Fexcel-macros%2Fbrowse_thread%2Fthread%2F2d71eadadd4cb494%3Fhl%3Den%26&;>
Reply to
author<https://mail.google.com/group/excel-macros/post?hl=en&inreplyto=01851e4fbc853733&reply_to=author&_done=%2Fgroup%2Fexcel-macros%2Fbrowse_thread%2Fthread%2F2d71eadadd4cb494%3Fhl%3Den%26&;>
Forward<https://mail.google.com/group/excel-macros/post?hl=en&inreplyto=01851e4fbc853733&forward=1&_done=%2Fgroup%2Fexcel-macros%2Fbrowse_thread%2Fthread%2F2d71eadadd4cb494%3Fhl%3Den%26&;>
You must Sign
in<https://www.google.com/accounts/ServiceLogin?passive=true&hl=en&service=groups2&continue=https%3A%2F%2Fgroups.google.com%2Fgroup%2Fexcel-macros%2Fbrowse_thread%2Fthread%2F2d71eadadd4cb494%3Fhl%3Den&cd=US&ssip=g3>before
you can post messages.
To post a message you must first join this
group<https://mail.google.com/group/excel-macros/subscribe?hl=en>
.
Please update your nickname on the subscription
settings<https://mail.google.com/group/excel-macros/subscribe?reason=post_renew&hl=en&_done=%2Fgroup%2Fexcel-macros%2Fbrowse_thread%2Fthread%2F2d71eadadd4cb494%3Fhl%3Den%26&;>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
<https://mail.google.com/groups/profile?hl=en&enc_user=UjkkyBQAAACpOsfX19mV7tCtxyUNLJ34OPANdqfI6prRsqjc7uCt1A>
Translate to
<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#>Translated
(View Original)
<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#>
More options Sep 27, 9:41 am
From: *"dguillett1"
<dguille...<https://mail.google.com/groups/unlock?hl=en&_done=/group/excel-macros/browse_thread/thread/2d71eadadd4cb494%3Fhl%3Den&msg=0b11907becbc087e>
@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<https://mail.google.com/group/excel-macros/post?hl=en&inreplyto=0b11907becbc087e&reply_to=group&_done=%2Fgroup%2Fexcel-macros%2Fbrowse_thread%2Fthread%2F2d71eadadd4cb494%3Fhl%3Den%26&;>|
Reply
to
author<https://mail.google.com/group/excel-macros/post?hl=en&inreplyto=0b11907becbc087e&reply_to=author&_done=%2Fgroup%2Fexcel-macros%2Fbrowse_thread%2Fthread%2F2d71eadadd4cb494%3Fhl%3Den%26&;>|
Forward<https://mail.google.com/group/excel-macros/post?hl=en&inreplyto=0b11907becbc087e&forward=1&_done=%2Fgroup%2Fexcel-macros%2Fbrowse_thread%2Fthread%2F2d71eadadd4cb494%3Fhl%3Den%26&;>|
Print<https://mail.google.com/group/excel-macros/msg/0b11907becbc087e?hl=en&dmode=print>|
Individual
message<https://mail.google.com/group/excel-macros/msg/0b11907becbc087e?hl=en>|
Show
original<https://mail.google.com/group/excel-macros/msg/0b11907becbc087e?hl=en&dmode=source>|
Report
this
message<https://mail.google.com/groups/abuse?hl=en&group=excel-macros&type=message&url=http%3A%2F%2Fgroups.google.com%2Fgroup%2Fexcel-macros%2Fmsg%2F0b11907becbc087e&_done=%2Fgroup%2Fexcel-macros%2Fbrowse_thread%2Fthread%2F2d71eadadd4cb494%3Fhl%3Den%26&;>|
Find
messages by this
author<https://mail.google.com/groups/search?hl=en&enc_author=UjkkyBQAAACpOsfX19mV7tCtxyUNLJ34OPANdqfI6prRsqjc7uCt1A&scoring=d>
Attach your file
- Hide quoted text -
- Show quoted text -
<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html?hide_quotes=no#msg_0b11907becbc087e>
-----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<http://www.google.com/url?sa=D&q=http://twitter.com/exceldailytip&usg=AFQjCNGu1FQ1iz1Y4SdYu7trtymlxzedvA>
2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310<http://www.google.com/url?sa=D&q=http://www.linkedin.com/groups%3Fgid%3D1871310&usg=AFQjCNER_4_xlKp7U7l1Ec1vgHtJstbGWg>
3. Excel tutorials at
http://www.excel-macros.blogspot.com<http://www.google.com/url?sa=D&q=http://www.excel-macros.blogspot.com&usg=AFQjCNEWiWz7IqiMsarYYjqGXGy2NFt8iw>
4. Learn VBA Macros at
http://www.quickvba.blogspot.com<http://www.google.com/url?sa=D&q=http://www.quickvba.blogspot.com&usg=AFQjCNEp3xFmoQPQIRxMwD-i4FuUpJcvJw>
5. Excel Tips and Tricks at
http://exceldailytip.blogspot.com<http://www.google.com/url?sa=D&q=http://exceldailytip.blogspot.com&usg=AFQjCNHkihVZeG955aZz3Lx93Ge2p7ybgg>
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<http://www.google.com/url?sa=D&q=http://www.facebook.com/discussexcel&usg=AFQjCNG4h6F4vmdjbUiEecMTOJrT_ESb-w>
--
----------------------------------------------------------------------------------
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
