Forum Discussion
Trying to transfer information from one excel sheet to another.
Hello, I'm new and just learning how to work excel, I was wondering how or what formula would I use to make it so that when I put information on one sheet it would transfer over to another excel she...
Let's say you enter information in cell B2 on Sheet1, and you want to see the same information in cell D4 on Sheet2.
Enter the following information in D4 on Sheet2:
=IF(Sheet1!B2="", "", Sheet1!B2)
If B2 on Sheet1 has specific formatting, for example as a date, apply the same formatting to D4 on Sheet2.