Hi, I have a vba problem that probably has a very easy answer.
I have the code below which formats a table so that I can make a pivot table out of it. What I need to do now is to apply this code to 3 different sets of worksheets. The first set (below) takes data from "M) Avg Hrs- Month" and formats the values into a table labeled "M) Data for PT." I know need this code to run for "A) Avg Hrs- Month"/ "A) Data for PT" and "N) Avg Hrs- Month"/"A) Data for PT." I canot just copy and paste the code and change the names of the worksheets it uses because the variable names are the same.
Thanks in advance everyone!! I am a BIG vba novice so any help is appreciated!
A sample workbook is attached!
Please Login or Register to view this content.
Bookmarks