Linking cells in different spreadsheets

I want to link a number of cells from different spreadsheets into one main
stock control spreadsheet and I've no idea how. Any suggestions?

ie Stock control = 200

Order Number 50

therefore stock control should decrease to 150.

Many thanks in advance

Not sure that we have enough info, but here is a starter

='Stock Control'!A1-'Order Number'!A1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sheilad" <Sheilad@discussions.microsoft.com> wrote in message
news:CB944E8A-74BF-41B6-A077-C996AEE57921@microsoft.com...
> I want to link a number of cells from different spreadsheets into one main
> stock control spreadsheet and I've no idea how. Any suggestions?
>
> ie Stock control = 200
>
> Order Number 50
>
> therefore stock control should decrease to 150.
>
> Many thanks in advance

Easy!
Click on the cell where you want the linked data.
Key in the equal sign: =
Navigate to the cell you wish link
Press enter

If you are linking to a cell in another workbook the cell will look
something like this
='[Workbook Name.xls]Tab Name'!$E$16

Where $E$16 is the cell location

Note that the cell location is an absolute reference so if you want to
extend the selection by dragging the cell you must first remove the absolute
reference.

If you are linking to a cell in the same workbook the cell will look
something like this

=Tab Name!Cell E16

Note that the cell location is not an absolute reference

HTH

Steve




"Sheilad" <Sheilad@discussions.microsoft.com> wrote in message
news:CB944E8A-74BF-41B6-A077-C996AEE57921@microsoft.com...
>I want to link a number of cells from different spreadsheets into one main
> stock control spreadsheet and I've no idea how. Any suggestions?
>
> ie Stock control = 200
>
> Order Number 50
>
> therefore stock control should decrease to 150.
>
> Many thanks in advance

Hi thanks for this, nearly there I think.

That will give me the value, but when I change the number ordered it doesn't
automatically update, can thoughts?

Many thanks.

"Bob Phillips" wrote:

> Not sure that we have enough info, but here is a starter
>
> ='Stock Control'!A1-'Order Number'!A1
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Sheilad" <Sheilad@discussions.microsoft.com> wrote in message
> news:CB944E8A-74BF-41B6-A077-C996AEE57921@microsoft.com...
> > I want to link a number of cells from different spreadsheets into one main
> > stock control spreadsheet and I've no idea how. Any suggestions?
> >
> > ie Stock control = 200
> >
> > Order Number 50
> >
> > therefore stock control should decrease to 150.
> >
> > Many thanks in advance
>
>
>

Thanks Steve, that is exactly what I wanted to do, your a star!!

"SteveH" wrote:

> Easy!
> Click on the cell where you want the linked data.
> Key in the equal sign: =
> Navigate to the cell you wish link
> Press enter
>
> If you are linking to a cell in another workbook the cell will look
> something like this
> ='[Workbook Name.xls]Tab Name'!$E$16
>
> Where $E$16 is the cell location
>
> Note that the cell location is an absolute reference so if you want to
> extend the selection by dragging the cell you must first remove the absolute
> reference.
>
> If you are linking to a cell in the same workbook the cell will look
> something like this
>
> =Tab Name!Cell E16
>
> Note that the cell location is not an absolute reference
>
> HTH
>
> Steve
>
>
>
>
> "Sheilad" <Sheilad@discussions.microsoft.com> wrote in message
> news:CB944E8A-74BF-41B6-A077-C996AEE57921@microsoft.com...
> >I want to link a number of cells from different spreadsheets into one main
> > stock control spreadsheet and I've no idea how. Any suggestions?
> >
> > ie Stock control = 200
> >
> > Order Number 50
> >
> > therefore stock control should decrease to 150.
> >
> > Many thanks in advance
>
>
>

It should unless you have manual calculation set
(Tools>Options>Calculation).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sheilad" <Sheilad@discussions.microsoft.com> wrote in message
news:48519D8C-B2C8-4AAE-92B3-E85574FB6973@microsoft.com...
> Hi thanks for this, nearly there I think.
>
> That will give me the value, but when I change the number ordered it
doesn't
> automatically update, can thoughts?
>
> Many thanks.
>
> "Bob Phillips" wrote:
>
> > Not sure that we have enough info, but here is a starter
> >
> > ='Stock Control'!A1-'Order Number'!A1
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Sheilad" <Sheilad@discussions.microsoft.com> wrote in message
> > news:CB944E8A-74BF-41B6-A077-C996AEE57921@microsoft.com...
> > > I want to link a number of cells from different spreadsheets into one
main
> > > stock control spreadsheet and I've no idea how. Any suggestions?
> > >
> > > ie Stock control = 200
> > >
> > > Order Number 50
> > >
> > > therefore stock control should decrease to 150.
> > >
> > > Many thanks in advance
> >
> >
> >