I would like to have cells in wks1 update when I make a change on diffrent
cells in wks 2
I would like to have cells in wks1 update when I make a change on diffrent
cells in wks 2
Use a simple link to the wks2 worksheet.
='wks2'!A1
If the sheet name doesn't contain spaces, the apostrophes are not
necessary, but it is always safe to include them.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Andy" <[email protected]> wrote in message
news:[email protected]...
>I would like to have cells in wks1 update when I make a change
>on diffrent
> cells in wks 2
Use a simple link to the wks2 worksheet.
='wks2'!A1
If the sheet name doesn't contain spaces, the apostrophes are not
necessary, but it is always safe to include them.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Andy" <[email protected]> wrote in message
news:[email protected]...
>I would like to have cells in wks1 update when I make a change
>on diffrent
> cells in wks 2
Use a simple link to the wks2 worksheet.
='wks2'!A1
If the sheet name doesn't contain spaces, the apostrophes are not
necessary, but it is always safe to include them.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Andy" <[email protected]> wrote in message
news:[email protected]...
>I would like to have cells in wks1 update when I make a change
>on diffrent
> cells in wks 2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks