ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Problem (https://www.excelbanter.com/excel-discussion-misc-queries/201325-excel-problem.html)

katrina

Excel Problem
 
I have a mater list that i have created and i have other sheets that follows.
on the other sheets i would like them to automacially updat the information
from the materlist as i go. How can i don that.

Pete_UK

Excel Problem
 
There are several ways, but you will have to give further details in
order to get an appropriate working solution.

Pete

On Sep 4, 4:46*pm, katrina wrote:
I have a mater list that i have created and i have other sheets that follows.
on the other sheets i would like them to automacially updat the information
from the materlist as i go. How can i don that.



dlw

Excel Problem
 
you can reference cells in other sheets by this format:
=sheet2!a1
that is the cell a1 in the sheet named sheet2


"katrina" wrote:

I have a mater list that i have created and i have other sheets that follows.
on the other sheets i would like them to automacially updat the information
from the materlist as i go. How can i don that.



All times are GMT +1. The time now is 04:54 AM.

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