I can't seem to get the right lingo to search for the answer on the internet. How can I achieve this setup:
With 2 or more worksheets in 1 workbook.
I want to link cells A4, C4 or D4, from Sheet1 to A4, C4 or D4 in Sheet 2 BUT ONLY if: Cell G of Sheet1 has a value (a dollar amount in it) and if it does not have a value in it - nothing happens.
I have linked one cell between sheets before but I wanted to do the above. It is my intention for a person to fill out one sheet and then it automatically links to other named sheets with pertinent cells being automatically filled in.
Hope I am making myself clear.
=IF(G4<>"",Sheet2!A4,"")