Environment: I am using Excel 2003 and self taught in excel and VBA. I am very new to VBA and if pointed in the right direction will learn a topic. However I need direction
I have a mockup of a Call Center floor seating diagram called "Seating Chart" Workbook and Spreadsheet. "Seating Chart" Workbook pulls information from "CC Database" Workbook and "Master" spreadsheet based on Seating location, Nick Name, and Extension and fills in the correct cells in the diagram.
Task: What I need is to be able to look at the names in the "seating chart diagram" find which Supervisor they are assigned to and color the cell according to the supervisor.
Problem: I believe I need to accomplish this with a VBA macro because the colors I need exceeds 3 color conditional formatting limit Excel 2003 has.
I know I need to use either a Vlookup or Index/Match formula and assign it to a variable and see if it's contents match the supervisor and color the cell accordingly.
I understand what I am asking is complicated in a huge spreadsheet with multiple areas.
I just need help getting started with the first couple rows of seats and I can use the examples you guys guide me on to finish the rest of the chart. But I just don't know how to get started or stitch the concepts together into a working macro to run through the entire spreadsheet.
Your help is greatly appreciated
I have a mockup of a Call Center floor seating diagram called "Seating Chart" Workbook and Spreadsheet. "Seating Chart" Workbook pulls information from "CC Database" Workbook and "Master" spreadsheet based on Seating location, Nick Name, and Extension and fills in the correct cells in the diagram.
Task: What I need is to be able to look at the names in the "seating chart diagram" find which Supervisor they are assigned to and color the cell according to the supervisor.
Problem: I believe I need to accomplish this with a VBA macro because the colors I need exceeds 3 color conditional formatting limit Excel 2003 has.
I know I need to use either a Vlookup or Index/Match formula and assign it to a variable and see if it's contents match the supervisor and color the cell accordingly.
I understand what I am asking is complicated in a huge spreadsheet with multiple areas.
I just need help getting started with the first couple rows of seats and I can use the examples you guys guide me on to finish the rest of the chart. But I just don't know how to get started or stitch the concepts together into a working macro to run through the entire spreadsheet.
Your help is greatly appreciated