data entry problems?????

tiuser

New Member
Joined
Dec 7, 2007
Messages
15
I am having some trouble here. I have searched the forums and have not found a solution.

Here is what I have and what I need to do. Cell A1:A8 are constants (never change) B1:B8 is where the data is entered (always changes). I need to save the data to a chart (in the same sheet) in the column designated for that employee.

What I was trying to do is have the data entry clerk enter the appropriate data, then hit a macro "button" that saves the data to the appropriate place in the chart. Then she can enter the next employee's data and so on.

My problem is I am not experienced with VBA code. I was trying to accomplish this with a macro in excel or excel formulas. However, I am open too all help available. Please help.

CONSTANTS ENTERED DATA
A1: Name B1: John Doe
A2: addl ot B2: 5/12/08
A3: addl ot B3: 5/14/08
A4: addl ot B4:
A5: addl ot B5:
A6: sick B6:
A7: prsnl B7: 1
A8: vac B8:


Thanks
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
Hi,

Excel has a built in function that will create an automatic form for you to add info into a data table.

If you set your data table up with the headings across the columns in a worksheet and then select Data...Form... it should sort it out for you.

Other than that you're looking at a VBA solution, probably using a userform.

Dom
 

Watch MrExcel Video

Forum statistics

Threads
1,130,330
Messages
5,641,547
Members
417,220
Latest member
lam150498

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top