Trying to create a 2nd workbook to mirror the first, to protect the original

[zachdking]

Ok, I am new to the forum, My name is Zachary King, I work as a tech officer for a college law enforcement department.

I have created a worksheet that track the hours worked by our officers, we have had issues with people altering the schedule that should not be able to. we have measures in place but want to create a separate work sheet that everyone can open to view the information that we want them to see.

I was able to create the work sheet, it automatically updates with the information from the original, but we use color coded cells to denote the location of the shift. I cannot figure out a way to make the worksheet pull the data and color formatting.

Any help would be extremely helpful and thank you in advance.

[FDibbins]

Hi and welcome to the forum

If you are using regular formulas to pull inthe data, you cannot pull in formatting through formulas. I would suggest that whatever method is used in teh 1st WB (Conditional Fornatting?) is used inthe 2nd 1.

As far as needing a 2nd WB though, I would have thought that if you saved the file as read-only, then only those with a password could make changes (and save them), all others would just be able to open the file as read-only, and any changes they made would not be save-able

[zachdking]

you are correct, that is what we are doing now, but there is information on the original that we have to hide due to employee privacy. so right now we make do alot of hiding and unhiding of rows and columns. What I am trying to do is create a second WB that will only pull certian sections from the original.

The issue with the color is that it is not doen by the program, We enter the color to differenciate locations. So if the shift is at our main campus it is green, our downtown campus it is yellow. I have not found a good way to either, make a conditional format that wont mess with the hours calculation, or to pull what color we make the cell into the other page.

[FDibbins]

We enter the color to differenciate locations

You could use that to make CF change color.

Without seeing some sample data, and what your expectation is, its hard to offer much more