Cut cells into external book and copy result

Closed
Report
Posts
2
Registration date
Friday September 18, 2009
Status
Member
Last seen
September 20, 2009
-
Posts
2
Registration date
Friday September 18, 2009
Status
Member
Last seen
September 20, 2009
-
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 reply

Posts
2
Registration date
Friday September 18, 2009
Status
Member
Last seen
September 20, 2009

Come on guys.. someone must know.