D
Don
hey everybody i have a question regarding a function
command in excel
i am using multiple worksheets in one file, the first
sheet is used to record all information eg, tel fax,
contact....etc... linking that information to the correct
cell on the following sheets is easy, a simple equal
statement.
here's the question i am also e-mail addresses, to see
them is no different then an equals command again, but to
you use them as a hyperlink so i can e-mail the page to
clients is different because the value in the cell on
remaining sheets is actually a formula, how can i copy the
value on the summary sheet to each sheet without using a
copy/paste pulldown function or crtl C / crtl V, i want it
to automatically update all the sheets as i enter the
information ?? e-mail me if you have an answer.
regards,
Don Poirier
Project Coordinator
Cressey Development Corporation
command in excel
i am using multiple worksheets in one file, the first
sheet is used to record all information eg, tel fax,
contact....etc... linking that information to the correct
cell on the following sheets is easy, a simple equal
statement.
here's the question i am also e-mail addresses, to see
them is no different then an equals command again, but to
you use them as a hyperlink so i can e-mail the page to
clients is different because the value in the cell on
remaining sheets is actually a formula, how can i copy the
value on the summary sheet to each sheet without using a
copy/paste pulldown function or crtl C / crtl V, i want it
to automatically update all the sheets as i enter the
information ?? e-mail me if you have an answer.
regards,
Don Poirier
Project Coordinator
Cressey Development Corporation