I have a workbook with a summary sheet and 7 supporting sheets. I need a
macro that will take an account number from the summary sheet, find where it
is in one of 6 of the supporting tabs and return the amount corresponding to
that account number to my summary sheet and put it in the specified column.
Each account will occur only once in the 6 tabs, which means that each
account occurs in 1 of the tabs and not in the other 5. Ideas?? Thanks!