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
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