print parameters based on if-then

E

excelnut1954

I want to create a macro to print some or all the records in a list
based on an entry in one of the columns. Column A of each record has a
formula looking at a date in the record. Based on the formula, the cell
will show "Send Now" when the date is within a certain range of
today's date. I want to print only those records that show this
message.

I know how to have the macro sort so that all records so that those
records I want printed are at the top of the list. But, I don't know
how have the macro include just those records that show "Send Now" in
column A.
Any suggestions?
Thanks,
J.O.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
VBA word change keys 0
Copy previous record into form field 0
Automation of scanned file storage based on content 0
Excel does not accept text format! 0
Consolidation Table from Different Excel Tabs with Different Format 1
Improving Macro That Keeps First Letter 0
Copy/paste in based on duplicate value in previous row 0

Top