Assumption:
- we work on sheet1, cell b1 as description of material and cell e1 as quantity figure.
- we will put the transfer the text in cell b1 to sheet2 cell a1 if you have entered some value in sheet1 cell e1. Otherwise sheet2 cell a1 will left empty or display some text as "NONE" or as you wish.
what you should do is make a formula in
sheet2 cell
a1 like this:
=IF(Sheet1!e1<>"",Sheet1!b1,"")The formula will check
sheet1 cell
e1, if there is any number or text put in there, the value of
Sheet1 cell
b1 will be copied to
sheet2 cell
a1. If you don't supply any number or text in
sheet1 cell
e1, there's nothing will appeared in
sheet2 cell
a1.
If you want some text will display when there's no value in
sheet1 cell
e1 just change the formula like this:
=IF(Sheet1!e1<>"",Sheet1!b1,"NONE") You can modify it as your like. Just copy the formula to another row in
sheet2 column
a.
P.S.: If this information was helpful, please rate this solution.
formula from which i can enter details from one sheet to another sheet automatically
×