Hi guys, im new to userforms, and wanted to know if i can create a userform which lets the user select a file, and make edits in it right through the userform. here's the scenario. I have a folder at work with a bunch of the same files, with only little differences (that's how work wants it, very annoying) i have a different spreadsheet for each app. Whenever we get an update, and lets say data for 5 apps change (like the owner). then I have to go open each corresponding spreadsheet and change the cell value with the new data.
it gets kind of tedious with 5 or 6, however my issue is now they have started updating 20-30 apps at a time, and takes me a long time (almost a good chunk of my day) just to change one thing.
i wanted to know if such a thing would be possible, and if so, how do i go about it?
a userform which either lets me choose a file, or has a drop down of all the files within a folder, and then i can make my change in the userform instead of the spreadsheet itself.
I'm at a loss, and would appreciate any help.
thanks in advance.
it gets kind of tedious with 5 or 6, however my issue is now they have started updating 20-30 apps at a time, and takes me a long time (almost a good chunk of my day) just to change one thing.
i wanted to know if such a thing would be possible, and if so, how do i go about it?
a userform which either lets me choose a file, or has a drop down of all the files within a folder, and then i can make my change in the userform instead of the spreadsheet itself.
I'm at a loss, and would appreciate any help.
thanks in advance.
