ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel workbook (https://www.excelbanter.com/excel-worksheet-functions/18190-excel-workbook.html)

JdeValk

Excel workbook
 
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.

Max

Perhaps, just as a start, try browsing
these 2 posts for some ideas:
a. http://tinyurl.com/5pbhy
b. http://tinyurl.com/573nl

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"JdeValk" wrote in message
...
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.





All times are GMT +1. The time now is 04:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com