Hello ,
My boss asked me to write a macro so two of our departments can use , he asked me to:

-Add the values from every cell in worksheet 1 (document A) to the coresponing cells in worksheet 1 (document B) , in plain terms i have to copy the data from one document into the other via a macro
*in case one of the cells is missing the value it should be automaticly added from the first document
** If one document sheet(or cell) is to be modified the other cells in the second document automaticly change - like being linked togather

I have no programing background and I've only recently started learning the VBA tutorial , this seems complicated to me .
What I've managed to do so far is to read a number from e.g Sheet1.A1 and copy it to Sheet2.B1 (within THE SAME DOCUMENT/WORKSHEET)

PS: Both the documents are different in structure , the first one has concentrated data ( like the values from two cells in document B are in one cell in document A) , where the other has values seperatly
e.g pressure + temperature = one cell in worksheet 1 (document A) , document B has pressure = one cell , temperature = one cell

Hope i get some assistence , I'm sorry if i posted in the wrong (sub)forum

Best regards,