J
JdeValk
I am creating a mutisheet workbook within Excel. I want to make on of the
sheets within the workbook a cumulative sheet of all the others, a master
data sheet if you will. What I was wonder was if Excel has the capability of
automatically transferring data from one sheet to another. For instance, I
want to be able to write to sheet "A" (or any other sheet in my workbook) and
have the value automatically written to sheet "D" (which will be designated
as the "master". I know I could simply copy the data but I was wondering if
this is possible.
sheets within the workbook a cumulative sheet of all the others, a master
data sheet if you will. What I was wonder was if Excel has the capability of
automatically transferring data from one sheet to another. For instance, I
want to be able to write to sheet "A" (or any other sheet in my workbook) and
have the value automatically written to sheet "D" (which will be designated
as the "master". I know I could simply copy the data but I was wondering if
this is possible.