This probably sounds confusing on what I need. I will try to explain a little
bit better. The first quarter my company buys accounts receivable and scores
them by risk. There are numerous fields that identify the criteria. To test
to see if we are scoring them correctly we would like to look back and see
why we made the decision to buy it and if it was a good decision. So in my
first sheet, as I said, if I
started with 5000 accounts after 8 quarters I still want to have 5000
accounts, regardless of whether they were paid off. So I can look at them and
see how we scored them. All information from column A-AK will never change,
columns AL-BA would have information, times past due- etc that would change
during the life of the account. (It's a pretty big file - which is one reason
I need the macro)The common field in every quarter (or sheet) would be the
note number, which I have in column B, starting in row 2 - which will be the
same column and row on every sheet . I want it to find this number and if
it is still on the newest sheet (or newest quarter) copy the data (from
AL-BA, or if there is a better way to see if something has changed??)and
carry the new information to the first sheet if not do nothing. So every
quarter I can download the newest quarter, run the macro and it would update
the account. Like I said something I am having trouble with is I have to make
sure if the original month started with 5000 accounts at the end of the 8th
quarter I still have to have 5000
accounts. Make sense??
Is this possible?