Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help: Paste Column Contents to Next Available Column Without Data
I'm attempting to setup a macro where it copies all of the info from
column F and pastes the contents (Values only) into the next available empty column to the right (same worksheet). Therefore, each time the data is pasted it's pulled from the same column (F) and is pasted a column further over to the right everytime. I would like to paste only the values of the originating cells as well, no formats or formulas. Any help would be very much appreciated. Regards, Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help: Paste Column Contents to Next Available Column Without Data
Michael,
Try some code like the following Dim Rng As Range For Each Rng In Range("F1:F10") '<<< CHANGE RANGE Rng.EntireRow.Cells(1, Columns.Count). _ End(xlToLeft)(1, 2).Value = Rng.Value Next Rng -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message oups.com... I'm attempting to setup a macro where it copies all of the info from column F and pastes the contents (Values only) into the next available empty column to the right (same worksheet). Therefore, each time the data is pasted it's pulled from the same column (F) and is pasted a column further over to the right everytime. I would like to paste only the values of the originating cells as well, no formats or formulas. Any help would be very much appreciated. Regards, Michael |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help: Paste Column Contents to Next Available Column Without Data
Chip,
Thank you so much for the code, this worked very well except I think I need one tweak to it. The string you supplied me with puts the data for each row into the next available column to the right, meaning if the first 10 rows had data in all 3 columns to the right, yet the second 10 rows had data only in the first column to the right, the data pastes into different columns with in the same running of the macro. Is there any way to get the macro to paste all of the column data into the same column, the first available column to the right? Please let me know if this does not make any sense and you need more info from me. Thank you again so much for the help with this, it is greatly appreciated. Regards, Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste changing cell contents to consecutive cells in a column | Excel Worksheet Functions | |||
Fill a column with the contents of another column based on a choic | Excel Discussion (Misc queries) | |||
how to copy contents of one column to another column in another worksheet | Excel Discussion (Misc queries) | |||
move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Copy contents in a row and paste in a column | Setting up and Configuration of Excel |