Quote:
Originally Posted by Spencer101
Hi,
Is there a reason this needs to be done with VBA?
There are formulas you could use to complete this calculation directly in the cell.
|
I'm trying to automate this process as much as possible. This is a bit of a pain to do manually. The workbook that I'm wanting to find all this information in cannot be written in. Can I do this in the workbook I want to copy the final result to?