Sort and print based on Cell Value

**jamesstorx** · 04-21-2009, 02:37 PM

I have a sheet that has "NR" or Buy" in colomn A. I want an input box to open and tell the user the total number of "buy" found and aski if they want to print a report. If they choose yes to print then the macro will sort by colomn B and print all the rows that contain "Buy"

Please let me know if this is even possible.

Thanks
-James

**Leith Ross** · 04-21-2009, 03:59 PM

Hello James.

What will trigger the appearance of this input box?

**jamesstorx** · 04-21-2009, 04:28 PM

When the user runs the Macro. Possibly by using a hot key type setup

Thanks in advance for your help

**Leith Ross** · 04-21-2009, 07:58 PM

Hello James,

This macro looks at the data on "Sheet1" and creates a report on "Sheet2". A report sheet has to be used for printing. If all the cells aren't contiguous, a new sheet will be printed where the rows break. You can change the worksheet names and starting cells. They are marked in red. It is assumed each worksheet has a header row. If you aren't using a header row, let me know. The sorting routine may not work correctly if there is no header.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click

the macro's name to Run it.