Here's the scenario.
I have a list of about 70-80 different investment funds located in column A. Column B is empty. Column C will have some 15 or so investment funds, all of which will also be located in column A. the column next to Column C will have a dollar amount that corresponds to the investment account name in column c. Additional columns to the right of column c will demonstrate the same concept, just additional fund names with investment amounts. The objective was to set up a macro that by using the search and find functions, of the edit menu would allow me to search column c for each of the names of the funds located in column a. When one of the funds was not found, then skip that and go to trying to find the next fund. Then move the amount column and copy that value to the clipboard. then move to column a and do the same search and find function thereby finding the named fund, move the curso to column b and paste the value into that location.
If anyone can get back to me on this, I would really appreciate it.
I have a list of about 70-80 different investment funds located in column A. Column B is empty. Column C will have some 15 or so investment funds, all of which will also be located in column A. the column next to Column C will have a dollar amount that corresponds to the investment account name in column c. Additional columns to the right of column c will demonstrate the same concept, just additional fund names with investment amounts. The objective was to set up a macro that by using the search and find functions, of the edit menu would allow me to search column c for each of the names of the funds located in column a. When one of the funds was not found, then skip that and go to trying to find the next fund. Then move the amount column and copy that value to the clipboard. then move to column a and do the same search and find function thereby finding the named fund, move the curso to column b and paste the value into that location.
If anyone can get back to me on this, I would really appreciate it.