![]() |
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. |
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