Hi, hope everyone is well
can someone perhaps tell me if it is possible to have a workbook on my pc that has certain information on that will be changing quite often and a workbook on say my managers pc that dont look anything like my workbook but there are only certain cells that needs to update on my managers workbook.
the file on my managers pc will have a persons name for instance which i will also have on my file, the person will have certain information updated throughout the month on my side, so whenever my manager opens the file on his side, it must update the persons details from my pc. we are all on the same network btw .
i have a feeling this can be done and that it was not even necessary to ask here but i cant find a solution to this
thanks in advance
can someone perhaps tell me if it is possible to have a workbook on my pc that has certain information on that will be changing quite often and a workbook on say my managers pc that dont look anything like my workbook but there are only certain cells that needs to update on my managers workbook.
the file on my managers pc will have a persons name for instance which i will also have on my file, the person will have certain information updated throughout the month on my side, so whenever my manager opens the file on his side, it must update the persons details from my pc. we are all on the same network btw .
i have a feeling this can be done and that it was not even necessary to ask here but i cant find a solution to this
thanks in advance