VBA to run a Quote Report

[dansharpe]

Hi,

First post on here so hello to anyone kind enough to read this and offer some help.

I've attached an Excel Spreadsheet that I am looking to use to enter quote details as I produce them at work. My idea is then to type into Column 'G' the relevant status of the quote.. i.e. Won, Lost, Active.

I then wanted to be able to hit a button on the worksheet, which will take the 'Active' quotes from the main Quote worksheet, onto another I've entitled 'Quotes Outstanding', and display in the same format. This way I'll be able to see more easily who I need to chase down to close deals!

Any help would be appreciated.
Dan.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[dansharpe]

Amazing! This seems to work very well. Thank you for your help.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.