Hi, I am new to programming VB and Macros,
I am basically a test engineer hence i have lots of testing data saved in form of CSV files.
I have some how managed to load all the data related to one particular test in one excel file.it has three sheets namely "database" , "charts" and "process" sheets.
I actually wanted run a macro to be able to dynamically select data from database sheet and show/import it on "process" sheet.and to show pivot chart on "charts" sheet for data which has been imported to procees sheet.
When i say dynamically select data i mean, for example UnitNumber, Lengths, Expected Lengths, Rates, Technology, Sync Time are some of the fields of the database sheet,

Step 1:On running the macro , i should have option to add multiple queries like, UnitNumber=30; Technology=VDSL; show lengths,Rates,
or
Show UnitNumbers,Rates where Length=ExpectedLengths,

Step 2:
After the data has been pulled up on the "process" sheet, on running another macro should create a pivot chart on the "charts" sheet.

Hope you might have understood what am i trying to explain here.just let me know if anything else is required.Idea is to organise the data in a simple and easiest way ,yet easily refer the old data whenever there is a need and analyse using the charts.

Thank you in advance