I am sure this is kinda simple but haven't messed around with it since the
late 90's so here it goes. I have a workbook with about 40 different sheets
each sheet has its basically for accounting issues each sheet has a about
1500 rows prefilled in with every date for a year on each row I have 5
withdraw columns and a deposit column and a running balance column. what I
need to do is create a form on the first worksheet that will give you a list
box of all the worksheets and then another field that will let you input the
date and 2 more boxes one for withdraws and 1 for deposits and when you are
done it goes to the correct date and inputs the information in the correct
field. Plus since they can have more than 1 withdraw for that day to move to
the next available column and fill it in. Thank you in advance
Bob.
Feel free to email me with guidance at