Integrating Microsoft Forms with Excel auto data update

MrDrock

New Member
Joined
Oct 3, 2022
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Good Morning,

I'm trying to integrate Microsoft Forms with Excel for an easy to use data entry that can be used on mobile as well. I understand that forms is a survey / exam tool but I'm trying to "IKEA hack" it to be an easy user friendly data entry portal. The user enters data through a form and then the data is populated in an excel table. I want the excel table to automatically update if there was a duplicate entered say a couple weeks or months later using the same "unique ID". Can this be done with coding in VBA?

Green "J" column = My "Unique ID"
Yellow highlight = new entry with same unique ID as the last entry ( but i want it to replace "OLD" entry with new updated data automatically )
 

Attachments

  • Screenshot 2022-10-03 112239.jpg
    Screenshot 2022-10-03 112239.jpg
    81 KB · Views: 8

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top