Userform to edit data

[randolphoralph]

I have a userform that I have created to enter new part information to a spreadsheet but I am wanting to also use the userform to edit exsisting part information.

My spreadsheet consist of part #, name of part, description of part, date manufactured, and date sold (Column A-E)

My question is can a userform be used to edit information that is already present on the spreadsheet?

I am looking to edit any entries that do not have a date in the date sold field.

[rylo]

Hi

Short answer: yes. Need a fair bit more detail to do some code, but if the part number is unique, then you could bring up the existing data for that part number, then repaste the updated data.

rylo

[Dave69rock]

This can be done in many ways if you post a sample of your workbook it will help others to give you a quick solution to suit your needs.

Dave

[randolphoralph]

Thanks! I ended up finding J-Walk Enhanced Data Form v3 add-in which did the trick