Hi!
I have a sheet with two columns A and B from 1 to 3002.
Column B has some cells filled where as cell A is completely full. I need another column maybe C for example if B2 is empty then C2 will be equal to A2. The other option is if B2 is not empty then C2 will be equal to B2. How can I do that for only one sheet in the whole workbook at a time.
Any help will be most appreciated. Thanks
Sanyam
You don't have to use a separate column, you can fill in the blanks right in column B if that's your real goal:
How/Where to install the macro:
Please Login or Register to view this content.
1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet
The macro is installed and ready to use. Press Alt-F8 and select FillInTheBlanks from the macro list.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
If you really want a formula in column C, then put this in C1 and copy down:
=IF(B1="",A1,B1)
Another way since you said "Merge Two Columns"...
1) Highlight column B
2) Copy it
3) Highlight column A
4) Select Edit > Paste Special > Skip Blanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks