Vba Code To Extract Files

[singupalli]

Hi

I need help.

I have a data base "Inventory" where all records are recorded

I have Data
Date/Item/Type of sale/INVAmt/Rct/amt/Customet Name

Under type of sale i have transactions "Cash" CC"Credit"

I would like to know if there is a Formula or a VBA code to extract all data
Pertaining to "cash" to another sheet
and for CC to another sheet
and so on for all type of sale

and also that these sheets are updated as and when the data base sheet is being updated.

Please assist

Thank you
prasad

 

[Domenic]

You're very welcome! Thanks for the feedback!

 

[singupalli]

Hi Domenic

Is There a way to include a command button to generate the same reports and print/save them to another location.

and by adding date/period wise

thanks