Repeating a task (macro)
Posted: Thu Apr 14, 2011 2:14 pm
Hi all,
Thanks in advance for any advice. I have searched around
but cannot work out how to have a macro repeat. Basically
I have a spreadsheet of 3,000 lines of search terms of
which I want to perform a search on each one. It goes
like this;
1. Open spreadsheet
2. Copy cell
3. Enter search term in other app
4. Save results
5. Return to spreadsheet and delete original term
6. Repeat from Step 2
I have saved the above as a macro but I can't find where
to have steps 2-5 repeat.
Thanks!
Thanks in advance for any advice. I have searched around
but cannot work out how to have a macro repeat. Basically
I have a spreadsheet of 3,000 lines of search terms of
which I want to perform a search on each one. It goes
like this;
1. Open spreadsheet
2. Copy cell
3. Enter search term in other app
4. Save results
5. Return to spreadsheet and delete original term
6. Repeat from Step 2
I have saved the above as a macro but I can't find where
to have steps 2-5 repeat.
Thanks!