Update Data using a Form in Excel - Idiot-Proof Excel - Part 7

Idiot-Proof Excel Series Part 7

Update data stored on another worksheet using a Form in Excel. This feature also works in conjunction with the Search feature we talked about in the last tutorial.

[SknEnjoi]

I find the way that you methodically explain each concept and line of code is exactly I need to be able to understand what's going on. This whole series is helping me to create an inventory system for my work. Thank you!

[AndrewSmith-vvvh]

Excellent - yet again. Nice, easy and methodical for those like me (in advancing years) who find Excel and its capabilities fascinating.

[behcetyaykc]

C'est un bon tuto . Merci Cher Maitre. Salut de la Turquie

[WJA]

Hello - The one issue I have is that the sourceSheet is password protected (per earlier videos) and will not input data from the datasheet unless I manually unprotect the sheet. Is there a work around for this? Thank-you...great series of videos!!

[maxvermeulen]

Is it possible to create a Dropdown for the cells in the form?

[nsanerydah]

@TeachExcel The last two videos have been great. Amazing videos and procces! I used your framework to build a digital audit surveillance system for use at work. The only hiccups I'm running into is the recordRow = Rng.Row cpnversion to nextRow = Rng.Row. In my case, when I update the "retrieved" entry, I can make the change and sumbit(using validation), but it does not overwrite the recalled entry. Instead, it makes a new entry on the "nextRow." I cannot seem to get it to replicate what you're saying it will do in my file. Is there anything specific that can be done or looked at with the code? I'm not quite understanding the use of nextRow instead of the record row function. Thank you for you assistance in this matter.

[jaredmacfarland]

I have to different forms that are dumping data into one sheet. Everything works except the update feature. When I update it it adds a new one instead

[jaimecarajunior]

The explanations are good overall, but very confusing with so much back and forward, gaps and problems with its continuity. In every following video there are things in the code that are different from the previous.

[Khabbazco]

I’ve done the same thing but it keeps adding a new record (it Doesn’t update the old record) any suggestion?

[hrmnpsrffn]

Mine just keep adding a new record instead of updating it. Why?

[enkay]

when I click submit..
new record is added! it Dosent update... any advise Pls?