ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy and Paste some cells, but not all (https://www.excelbanter.com/excel-discussion-misc-queries/143096-copy-paste-some-cells-but-not-all.html)

J.Meyer

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.



All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com