I am attempting to populate a cell automatically depending on the input of another cell.
Say for example Cell A1 = 1, then cell A2 would automatically = 100,
I have set up a reference table on another sheet with the initial values (e.g. A1) and required reference (e.g. 100) in a table form,
Can you direct me in the right direction in order to set this up?
Thanks,
Charlie
Bookmarks