morganray
(Captain Morgan)
1
I have a single worksheet with 9 sheets. 1st sheet has a list of all users and data matching users. For each day they worked there will be a new row with their name (Max of 6 Rows). So A1-A3 is one name and A4-A10 is another and so on with no constant amount of days worked. Sheet 2 has a list of employees matched to their group. So A1-A5 is Sally Sam Dave Bob and Rick B1-B5 is filled with Lansing. Sheet 3-9 is each group. How would I create a macro that Grabs the Group Name from sheet 2 → Pulls a name → Grabs all data from Sheet 1 that matches the Name → Copy all data relating that name to the appropriate worksheet. And repeat for each name in sheet 2 attached to the group. Then The next group will dido to sheet 4 and so on. I know this is possible but I am new at excel and only know the basic stuff. I am able to find code that copys and pastes and VLookup might work but I am not experienced enough to mash it together. Below is what I am working with. First picture is sheet 1 and second picture is sheet 2.
3 Spice ups
dulrich
(Bugfixr16)
2
https://exceljet.net/formula/merge-tables-with-vlookup
https://exceljet.net/formula/join-tables-with-index-and-match
Use one of these formulas in the group worksheets. I would actually just put the group qualifiers at the bottom of each of the individual group sheets that they belong to and then hide the cells.
