I'm working with 2 Excel sheets, PLY TABLE and LIBRARY TABLE.
PLY TABLE will allow the user to insert the corresponding data and the LIBRARY TABLE will display the summary of the data entered in PLY TABLE.
The problem is that, how could I possibly do a mathematical operation to the value in PLY TABLE to be displayed in the LIBRARY TABLE?
Example: I want to add the value in PLY TABLE, cell H29 with 6? I tried to used this code, but it doesn't work out.
=('PCR-Master'!H29)+6
I believed that this is just a simple one, but I really don't know how.
Any ideas?
Any help is appreciated.
PLY TABLE will allow the user to insert the corresponding data and the LIBRARY TABLE will display the summary of the data entered in PLY TABLE.
The problem is that, how could I possibly do a mathematical operation to the value in PLY TABLE to be displayed in the LIBRARY TABLE?
Example: I want to add the value in PLY TABLE, cell H29 with 6? I tried to used this code, but it doesn't work out.
=('PCR-Master'!H29)+6
I believed that this is just a simple one, but I really don't know how.
Any ideas?
Any help is appreciated.