I am new to VB programming so please let me know if this can be done.
I have a spread sheet of inventory and I have created fromulas that will display "BUY" when a set value is met. What I's like is a macro that will sort by column "B" and then print out all the rows that have the word "BUY" in column "I". The original spread sheet must not be sorted after the macro is done printing. In an ideal world a message box would pop up displaying the items that are going to be printed with the option to print or not. But I think that I am dreaming.
I have been trying to do this for a while and I am lost. I can post what I cant seem to my code to work at all.
Thanks for any help!
-James
