Normally I do everything in excel with vlookups and it statements, but I
think VBA may be the only way I can solve this problem.

I created an expense spreadsheet with an input page and a data sheet
for each month (June, July, etc.)

Basically the input page is 2 columns

Category 6/3/05
Food 5.75
Taxi 10
Clothes 35

From this I would like to be able to push a button and have the data be
copied to the June sheet, in the appropriate column (for the 3rd day)
and in the appropriate row.

June Sheet (there are columns for each day)

Category 3rd
Taxi 10
Clothes 35
Food 5.75

I have used VBA before, but I'm not sure how to tell it to go to a
sheet based on the value of a cell (date) and then search a range in
the sheet for the intersection of values (Taxi and 3) and then put the
data into that cell at the intersection.

Maybe this is too big of a problem to tackle, and if it is, please let
me know, if not, i would love to know how to start solving this.

Thanks in advance.


--
mitchell_um
------------------------------------------------------------------------
mitchell_um's Profile: http://www.excelforum.com/member.php...o&userid=24109
View this thread: http://www.excelforum.com/showthread...hreadid=377139