[OT] Excel Question

Yahoo Archive
1
Not unusual to reference a closed sheet. However, depending on version,
your formulations may have to be made manually. For versions before excel
2003 you could not copy and paste a reverence like you show and have the
cell reference follow correctly. In Excel 2003 it appears to function like
you would expect, but I haven't looked closely at it. Here is an example of
a closed sheet reference that I use:

=VLOOKUP(B4,'\\Raiw2k\Apps\Customer_Specific_Data\Victaulic\[QUALITYverify.x
ls]QC verification'!$A$2:$V$80,6,FALSE)

When a user enters a product number it pulls material information.

Shirley Graver
Systems Administrator
Rubber Associates

_____

From: Keith Mailloux [mailto:keith.mailloux@...]
Sent: Wednesday, August 18, 2004 11:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] [OT] Excel Question

I am looking for some Excel guru advice. I create a cell reference from
inputs resulting in a string as follows: =+[Activ03.xls]Jan!B32
, which points to a workbook, sheet and cell. I want to display the
value of this reference in a separate sheet (a summary sheet). I can not
figure a way to make my string a legitimate cell reference to bring the
value into the cell. Why am I doing this you ask? Well the "03" portion
of the reference is a year value and there are hundreds of cells that
reference that year. I would like to change one cell from 03 to 04 and
have different values get the respective workbook cell references.



Not sure if this is clear or not. If anyone has a suggestion you can
contact me directly. Thanks





Keith Mailloux



Keith.mailloux@...



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129fri0nv/M=298184.5285298.6392945.3001176/D=gr
oups/S=1705007183:HM/EXP=1092928906/A=2164330/R=0/SIG=11eamf8g4/*http:/www.n
etflix.com/Default?mqso=60183350> click here


<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=
:HM/A=2164330/rand=229118270>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

Tracking #: C58FC0C6FE56AC4DBEAA65A42074FDF088CD3E45


[Non-text portions of this message have been removed]
2
My boss just got a new PC and he says excel is now acting differently than
on his old PC. He said on his old PC, whenever he typed text in a field,
the column width would automatically get larger or smaller depending on the
largest test typed in the column. Now, he has to adjust it himself. I do
not know of a setting that tells it to automatically adjust this- does
anyone know where this is - this would be an application-wide setting?
3
Sara,
Tell him to go to the FORMAT menu on and you'll format
columns the best you're going to get is FIT WIDTH TO SELECTION. So far
as I can tell there doesn't seem to be a way to default this function.
I would highly recommend that he download ASAP UTILITIES. An
outstanding FREE add on. Tons of useful functions. Just Google the
name.

Shirley

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]

Sent: Monday, January 05, 2004 1:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [OT] Excel Question

My boss just got a new PC and he says excel is now acting differently
than
on his old PC. He said on his old PC, whenever he typed text in a
field,
the column width would automatically get larger or smaller depending on
the
largest test typed in the column. Now, he has to adjust it himself. I
do
not know of a setting that tells it to automatically adjust this- does
anyone know where this is - this would be an application-wide setting?


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12c4nqa7n/M=267637.4116730.5333196.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1073413390/A=1853618/R=0/*http:/www.netflix.
com/Default?mqso=60178338&partid=4116730> click here


<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egrou
pmail/S=:HM/A=1853618/rand=925496095>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.

Tracking #: 7F96A07141DE9542A0B5F9F31C55D68CF5B493C0


[Non-text portions of this message have been removed]
4
I am looking for some Excel guru advice. I create a cell reference from
inputs resulting in a string as follows: =+[Activ03.xls]Jan!B32
, which points to a workbook, sheet and cell. I want to display the
value of this reference in a separate sheet (a summary sheet). I can not
figure a way to make my string a legitimate cell reference to bring the
value into the cell. Why am I doing this you ask? Well the "03" portion
of the reference is a year value and there are hundreds of cells that
reference that year. I would like to change one cell from 03 to 04 and
have different values get the respective workbook cell references.



Not sure if this is clear or not. If anyone has a suggestion you can
contact me directly. Thanks





Keith Mailloux



Keith.mailloux@...



[Non-text portions of this message have been removed]