Macro to insert rows with copied text a certain amount of times based on a value in a cell

I am very new to VBA coding and am just learning the basics now, any direction is appreciated. I currently have an excel file with a table (Shown below) that has 3 columns.

Site____Org Chart Titles______________________Headcount
BAT____Tooling Coordinator______________________8
BAT____Business Leader_________________________1
BAT____Tooling Machinist________________________2
CVG____Technician_____________________________32
CVG____Advanced Deployment Technician___________1
CVG____Business Leader_________________________1
CVG____Chief Inspector__________________________1
CVG____Customer Support Planner_________________3
CVG____Engineering Specialist____________________1
CVG____Material & Logistics Coordinator____________2
CVG____NDT Operator__________________________1
CVG____Office Manager_________________________1
CVG____Production Leader_______________________1
CVG____Quality Manager_________________________1
DFW____Technician_____________________________32
DFW____Advanced Deployment Technician___________1
DFW____Business Leader_________________________1
DFW____Chief Inspector_________________________1
DFW____Customer Support Planner________________3
DFW____Engineering Specialist____________________1
DFW____Material & Logistics Coordinator____________2
DFW____Office Manager_________________________1
DFW____Production Leader_______________________1
DFW____Quality Manager________________________1
DFW____Tooling Machinist________________________2


I need a code that will see the number in the 3 column (headcount) and add that many rows below the original - 1 with the data from the first two columns being duplicated in the added rows. So I have the amount of rows total with the same text as the number listed in the third column. For example the first 3 rows from original data need to look as follows:

Site____Org Chart Titles______________________Headcount
BAT____Tooling Coordinator_______________________8
BAT____Tooling Coordinator
BAT____Tooling Coordinator
BAT____Tooling Coordinator
BAT____Tooling Coordinator
BAT____Tooling Coordinator
BAT____Tooling Coordinator
BAT____Tooling Coordinator
BAT____Business Leader_________________________1
BAT____Tooling Machinist_________________________2
BAT____Tooling Machinist


I really appreciate any help with this macro that anyone can provide!

**Sorry for the weird formatting had trouble pasting in table**

Try this:

Please Login or Register  to view this content.

Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.