Link to home
Start Free TrialLog in
Avatar of acdecal
acdecal

asked on

Excel pop up form to enter data

I would like to create a data entry form to append or update a table.  See attached worksheet.  The user would click a button to pull up a form and enter the actual hours worked each week for each task.  When done the form would close and append or update the data in the table which feeds a pivot table.  Form should populate with task codes and descriptions.

Thanks in advance
Avatar of acdecal
acdecal

ASKER

Data table is on sheet 2.  This is just an example of a larger and more complex workbook.
Avatar of Glenn Ray
Please attach an example workbook.  :-)
Avatar of acdecal

ASKER

Sorry I forgot to attach workbook.  Any help on this please?
ASKER CERTIFIED SOLUTION
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of acdecal

ASKER

OK great!  I'll try to adapt this to my workbook.
Thanks.