I have 2 sheets. When I type a name (persons name) in a cell on shee1, I want it to be mirrored in sheet2. I know how to make that happen with a reference but if I don't have a name on sheet1, sheet2 shows a "0". I would like the cell in sheet2 to just be blank.
Its probably an "if" statement??? or simply text formatting?
Any help would be much appreciated!
=IF(Sheet1!A1<>"",Sheet1!A1,"")
maybe this works
Last edited by bibu; 04-08-2014 at 11:04 AM.
for some reason that does not seem to work?
I tested it and it works, just paste it into any cell in Sheet2 and it will show the value from Sheet1!A1
And of course you can replace A1 with the desired cell.
sheet1 is named Approved and sheet2 is named Totals, I changed the names but no luck?
It's putting the formula in there and not the name?
You can also add the cell reference if you select the "Sheet1!A1" part of the formula(while the formula is inside a cell) and then go and select the sheet and the cell that you are interested in.
or try
=IF(Approved!A1<>"",Approved!A1,"")
Last edited by bibu; 04-08-2014 at 04:24 PM.
I moved to a different cell and it worked. Thank You
Last edited by RandyD123; 04-08-2014 at 10:33 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks