#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
User Specific excel problem when opening a excel worksheet SJMP Setting up and Configuration of Excel 3 January 16th 08 09:46 AM
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file BrianL_SF Excel Discussion (Misc queries) 2 October 10th 06 08:27 PM
Started out as an Access problem. Now an Excel problem RobertM Excel Discussion (Misc queries) 2 April 26th 06 07:30 PM
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . P.S.Sodha Excel Discussion (Misc queries) 0 April 2nd 05 01:53 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 08:05 PM


All times are GMT +1. The time now is 01:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"