Looking for a tutorial for data entry

allieanne

New Member
Joined
Jan 19, 2009
Messages
12
I want to create a data entry form on sheet1, and then have the information saved to sheet2. I do not want to use the built in Excel forms.

The data entry needs to have vlookups that pull in a description, which then needs to be modified and the modification saved off (not the original description)

Anyways, I'm looking for some examples/tutorials on how to do that save from sheet1 to sheet2. The information from 1 will be saved in rows on sheet2.

I'm just not googling the right terms as most comes up with the Excel forms

I'm not great with VBA at all, I can manage simple macros.
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,099,548
Messages
5,469,355
Members
406,647
Latest member
ssinovec

This Week's Hot Topics

Top