Compare and copy in column
Closed
sigmasolve
Posts
1
Registration date
Friday January 16, 2015
Status
Member
Last seen
January 16, 2015
-
Jan 16, 2015 at 04:28 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 20, 2015 at 02:46 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 20, 2015 at 02:46 AM
Related:
- Compare and copy in column
- Beyond compare - Download - File management
- Excel copy column from one sheet to another automatically - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download - Excel Forum
- Macro to compare 2 sheets and copy differences ✓ - Excel Forum
- How to convert column to row in notepad++ ✓ - Excel Forum
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Jan 19, 2015 at 07:29 AM
Jan 19, 2015 at 07:29 AM
Hello Sigmasolve,
If the blanks in Column A are not a problem for you, then enter the following formula in B2 (I am assuming that you have headings in A1 and B1):-
=IF(A2<>"",A2,"")
and then drag it down as far as you need.
Regards,
vcoolio.
If the blanks in Column A are not a problem for you, then enter the following formula in B2 (I am assuming that you have headings in A1 and B1):-
=IF(A2<>"",A2,"")
and then drag it down as far as you need.
Regards,
vcoolio.
Jan 19, 2015 at 07:10 PM
However, if this is not the case, then I feel the question needs to be clarified.
"copy data in column 'B' when column 'A' is not blank"
implies that the data in column B needs to be copied to somewhere else when A is blank.
Could be wrong though, who knows.
Jan 20, 2015 at 02:46 AM
At least the OP has a starting point to give us feed-back on.
A simple =A2 would probably suffice also.
Let's wait and see.
Cheers,
vcoolio.