Hi Everyone!
I have a set of Dashboards that (in hindsight) need to include a method to error check the data entered.
There are 13 sheets of consequence named: Dashboard, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec.
On the "Dashboard" sheet, aside from pivot charts, there is a table of codes that staff must use to code their daily activities (these columns serve mainly as a reference for processing the pivot tables on another sheet). The "Month" sheets are where the data is entered for each workday.
The Dashboard Code table runs from AW7:BB120. Columns AW (Municipality), AY (Program), and BA (Activity) contain the codes, and other three columns explain the codes (e.g., Code: BRK Name: Break).
On all of the "Month" Sheets, these codes are entered in columns L through Q. Each row of these columns contains a merged cell (i.e. L10:M10, N10:O10, P10:Q10). The cells in the merged "L:M" column are where the Municipality codes are entered ("Dashboard" Column AW), "N:O" is where the Program codes are entered ("Dashboard" Column AY), and "P:Q" are where the Activity codes are entered ("Dashboard Column BA").
The full range for data entry is L10:Q1600.
What I'm hoping to achieve: I'd like to be able to run a macro on whichever Month is the activesheet that compares the data columns on that month's sheet to the data table on the Dashboard sheet. I'd like it to then list the physical address of any cell that has data entered but does not match one of the Dashboard table's codes (e.g., if cell N249 had the code BK instead of BRK (for break).
There are only two duplicate codes that exist in both the Program and Activity Columns. They are BRK for Break and UNL for Unpaid Leave. Otherwise all codes are unique.
Is this possible to achieve with a macro?
Ideally the code would write the physical cell addresses to the merged cell V5:AF7 on sheet it is run on, separating each address with a comma.
Any and all help would be greatly appreciated!!!!
Thank you in advance,
-LM
Bookmarks