Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Copy and Paste some cells, but not all

The situation I have is that I have 2 workbooks (WB1 and WB2).
--There are values in WB1 I am interested in and values that I am NOT
interested in.
--These values of interest are present in WB2, and in the very same
cells as they were in WB1. There are also extra values in WB2 that I
am interested in, but they are not present in WB1.
--Is there a way of formatting the values (ex. Bold) I am interested
in, in WB1 -- then possibly Pasting them onto WB2?

The result I am interested in would be a workbook that
--no longer has the uninteresting WB1 values
--has Bold WB1 values
--has WB2 values that have NOT been replaced by the uninteresting
values from WB1 (which would take place if I had simply Copy and
Pasted all of WB1 to WB2.

If this makes no sense, I may be able to get more specific.

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
how copy formula and only paste into 20,000 cells dlb1228 Excel Discussion (Misc queries) 1 February 28th 07 09:30 PM
Copy/Paste Visible cells only Ashley Excel Discussion (Misc queries) 1 October 17th 06 09:17 PM
Copy/Paste how to avoid the copy of formula cells w/o calc values Dennis Excel Discussion (Misc queries) 10 March 2nd 06 10:47 PM
how can we copy cells comments text and paste to cells שי פלד Excel Discussion (Misc queries) 3 December 12th 05 05:16 AM
copy and paste between cells that have data mstack Excel Worksheet Functions 1 November 16th 05 09:16 PM


All times are GMT +1. The time now is 05:04 AM.

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"