Looking for a tutorial for data entry

[allieanne]

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.

 

[dmt32]

Hi,
here is one site https://www.contextures.com/xlForm02.html

Takes you through creating data entry sheet that saves data to another sheet & you can download sample workbook for free

Dave