Cut cells into external book and copy result

Closed
Aysal Posts 2 Registration date Friday 18 September 2009 Status Member Last seen 20 September 2009 - 19 Sep 2009 à 15:10
Aysal Posts 2 Registration date Friday 18 September 2009 Status Member Last seen 20 September 2009 - 20 Sep 2009 à 11:53
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
Related:

1 response

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