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 copy and paste to another sheet based in cell color

I am trying to write code which will automate a long process. If cells
in columns D or E are red(3) or gold(44), I want it to copy the info in
coulmn B (in the corresponding row)to another sheet called 'MP.' Is
there a way to do this?
Also, I thought I might note that the cells in columns D and E are red
or gold due to conditional formatting.
Thanks.

 
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
Need code to copy and paste based on cell address. GoBow777 Excel Discussion (Misc queries) 1 July 13th 08 07:24 AM
Copy from one Sheet and paste on another sheet based on condition Prem Excel Discussion (Misc queries) 2 December 24th 07 05:05 AM
copy/paste from excel to word including cell color robr Excel Discussion (Misc queries) 0 September 12th 07 03:41 PM
Copy/Paste based on cell content. Hugh Askew Excel Programming 2 April 25th 04 01:06 PM
Copy/paste based on adjacent cell contents Ozbobeee Excel Programming 3 August 9th 03 06:57 AM


All times are GMT +1. The time now is 01:55 AM.

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"