Change formula to reference different external worksheets
Thu, 17 Apr 2008 15:36:40 GMT
Hi,
I have a master spreadsheet that has several sheets. Each sheet is reading
data from a separate external spreadsheet C:\Data using the below formula.
IF($AH5="","",IF('C:\Data\[Generic.xls]sheetTFF'!$A5="",A4,'C:\Data\[Generic.
xls]sheetTFF'!A5))
On each new sheet I want to recreate the above formula b ...
|
SEO Strategies
Tue, 15 Apr 2008 20:26:28 -0700 (PDT)
Is there anyone out there using any great SEO systems or programs to
help them increase their traffic and rankings in the search engines?
Please share...I will share the SEO program that I have been using
with very positive results. It is a 90-Day SEO coaching program by
Nancy Andrews called Live SEO Blueprint. ...
|
Hyperlinks
Tue, 8 Apr 2008 13:25:14 +1000
I have a spreadsheet which contains over 1,000 hyperlinks to a website.
Many don't work because they are missing two semi-colons.
Is there a quick way to check which ones have the missing semi-colons and to
insert them. There are two places in the hyperlink where they should
occur - always before &version ...
|
Selecting a cell depending on the other cell's value, kind of
Tue, 1 Apr 2008 21:45:00 +0100
Hi!
I have a table (4x4). It looks something like
A1 = x B1 = 40 C1 = 0.5
A2 = "" B2 = 50 C2 = 0.7
A3 = "" B3 = 60 C3 = 0.9
A4 = 1
A4 gets calculated by looking at which of A1 to A3 that has a "x" in
it. As you can se here, A1 has a "x" in it, thereby A4 gets the value
1.
Now, in D1 I want to do som ...
|
Link to Second Workbook Not Working
Tue, 01 Apr 2008 02:53:04 GMT
Well, I have a problem.
My open workbook is Named "One.xls"
My closed workbook is Named "ClosedBook.xls"
This "ClosedBook" is located as indicated in my code:
Here is my code:
='C:\extrafiles\SecondaryLevel[BofACheckRegister.xls]Payable'!CurrentBal
Can someone tell me what I am doi ...
|
Changing External Data Location
Sun, 30 Mar 2008 07:54:44 -0400
I have a fairly complex workbook that I used on a regular basis. The
first thing it does is get a data extraction from an ACCESS database
that is located on a different computer over the LAN using MSQuery.
Recently, my IT department swapped out the computer that stored the
ACCESS database with a different ...
|
Linked cell returns a 0 where there is no text (sometimes)
Wed, 26 Mar 2008 16:43:40 GMT
The contents of cell P10 on sheet("Issues") in T:\Storage\1.Reporting\DB\RAID
logs\RAID log.xls is empty.
The contenst of cell P8 on sheet("Issues") in T:\Storage\1.Reporting\DB\RAID
log.xls reads "='T:\Storage\1.Reporting\DB\RAID log\[RAID Log.xls]Issues'!
P10",
but is returning a value of 0. The contents of ...
|
|
|
Dont read
Tue, 25 Mar 2008 11:58:09 +0100
Vendo coche de segunda mano, Seat ibiza, a? 2001 km
35000, Solo por 4500 euros.
[URL=http://www.anunciosgratis.de]Anuncios Gratis[/URL]
www.AnunciosGratis.de http://www.AnunciosGratis.de Anuncios
Gratis. ...
|
Need to transfer sheet + pictures to multiple computers
Wed, 19 Mar 2008 21:02:08 +0000
I am looking for a way to easily transfer worksheet + pictures to
several computers. I have the pics hyperlinked to "My Pictures" on my
computer. How can I save them so that I will be able to load the
worksheet on multiple computers without breaking the link? I have not
ladded many pics yet so I could start over if ...
|
How to make the Embedded Excel file link to the table of Access
Tue, 18 Mar 2008 00:00:02 -0700
i embedded an Excel file into a Form of Access database, and then added a
PivotTable in that Excel file, so how to make the PivotTable directly link to
the table of that Access database? ...
|
