Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble with VBA data assignment
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation trouble | Excel Programming | |||
trouble ranking data... | Excel Discussion (Misc queries) | |||
Trouble with Macros Assignment- anyone willing to help? | Excel Programming | |||
Trouble with Macros Assignment- anyone willing to help? | Excel Programming | |||
Trouble with Macros Assignment- anyone willing to help? | Excel Programming |