LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste changing cell contents to consecutive cells in a column meggy Excel Worksheet Functions 3 September 4th 07 09:21 PM
Fill a column with the contents of another column based on a choic Sparky56 Excel Discussion (Misc queries) 1 March 31st 07 04:18 AM
how to copy contents of one column to another column in another worksheet yefei Excel Discussion (Misc queries) 3 February 25th 06 05:57 PM
move contents of column C based on criteria related to column A Debra Excel Discussion (Misc queries) 2 December 27th 05 10:25 PM
Copy contents in a row and paste in a column CJMFH Setting up and Configuration of Excel 1 July 15th 05 03:14 PM


All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"