Advanced Microsoft Excel Formulas

[sebargentino]

i have a home sheet 1 and sheet 2 and sheet3

now i sheet 1 i spent 50 dolars so it will appear in sheet 2.

now i try to put new columns in 1, and i put the # but nothing appear in sheet 2.

how can i make it work?

[davemaciasarch]

I want to see if it is possible to input the information on the time sheet like (2) for floor level and (3) for job code and it will know what cell to reference on the table below with the hours

[davemaciasarch]

Let’s say you have a typical Microsoft excel sheet and on the bottom you have standard table. You have 5 rows vertically on the left of job codes, like (1-engineering) (2-coordinating) (3-support) (etc). And five columns horizontal on top of building floors, like (1st floor) (2nd floor) (3rd floor) (etc). And above that whole table you have a simple time sheet layout consisting of 4 cells running horizontal as follows Date , floor level , job code, and hours

[XTOMMY1968X]

I wrote what you just displayed on a excel sheet, someone mistakenly put a value in the total cell instead of the(price cell) and stuffed the whole formula for the invoice. how do you protect that ?