Small Data Base

**EMoe** · 05-23-2005, 06:00 PM

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

**Leith Ross** · 05-23-2005, 06:45 PM

Hello EMoe,

Here is a macro that will update all of the entries when the button is pushed. You will need to add a button to your worksheet and then copy and paste the code into the button's macro code section. If you don't know how to do this, I'll give you instructions to walk you through it.

This macro assumes your worksheets are named "Sheet1" and "Sheet2". The names on both worksheets start at "A1" . If you are using a range or name that is different than what is mentioned, the macro will need to be modified to work properly.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Small Data Base

LinkBack

Thread Tools

Rate This Thread

Display

Small Data Base

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions