Hello,
I request help creating a formula or vba that makes Column C equal the cells from Column A and B. For example:
Col A.....Col B.......Col C
1..........3...........1
2..........5...........3
........................2
........................5
Thank you.
Last edited by dbelliottexcel; 07-21-2014 at 07:04 PM.
maybe this in C1...
=A1+B1
copied down
Adjust cell references as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you, Ford.
However, I do not want to perform arithmetic. Column C will contain twice as many rows as Cols A and B.
Thanks.
Dustin
Try this:
or,
Please Login or Register to view this content.
Please Login or Register to view this content.
Cheers, berlan
Last edited by berlan; 07-21-2014 at 07:38 PM.
Hi, Berlan.
Thank you very much. Your second code works perfectly. Excel says "subscript out of range" on the first code. Thank you for solving my problem!
Dustin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks