Sorry I was not clear.
What I am trying to do is enter all information into the first worksheet and have the same information feed to other worksheets within the same workbook. Please pardon my lack of knowledge on how to paste snapshots of what I am doing.
Worksheet #1
REFRESH BUTTON
X - Days Off (black) SL - Sick Leave (pink) V - Vacation (blue) T - Training (orange)
PL - Personal Leave (green) CF - Conference (aqua)
H - Holiday (red) A-Authorized Leave (purple)
***(desired font colors)
Worksheet #2 (Information from #1)
1-Jan 2-Jan 3-Jan 4-Jan 5-Jan 6-Jan 7-Jan
JILL
MARY
BOB
JOE
PHIL
I would like to have the letters be the colors listed above in the entire workbook without having to select each sheet and individually changing each letter for 50 employees for the entire year. I am not sure how to get started.
Does this make sense? I hope so, I am getting quite frustrated as I have been working on this all weekend and am still far from being done.
Thanks again,
aswb
As a side note: The only other visual basic code I have worked with was already written and I just added the color for the background based on the typed in number in a range of cells. I was able to figure that much out.
Bookmarks