can Excel work similar to Lotus?

[Lila]

I use Excel for Order entry and Tracking. Is there a way to set up the
worksheets so that when you enter information on one page, it automatically
fills in certain fields on another page? Sounds confusing but i would like to
know if it can work similar to Lotus.

Thank you.

[Chris Rogers]

you can easily like pages from one to another using the + key.

[Gord Dibben]

Lila

You can link cells from one sheet to another or even to another workbook.

Assume you enter data in Sheet1 A1 and want it to appear on Sheet2 at B34.

In Sheet2 B34 enter =Sheet1!A1

Alternate........

Enter an = sign in B34 then switch to Sheet1 and select A1 and <ENTER>

Another alternate.........

Select A1 and Copy it then switch to Sheet2 B34 and Paste Special>Paste Link


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 08:03:05 -0800, "Lila" <[email protected]>
wrote:

>I use Excel for Order entry and Tracking. Is there a way to set up the
>worksheets so that when you enter information on one page, it automatically
>fills in certain fields on another page? Sounds confusing but i would like to
>know if it can work similar to Lotus.
>
>Thank you.

[Lila]

do i have to link each cell individually?

"Gord Dibben" wrote:

> Lila
>
> You can link cells from one sheet to another or even to another workbook.
>
> Assume you enter data in Sheet1 A1 and want it to appear on Sheet2 at B34.
>
> In Sheet2 B34 enter =Sheet1!A1
>
> Alternate........
>
> Enter an = sign in B34 then switch to Sheet1 and select A1 and <ENTER>
>
> Another alternate.........
>
> Select A1 and Copy it then switch to Sheet2 B34 and Paste Special>Paste Link
>
>
> Gord Dibben Excel MVP
>
> On Thu, 24 Feb 2005 08:03:05 -0800, "Lila" <[email protected]>
> wrote:
>
> >I use Excel for Order entry and Tracking. Is there a way to set up the
> >worksheets so that when you enter information on one page, it automatically
> >fills in certain fields on another page? Sounds confusing but i would like to
> >know if it can work similar to Lotus.
> >
> >Thank you.
>
>

[Gord Dibben]

Depends.

If contiguous you can select a bunch and copy/paste special>paste link.

Also you can drag/copy =Sheet1!A1 down column A and you will get Sheet1!A2,
A3, A4 etc. incremented as normal drag/copy will give with relative
referencing.

Or drag/copy across a row or rows.

Gord

On Thu, 24 Feb 2005 13:29:01 -0800, "Lila" <[email protected]>
wrote:

>do i have to link each cell individually?
>
>"Gord Dibben" wrote:
>
>> Lila
>>
>> You can link cells from one sheet to another or even to another workbook.
>>
>> Assume you enter data in Sheet1 A1 and want it to appear on Sheet2 at B34.
>>
>> In Sheet2 B34 enter =Sheet1!A1
>>
>> Alternate........
>>
>> Enter an = sign in B34 then switch to Sheet1 and select A1 and <ENTER>
>>
>> Another alternate.........
>>
>> Select A1 and Copy it then switch to Sheet2 B34 and Paste Special>Paste Link
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Thu, 24 Feb 2005 08:03:05 -0800, "Lila" <[email protected]>
>> wrote:
>>
>> >I use Excel for Order entry and Tracking. Is there a way to set up the
>> >worksheets so that when you enter information on one page, it automatically
>> >fills in certain fields on another page? Sounds confusing but i would like to
>> >know if it can work similar to Lotus.
>> >
>> >Thank you.
>>
>>