Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default copy and paste in different columns with conditions

Hello guys
I have two sheets. In the first sheet there is a table with dat
contained in five columns (A;B;C;D;E).In the second sheet there i
another table with data contained in five columns. I would like to cop
some cells present in columns A,B,D of the the second sheet in th
colums B,C,D of the first sheet, below the data already present.Th
data to copy in the first sheet are only those which have in column
of the second sheet the text "#D/N".
I attache a file whit the axample

Sorry for my not good english and thanks in advance for your hel

Attachment filename: prova.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=42085
--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default copy and paste in different columns with conditions

Thank you very much Otto, The macro works very fine
Bye


---
Message posted from http://www.ExcelForum.com/

Reply
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
copy conditional formatting, paste format without conditions jasonr17 Excel Discussion (Misc queries) 6 May 2nd 08 05:52 PM
How to Copy and Paste Several Columns of Data into Excel... ? M_FLEMING Excel Discussion (Misc queries) 3 May 18th 06 04:35 PM
copy and paste visible columns ferde Excel Discussion (Misc queries) 1 December 8th 05 08:42 AM
Why can't a copy and paste columns? Nicole L. Excel Worksheet Functions 3 February 10th 05 06:55 PM
Copy/Paste of separated columns mareku Excel Discussion (Misc queries) 2 January 5th 05 10:04 PM


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

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

About Us

"It's about Microsoft Excel"