Hello,

I want to create a data base that will keep up with financial records:
(I know Access may be better, but I want to try Excel since I like it so much, plus I don't have access).

On sheet 2 I have a list of names (let's say 20) in column A. I have dates going across the top row that's in 7 day increments. (Ex. 1/1/05, 1/8/05, 1/15/05...). These amounts are recorded every Sunday.

On sheet 1. I have a list of names and amounts beside them in the next cell.

Ex. Mark $75.00
Paul $50.00
Jane $110.00

How do I hit a transfer button, so that Excel looks at a name and the amount on sheet 1, then find that same name on sheet 2, and record the amount on the next date. I should come back next week, and it does the same thing for the next date. So on and so forth.

1/1/05 1/8/05 1/15/05
Jane $110.00
Mark $75.00
Paul $50.00

This might be a tuff one. I don't know if Vlookup or Hlookup is right for this or not.
Or maybe you have another suggestion!!!

Thanks,
EMoe