Hi all.

I have a userform which enters several entries on to two spreadsheets (dependant on a checkbox on the form)

If the entries are to be changed I wanted to use the same userform to replace the entries on the worksheet- What I need is VBA code to check the customer's account number is already present, then overwrite the entries on the worksheets thus replacing the original data. Is this possible? Im sure it is but I'm not sure how to do it. Any help greatfully accepted.

Ideally I would also like a way of users checking if an entry already exists on the worksheets. The workbook currently has a front sheet with a macro box to bring up the userform. The data sheets are hidden to stop the data being tempered with.

Is there a way that if the account number could be input on the front page and then the data could be retrieved and displayed on the front page? Also namechecking the name of the sheet

Any help on these two issues would really be great.

Many thanks in advance.