Macro: How Can I Repeat Macro In Other Cells??

  • Thread starter Thread starter Cloudhopper
  • Start date Start date
C

Cloudhopper

I am referencing data in an Excel inventory spreadsheet with over 20,
300 lines. I have written a macro that will reference information
from a cell in worksheet A, find this information in worksheet B (the
inventory spreadsheet) , copy this information from worksheet B back
to worksheet A. The problem is that I need to run this macro on other
cells in worksheet A. Can this be done?

To be more detailed, this is what my macro does:

Copy data from cell A2 in worksheet A
Goto worksheet B (inventory spreadsheet)
Click "find" and paste copied information from cell A1 (worksheet A)
Click "find next" button
Highlight and copy the line information from the "find"
Go back to worksheet A
Paste the information in cells B2 - E2

I then want to run this same thing starting with cell A3 (to be copied
to cells C3 - E3), and so on.

Cloudhopper
 
Take a look at using a VLOOKUP in help. If you need some help with this
function, let me know.
 
Back
Top