PDA

View Full Version : VBA HELP



96gtsmoker2
09-14-2008, 08:53 PM
What I need is to take the data from Data_1 page and seperate on the first three pages.
Date IS shows only the date issued. Date PD only shows those with date paid. And Date STP shows only those from
Date stop. Only when that is complete I want to take the data_1 and erase it. Then take Data_2 and match date, check #, and amount with a vlookup. If matches paste the address and ADR from DATA_2 onto the first three sheets that match the three categories and delete the information. Then when I go to add my next check book information in there it pastes the new stuff from DATA_1 below the previous. Can any one help on this. It is to help balance my bills.

96gtsmoker2
09-14-2008, 09:28 PM
Is there any questions. I have a VLOOKUP in one column but it slows down really bad and it does not delete the old and it does not recognize when I have the same check # with different people paid to. It just lists the first in the column.

96gtsmoker2
09-15-2008, 12:36 PM
I have stumped the VBA Gurus. YEA ME. :)