loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook
I have a need for sometype of loop control, I have a workbook where on
column E and G i'd like to copy data to another workbook. The data in
column E will be placed into a second workbook in cell B1, the value
copied is then multiplied by 25.4. In column G of the first workbook I
then copy it's value to the second workbook and place into cell B3, it
is then multiplied by 1000.
The second workbook I can then perform some calculations, which I've
figured out already by macro, the value in cell B7 resulting from the
calculations is then placed into column K on the first workbook, but on
the same row I took the origianal data from. The macro would then
continue looping through until no more records are present in column E.
Can anyone help
Regards
burl_rfc
|