I have a memberlist with debts owed per member that I need to organize. There are a lot of members, and so I have organized it alphabetically.
IE the first sheet is called A and contains all entries for members with names beginning with A, the next sheet is called B containing all names with the first letter B, and so forth.
The "A" column contains the name of the member, the "H" column contains the total debt. Not all members have debt, some have positive values in this field. What I need is a macro that copies the value from "A" and "H" for all values of "H" that are less than zero, and compiles them into a single list. I basically wish to be able to browse all members who are in debt, without having to filter 26 separate lists.
Only Columns "A" and "H" are relevant for me, the other rows are merely used in the calculation of said debt.
The value in "H" is thus the result of a calculation, and not a typed number.
The number of columns will never vary, but the number of rows might as members come and go.
The worksheet number for the list will be number 27, I do not know if that is relevant.