Cut cells into external book and copy result

Closed
Aysal Posts 2 Registration date Friday September 18, 2009 Status Member Last seen September 20, 2009 - Sep 19, 2009 at 03:10 PM
Aysal Posts 2 Registration date Friday September 18, 2009 Status Member Last seen September 20, 2009 - Sep 20, 2009 at 11:53 AM
Hello everyone! I'm new here and I hope i'll find my sollution here as well. I have two workbooks: a price converter and product list. I want to copy/cut all the cells that are formatted as currency and numbers from all the sheets inside products.xls and place them into the prices workbook in column A. Then copy the result from column C back into the products workbook where the original cells were.
I think it can be done but I ain't so good at vba as to what it can/can't do. I attached the 2 workbooks and wainting for you input.

Thanks in advance for your time and consideration,
Aysal

http://www.mediafire.com/?gvdtnzn2ykk
http://www.mediafire.com/?jhiz0etwwou

1 response

Aysal Posts 2 Registration date Friday September 18, 2009 Status Member Last seen September 20, 2009
Sep 20, 2009 at 11:53 AM
Come on guys.. someone must know.
0