Copy and Paste into same columns

**ash369ster** · 06-26-2015, 04:18 AM

Hello!

I have data in A, C and F and i want to copy that and paste it in another sheet in columns A, C and F but it does not work even with paste special.

Any ideas?

Thanks!

**NeedForExcel** · 06-26-2015, 04:43 AM

Why not copy columns A through F, Paste it where you want, and press the delete key on the B, D & E Columns?

**ash369ster** · 06-26-2015, 04:48 AM

B, D and E has formulas so i need them to remain as it is.

**NeedForExcel** · 06-26-2015, 04:52 AM

Then maybe you will have to paste each columns at once I am afraid..

**ash369ster** · 06-28-2015, 09:45 PM

Thanks! I think that's what i will do.

**NeedForExcel** · 06-28-2015, 11:58 PM

Please mark the thread solved if you have your answer..

**FDibbins** · 06-29-2015, 12:17 AM

If this is a regular process, you could record a macro when you do it, then just run the macro each time?

Copy and Paste into same columns

LinkBack

Thread Tools

Rate This Thread

Display

Copy and Paste into same columns

Re: Copy and Paste into same columns

Re: Copy and Paste into same columns

Re: Copy and Paste into same columns

Re: Copy and Paste into same columns

Re: Copy and Paste into same columns

Re: Copy and Paste into same columns

Thread Information

Users Browsing this Thread

Similar Threads

Macro to Copy from 2 Columns, Paste Value in the next 2 Columns, Then clear 1st Columns

macro to add columns after existing columns and copy/paste headers and formulas

[SOLVED] Faster way to copy and paste multiple columns in Sheet1 to corresponding columns in Sheet2

Copy/Paste data from another sheet Value in Rows paste in Columns

2 Macro's: only vertical copy/paste action and copy-paste 14 columns to the right.

Bookmarks

Bookmarks

Posting Permissions