Thread: [Solved] How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank?
View Single Post
 
Old 04-25-2011, 03:38 AM
Learner7 Learner7 is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank?
Hi,

How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank? If cell "A1" is blank then it should not copy anything to cell "B1"?

I have hundreds of cells which is to be modified. The problem is some cells in column "A" are blank. In that case it should not copy anything to related cell in column "B" because most of column "B" cells also contain data.

Please help.
Reply With Quote