Hello!
I'm new here, so thank you in advance to invest time on this.
I have a task I need to replicate 1,339 times, and wanted to use a Macro to do it, but can't find the solution. What I need is to do is:
Copy 'A2' from one sheet ('Data dealers')> paste it in '$B$2' of another sheet ('Tools') > wait 20 seconds (excel takes some time to run the formulas) > copy cell $B$200 from 'Tools' > value paste it in cell 'G2' of 'Data dealers'
Then, repeat this process going down:
Copy 'A3' from one sheet ('Data dealers')> paste it in '$B$2' of another sheet ('Tools') > wait 20 seconds (excel takes some time to run the formulas) > copy cell $B$200 from 'Tools' > value paste it in cell 'G3' of 'Data dealers'
Copy 'A4' from one sheet ('Data dealers')> paste it in '$B$2' of another sheet ('Tools') > wait 20 seconds (excel takes some time to run the formulas) > copy cell $B$200 from 'Tools' > value paste it in cell 'G4' of 'Data dealers'
....
Copy 'A1340' from one sheet ('Data dealers')> paste it in '$B$2' of another sheet ('Tools') > wait 20 seconds (excel takes some time to run the formulas) > copy cell $B$200 from 'Tools' > value paste it in cell 'G1340' of 'Data dealers'
Is there any way I could do it with a Macro?
A million thanks in advance!!
Ed.
Bookmarks