Brandweerman
10-25-2021, 03:44 AM
Hello,
i'm struggling with a problem for some time now.
i'm scheduling a 2 year exercise plan for the 30 fire stations in my region.
It is to big for people to extract their data to work with.
Therefore i want to create a list with a specific search value: put in the value from a drop down list and hit a button to execute the macro.
I would like to find a VBA code that will search for every value (by user input in the sheet cell with a pre-defined list) to search row by row in the range F12:SH191 and then copy:
1) the remark (note in Office 365) from the cell with that value
2) the author of that remark/note
3) the group name of the corresponding row cell in Column E12:E191
4) The schedule date of the corresponding column cell in row F4:SH4
these 4 variables should be placed on a new sheet
where the column names are in row 2 named:
chknr Date(4) group(3) note(1) author(2)
so the first value items set to row 3 then 4, etc.
chknr is a follow up number 1 to ...
Thanks in advance
With kind regards,
Ben
i'm struggling with a problem for some time now.
i'm scheduling a 2 year exercise plan for the 30 fire stations in my region.
It is to big for people to extract their data to work with.
Therefore i want to create a list with a specific search value: put in the value from a drop down list and hit a button to execute the macro.
I would like to find a VBA code that will search for every value (by user input in the sheet cell with a pre-defined list) to search row by row in the range F12:SH191 and then copy:
1) the remark (note in Office 365) from the cell with that value
2) the author of that remark/note
3) the group name of the corresponding row cell in Column E12:E191
4) The schedule date of the corresponding column cell in row F4:SH4
these 4 variables should be placed on a new sheet
where the column names are in row 2 named:
chknr Date(4) group(3) note(1) author(2)
so the first value items set to row 3 then 4, etc.
chknr is a follow up number 1 to ...
Thanks in advance
With kind regards,
Ben