hello guys,
how to insert two rows of text in column b1:c1 from sheet 2 into sheet 1 in column b1:c1 automatically? any ideas?thanks.
hello guys,
how to insert two rows of text in column b1:c1 from sheet 2 into sheet 1 in column b1:c1 automatically? any ideas?thanks.
Copy and paste the below formula in B1 cell of Sheet1.
=IF(Sheet2!B1="","",Sheet2!B1)
Drag the B1 cell formula to C1.
Hope that helps!
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks