libor01
New Member
Hello to all,
I am not new to excel but quite new to VBA, and I would kindly ask for help how to automate process of selecting data from worksheet “report” to worksheet “destination”. I am able to adjust worksheet ‘report’ so that I can select all names from column “A” to sheet ‘destination’. Name should work as source for other data, but not the only one. Based on the criteria in worksheet ‘destination’ I need to count all breaks for specific name. Breaks consists of break, lunch, and restroom. Does you or someone know how to combine ‘vlookup’ and probably ‘hlookup’ together with loop in vba or is there better solution if each name does not have all that needs to be counted? Rnge of names is the Limitation for loops. If someone has an idea see attached .xlsx sheets for consideration and part of my vba code.
I am not new to excel but quite new to VBA, and I would kindly ask for help how to automate process of selecting data from worksheet “report” to worksheet “destination”. I am able to adjust worksheet ‘report’ so that I can select all names from column “A” to sheet ‘destination’. Name should work as source for other data, but not the only one. Based on the criteria in worksheet ‘destination’ I need to count all breaks for specific name. Breaks consists of break, lunch, and restroom. Does you or someone know how to combine ‘vlookup’ and probably ‘hlookup’ together with loop in vba or is there better solution if each name does not have all that needs to be counted? Rnge of names is the Limitation for loops. If someone has an idea see attached .xlsx sheets for consideration and part of my vba code.