I want to copy some information into a new column (lets say column C) from a different column (lets say Column A). Column A has blank cells along with cells with numbers. I only want to copy the numbers into Column C. Can some one please help?
I want to copy some information into a new column (lets say column C) from a different column (lets say Column A). Column A has blank cells along with cells with numbers. I only want to copy the numbers into Column C. Can some one please help?
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
I am loading a example. I am relatively new and do not understand your solution.
This is a macro to do the copy and paste. It filters column A to get only cellls with values and then copies only the cells with values to column C. I have modified it based on your example.
To use the macro, Open the vb editor by pressing Alt + F11. If the editor pane is dark gray, then click 'Insert' on the menu bar, then click 'Module'. You only have to do this one time. If you save the workbook as a macro enabled workbook. When the code pane brightens, paste the code into the pane. Close the editor and to run the code, Press Alt + F8, click on the macro name and then click 'Run'.Please Login or Register to view this content.
If you prefer a formula, someone else will have to help you, I am not good with complex formulas.
Thank you for your help. I followed your instructions. When I ran the macro I an error message:
"Microsoft Visual Basic
Compile error:
Expected list separator or )"
Any help you can give me will be really appreciated.
Did you copy and paste the code into the code module or retype it? That error means you are missing a Parenthesis somewhere in the statement that is highlighted when you click the 'Debug' button. I cannot get the same error when I run the code as shown in Post # 4.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks