• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamically update cell based on data from another cell

D

dhwanilmalji

New Member
Hi there, I have created a spreadsheet for 5 employees with the following headings:


Account# Name Email Address Comments


What I would like to achieve is every time an employee adds data to their spreadsheet, it should automatically add the same data to the master spreadsheet under their worksheet name. That way I do not have to manually copy data from each employee spreadsheet and paste it to the master spreadsheet every time new data is added/updated.
 
Hi, dhwanilmalji!

Your explanation doesn't include detailed information of workbook/s structure and worksheet data. Could you please upload a sample of the files involved?

Regards!
 
Hello SirJB7, thanks for checking/responding to my questions


Here is the detailed information.


EmployeeA workbook has the following columns


Account# Name Email Comments


EmployeeB workbook has the following columns


Account# Name Email Comments


Master workbook has the following columns within each employee worksheet


Account# Name Email Comments


I hope this helps
 
Hi, dhwanilmalji!

A few things more:

a) employees just add information in their workbooks, or the edit and delete too, or do the sort it too?

b) how that operations should be reflected in your master workbook?

c) what if more than one employee add the same account/name/mail information?

d) aren't you registering in your master workbook which employee originated the data?

e) idem d) for date & time data origination/updating (and what about previous in master if deleted in employee?

f) are all fields (account, name, email, comments) mandatory?

Regards!
 
a) employees just add information in their workbooks, or the edit and delete too, or do the sort it too?

Answer: They just add information in their own workbook


b) how that operations should be reflected in your master workbook?

Answer: What they enter in their workbook should reflect in the Master Workbook under their Sheet Name


c) what if more than one employee add the same account/name/mail information?

Answer: This will not happen and even if it does that they would enter that information in their own workbook and then reflected under their sheet name in the Master Workbook


d) aren't you registering in your master workbook which employee originated the data?

Answer: Yes, the Master Workbook has same columns under each sheet (unique sheet labeled for each employee)as each employees workbook


e) idem d) for date & time data origination/updating (and what about previous in master if deleted in employee?

Answer: Employees will not be deleting any entries in their workbook. Just adding new entries


f) are all fields (account, name, email, comments) mandatory?

Answer: Yes


Thanks again for taking time to answer my question
 
Hi Tarun, Dhwanilmalji,


I too have couple of questions:


1. Are all these individual workbooks in some shared drive?

2. in same folder or different folders?

3. Only employees this files or include other unrelated files?

4. or each will have workbook at their respective workstation and local drive?

5. Will they keep changing the file name and location or it will be same?


Based on your information.


You may have to write macro in your master file to have loop for each file in the said folder and open them in readonly mode and copy the data and paste in respective sheet of master file.


Regards,

Prasad DN
 
Hi, dhwanilmalji!


Before reading prasaddn's reasonable questions I was assuming that answers to 1&2 were yes, and for 4&5 were no, and I didn't understand 3.


If my assumptions were correct, I thought on two possible models:

a) your master workbook will be always opened and in shared mode in order to get on-line updating triggering events at each employee workbook whenever he fullfilled a row from A:D columns

b) a second less interactive model is what prasaddn describes: move the supervision to your master workbook and take the info from each employee workbook, and perform the update or data retrieval on a manual basis (button) or on a programmed basis (timer, time, day, ...)


Define the model you'd like considering pros & cons of each one, and let us know because the implementation is rather opposite, and nobody wants to do things twice if can be done once.


So, please answer the 5 points and add any other information you think that might help us understand better the issue.


Regards!
 
SirJB7 said:
Hi, dhwanilmalji!


Before reading prasaddn's reasonable questions I was assuming that answers to 1&2 were yes, and for 4&5 were no, and I didn't understand 3.


If my assumptions were correct, I thought on two possible models:

a) your master workbook will be always opened and in shared mode in order to get on-line updating triggering events at each employee workbook whenever he fullfilled a row from A:D columns

b) a second less interactive model is what prasaddn describes: move the supervision to your master workbook and take the info from each employee workbook, and perform the update or data retrieval on a manual basis (button) or on a programmed basis (timer, time, day, ...)


Define the model you'd like considering pros & cons of each one, and let us know because the implementation is rather opposite, and nobody wants to do things twice if can be done once.


So, please answer the 5 points and add any other information you think that might help us understand better the issue.


Regards!
Click to expand...


Hi, dhwanilmalji! and SIRJB7,
I have exacly the same situation of dhwanilmalji! i work under excel 2007 and please could you tell me what is the answer of the problem of dhwanilmalji!
 
@Mario Lafleur
Hi!

Would you please start a new topic instead of writing on another user's one? It might be seen as hijacking. More indeed when it's such and old topic. If needed you could add a reference in your new one.

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you.

Regards!

PS: Please don't answer here at this thread.
 
You must log in or register to reply here.
Back
Top