Update a table with data fed to an input form

[RASIKA_99]

Friends,

I have a data input form in excel. Copies of this file has given to 50 Classes and they update it daily and send to Head Office in the evening.

Firstly, I want to enter these data in to a table in the same individual excel file before sending to Head Office (In a new sheet).

At the end of the day, I want all the data collected by all classes to include into a central database.

Can you guys help me?

[maniacb]

It is conceivable to create code that will save the input form into a hidden /alternate sheet, for that one excel file. But you have up to fifty excel files, from which you want to presumably collect data and consolidate it into a central database.

1)One way is to create a single collection data form and then aggregate and collect all forms into a single dated directory, then run some aggregating vba code in that directory to compile a full database of all the submitted forms. Is this what you are thinking to do?

2)It is also conceivable to create a shared data form on a shared network drive where each data form has access to a separate master file, such that, when a user submits/saves their one form, data is populated into the master form. Are all your users set up with a common network drive to support this second architecture?

I am sure there are other architecture approaches, but answering these questions will help with focusing on a solution.

[maniacb]

I updated the sheet to populate the second sheet with data as per your instructions. This will at least be a beginning point for further discussions.

Here is the code used:

Please Login or Register  to view this content.