• 0

Can this be done with excel vba?


Question

Hello neo gurus! I need some advice from you guys about a script if it is possible. I have three workbooks: one is a price converter, the other is a list from the distributor with updated prices and the last is an import workbook with all the products that will be uploaded to the site.

Is it possible to copy all the cells formatted as currecy and numbers from the product list into to the price converter, then copy the resulting price and place it in the uploads file in it's rightfull row (based on the sku)?

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

excel is very powerful (perhaps too powerful), and what you describe is certainly do able as you can reference things in other workbooks no problems..

so, short answer.. yes :)

however, longer answer... i question your method here in using excel for this task..

anyway, so long as you are not actually storing data in workbooks then I'm sure it's fine ;)

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.