Copy Paste Print Between two worksheets

Hello Forum,
There are two workbooks "white" & "Black".
The Problem has three parts :
step 1:
Copy date From "Black" Sheet1 Column D and paste in this format .Copy Paste this till the end of data string.
step 2:
Now if
old>0,and Bold> 0 and Cold>0,then copy to new Work Book " white" Placed on Desktop ,sheet A
step 3:
Print the Details from work Book "white",sheetA.
Any inputs are welcome.
Happy Holiday !

Hello nuttycongo123,

The macro below has been added to the attached workbook. A button on "Sheet2" will run the macro. The macro checks to see if the workbook "White.xls" or the name you decide to use exists. If it does then you are asked if you want to overwrite the existing data. If you answer yes then the old data is overwritten with the current data in "Black.xls", otherwise the data from "Black.xls" will be appended to "White.xls". You also have the option of canceling the macro.

Please Login or Register  to view this content.

Thanks for the response I will revert with the outcome ..
Thanks Once again Leith,Happy Holidays

Hello Leith,
I notice that the date is not getting picked up the way it should be in WB Black from Sheet1 to Sheet2 in cell D2.
Regards