ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Setting up a form to input into selected worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/33132-setting-up-form-input-into-selected-worksheet.html)

Bob

Setting up a form to input into selected worksheet
 
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


All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com