Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have input boxes that take user input. I have a macro that sends that input to the next blank row in a specified excel document and then reloads the app to show the data that was saved in that excel sheet.
I have a chart that reads the data from the excel. I would like to be able to modify the record that the user clicks on, and save it to the excel document thus overwriting the previous values.
Would anyone have any clues on how to do this?
I thought about making an autonumber field and somehow referencing that as a key of sorts...not sure.
Would Dynamic Update work?
Any bites?