MRichmond
02-10-2012, 03:07 AM
Hello to you gods of VBA
I'm looking for a two part help on this project please
I have a workbook, in a portion of this deals with scores, and the displaying of them.
Part one
There is the main data tab "Audit Scores" and what I need to do, is check for unique values in column B, and then check to see if there already exists a tab for that name, and if not I need it to create that tab, and copy the macros from another of the agent tabs onto this tab (these macros unhide columns, advance filter the Audit scores based on agent name, then rehide the columns).
Part two
There are column graphs covering the data on the agent tab, but i need these to resize automatically based on tne number of rows returned.
I have put my macro's on the worksheet_activate action as there will be otehr sheets that dont need to be touched, and to be honest I'm not sure how I would loop a macro to go through only the required worksheets (column B in "Audit Scores").
Please see sample workbook which may make it easier to decipher my garbled request.
So if anyone can point me in the rgiht direction I would be most grateful.
I'm looking for a two part help on this project please
I have a workbook, in a portion of this deals with scores, and the displaying of them.
Part one
There is the main data tab "Audit Scores" and what I need to do, is check for unique values in column B, and then check to see if there already exists a tab for that name, and if not I need it to create that tab, and copy the macros from another of the agent tabs onto this tab (these macros unhide columns, advance filter the Audit scores based on agent name, then rehide the columns).
Part two
There are column graphs covering the data on the agent tab, but i need these to resize automatically based on tne number of rows returned.
I have put my macro's on the worksheet_activate action as there will be otehr sheets that dont need to be touched, and to be honest I'm not sure how I would loop a macro to go through only the required worksheets (column B in "Audit Scores").
Please see sample workbook which may make it easier to decipher my garbled request.
So if anyone can point me in the rgiht direction I would be most grateful.