Copying formulas to different sheets

[amalone1021]

Ok here is my issue. I created a schedule for a manager to use. While it tallies a lot of stuff, they do not want employees to see all of this. So I created a new sheet that will transfer only employees' clock in/clock out time. Then, when I did that the formula was something like: =Sheet1!A8. Well, it put 0's in spots that I needed blank. So I figured out this formula to fix that: IF(Sheet1!$A$8="","",Sheet1!$A$8). This works perfectly except I have the first formula input in over 800 cells with different cell references but when I copy and paste the new formula, it keeps the A8 reference instead of updating to the formula I currently have in the cell. Is there a way to keep me from having to input the new formula in 800 cells manually? Sorry if this is confusing, I will try to elaborate.

[Pete_UK]

Do it like this in cell A8 of the second sheet:

IF(Sheet1!A8="","",Sheet1!A8)

Then you can just copy/paste that anywhere else and the cell reference will change as appropriate.

Hope this helps.

Pete

[amalone1021]

So basically I don't need the $'s?