nathan2314
06-18-2008, 05:46 AM
:hi:Hi all,
I've built a spreadsheet object using forms in excel that will pop up when a user clicks a button in the regular excel spreadsheet. When the user clicks the button the spreadsheet object, named spreadsheet1, pops up and pulls in data from a normal excel spreadsheet, named 'RFF Data'. I've been able to make this work so far. Now I need to be able to have the user manipulate/update the data in spreadsheet1, the spreadsheet object created using forms, and then those changes be captured back into the RFF Data spreadsheet so that the next time a user clicks the button, spreadsheet1 will pop up with the updated/changed data. I haven't figured out to link data from the spreadsheet object, spreadsheet1, into 'RFF Data'. Does anyone know how.
Appreciate any help!:yes
I've built a spreadsheet object using forms in excel that will pop up when a user clicks a button in the regular excel spreadsheet. When the user clicks the button the spreadsheet object, named spreadsheet1, pops up and pulls in data from a normal excel spreadsheet, named 'RFF Data'. I've been able to make this work so far. Now I need to be able to have the user manipulate/update the data in spreadsheet1, the spreadsheet object created using forms, and then those changes be captured back into the RFF Data spreadsheet so that the next time a user clicks the button, spreadsheet1 will pop up with the updated/changed data. I haven't figured out to link data from the spreadsheet object, spreadsheet1, into 'RFF Data'. Does anyone know how.
Appreciate any help!:yes