Auto filling separate sheets in a workbook

[Gabe]

I have an ivnentory workbook with several sheets. THe
main sheet has a list of six different categories and
there is a separate sheet for each category.

I would like the category sheets to auto-fill form the
main sheet in the book. Then if the status changes - from
for sale to sold, I would like the sheets to auto update
themselves.

Is this possible, and if so how in the world do I do it?

Thanks

 

[Gord Dibben]

Gabe

Check out "linking"(no quotes) in Help.

Basics......you have a source sheet and a target sheet.

On the target sheet type an = sign in a cell then switch to the source sheet,
select a cell and hit <ENTER>

In target sheet cell the formula =sourcesheet!cellref

Another method of linking is to copy a cell from the sources sheet, switch to
the target sheet, right-click a cell and Paste Special>Paste Link.

The linked cell will update when the source cell is changed.

Gord Dibben Excel MVP

 

[Guest]

Gord,

Thanks fo the tip

What I am really looking for is if cell c1 in worksheet 1
is "for sale" then I want all of line C to be copied to
the sheet named "For Sale".
If the status of C1 changes to "Sold" I want the data
removed from the "For Sale" sheet and put into the "Sold"
worksheet.

Gabe