From: Timothy on
I am trying to develop a GUI, which will allows me to query and import data from a master spreadsheet for data, but would like the option to be able to add data from another excel file into the master via my GUI. Currently, I would like the data to be added to the end of the current data in the sheet, without adding sheets for each additional file (inputted matrix) saved to the excel file. The data I am using for the rest of my application is a living, growing data set, but added few times a week as another excel spreadsheet. Currently my only option is to open both spreadsheets and manually copy the data to the master. Does anyone have a way to accomplish this ?