I need a macro to extract data from a database

[AmicusA]

Hi,

I would like to extract, from the sheet "Database" of the here attached WB "DataToBeExtracted", the values in the blue columns R, S, T, for every person (represented by letters in column B) for which at less one of the 3 values >0, for a month to be determined by an Inputbox, and paste and arrange the data in a new WB like the second one attached (DataArranged).
At the end it has to be "saved as": see the instructions in "DataArranged".

Valete!
AmicusA

[Mumps1]

Place this macro in your "DataToBeExtracted" workbook and save the workbook as a macro-enabled file. Make sure that your "DataArranged" workbook is also open and run the macro.

Please Login or Register  to view this content.

What is the folder path of where you want to save the file? This part is missing from the macro.

[AmicusA]

Hi,
Thank You very much for this nice work!
Actually I don't know myself the real path; for now it is on my PC: C:\Users\jd\Desktop\Heures 2018
Kind regards
AmicusA

[Mumps1]

You are very welcome.