• 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

Z

Zeuse

New Member
Hello,
I have a master file and 3 employee files.

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.

Where I should start.... thanks for your help
 
Hi, Mario Lafleur!

For those who haven't read it, it's the same issue as this:
http://forum.chandoo.org/threads/dy...ed-on-data-from-another-cell.3838/#post-19780
which was discontinued by the OP.

Could you please confirm or correct what was stated there regarding workbook/worksheet structure? Spreadsheets are in the same workbook, in separate ones, which are they columns, how is data entered on employee's worksheet/workbook...

Consider uploading (a) sample file(s) (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!
 
SirJB7 said:
Hi, Mario Lafleur!

For those who haven't read it, it's the same issue as this:
http://forum.chandoo.org/threads/dy...ed-on-data-from-another-cell.3838/#post-19780
which was discontinued by the OP.

Could you please confirm or correct what was stated there regarding workbook/worksheet structure? Spreadsheets are in the same workbook, in separate ones, which are they columns, how is data entered on employee's worksheet/workbook...

Consider uploading (a) sample file(s) (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!
Click to expand...


Hello,


Could you please confirm or correct what was stated there regarding workbook/worksheet structure? Spreadsheets are in the same workbook, in separate ones, which are they columns, how is data entered on employee's worksheet/workbook...

If for you worksheet/work book is a Excel file the answer is Yes, I have created a Excel file "master file" and on the first colum is the name of the employe and the second column is the requisition # and the 3 column is the amount of this requisition. I have created a second Excel File (workbook/worksheet) and I have called "Employe 1" with the same colums except the first column is the requisition# and the second column is the amount of this requisition, I did the same thing for the Employe 2. I want when I open master file than I can update the data in master file entered in Excel File (employes 1 and 2). Thanks
 
Mario Lafleur said:
Hello,


Could you please confirm or correct what was stated there regarding workbook/worksheet structure? Spreadsheets are in the same workbook, in separate ones, which are they columns, how is data entered on employee's worksheet/workbook...

If for you worksheet/work book is a Excel file the answer is Yes, I have created a Excel file "master file" and on the first colum is the name of the employe and the second column is the requisition # and the 3 column is the amount of this requisition. I have created a second Excel File (workbook/worksheet) and I have called "Employe 1" with the same colums except the first column is the requisition# and the second column is the amount of this requisition, I did the same thing for the Employe 2. I want when I open master file than I can update the data in master file entered in Excel File (employes 1 and 2). Thanks
Click to expand...


Just to be clear all excel file is workbook with only one sheet inside
 
Hi ,

It would be better if all of the data is in one Excel file ( workbook ) , with individual worksheets labelled Master , Employee 1 , Employee 2 , ... ; this way keeping a backup involves backing up just one file. If you have individual workbooks , then a backup will mean you need to backup several files.

Secondly , any procedure which needs to open and save disk files will take much longer than a procedure which needs to handle just one disk file.

Excel can easily handle even 100 worksheets in one workbook ; unless you have a compelling reason to have separate files , please consider this option.

Narayan
 
I am not sure what is the issue in this question? If the master sheet is on master computer, and employee sheet is on employee computer- it is difficult and many things that can go wrong.
Why don`t do it easy, share the sheet on dropbox, that way everyone can use the same sheet and everyone has the same copy on their own computer. Everyone needs to download the sheet to his own dropbox, don`t just open the link you share. It is a tricky differense there. (dropbox and sharing is one of many excellent options for this).
Of course, if you have secrets, you will need another solution.
 
The master files will be on the share drive in the folder Requisition and the other excel WorkBook files will be at the same place. Each employe will have a password for their file and the master file will be protected by a password. I dont want than employees can see what others employee have in their file
 
Or, open "Mastersheet" and "Employee 1 sheet". Goto Employee 1 tab in master sheet, click a cell, type = and then goto "Employee 1 sheet" and click the cell you want to copy.
It will work as long as the sheet is saved in the same folder.
If u do this in cell a1, and open the formula- remove the two $, then u can drag the formula to work where u like.
 
You must log in or register to reply here.
Back
Top