Change Excel hyperlinks from absolute to relative
Sat, 11 Oct 2008 06:03:01 -0700
I have a folder containing about 2000 wav files and a workbook containing
hyperlinks to these wav files. I backed up this folder several times
without problems, but suddenly managed to change the references. Instead of
the target address showing TY25-08.wav it shows
../../../../Application%20Data/Microsof ...
|
Creating xla file to clear junk and sort reqd data
Sat, 11 Oct 2008 03:43:00 -0700 (PDT)
Hello.
I am doing a manual task everyday to remove columns which are not
required and sort required columns after seggregating alphabets from
number. I am seeking help to create an .xla file (Addin) which can
allow me to do this task in one shortcut key (CTRL+ALT+G)
My data is as follows A1:F13
Junk1 Cod ...
|
PivotTable - multiple sources
Sat, 11 Oct 2008 11:22:47 +0200
Hi
There is a possibility in excel to add a pivot table for that from multiple
sources. At one stage, when setting the pivot table with a wizard, there is
a listbox with all the sources. I need to somehow get the items from that
list?
How can I do that?
Kind regards
Igor M.
...
|
Use worksheet as database
Sat, 11 Oct 2008 02:15:44 -0700
Hi
I hsve a workbook that I use as database. The problem I have is then I
want to search for a date. In SQL question I need a dot (.) istead of a
(,)so I need to convert 39454,9166666667 to 39454.9166666667
Is this possible or can I solve this problem in another way?
Thanks in advace
*** Sent vi ...
|
How to find difference in cell contents visibaly looking same
Fri, 10 Oct 2008 21:48:11 -0700 (PDT)
I have two cells in different sheets which looks like contents are
same.
But excel thinks that the contents are different coz it giving error
in vlookup, arrey, if formulas.
I have tried to trim the same but of no use.
If I type the content ALPHAGEO, then i get the results but otherwise
only errors.
I tried ...
|
Adding hours
Fri, 10 Oct 2008 20:27:00 -0700
All,
I'm trying to add hours per week B2:G2 but i cannot make it work please
help. I have this formula to add the hours daily. the formula needs to return
hours worked in the same format
=+IF(+(B3-B2)*24<0,-(B3-B2)*24,+(B3-B2)*24)+IF(+(B5-B4)*24<0,-(B5-B4)*24,+(B5-B4)*24)
--
Regards
YM
...
|
RE: VB script
Fri, 10 Oct 2008 17:39:52 -0700
Hi Joel,
Thanks for the advice. I did what you stated but I was unable to add a
formula
that stuck. Everytime I added a formula, the formula works but as soon
as I click
on the Checkbox, then the formula gets erased and a True/False variable
appears in the cell. Any suggestions?
Best,
Archie
...
|
|
|
Comparing a list of Records
Fri, 10 Oct 2008 16:11:08 -0700
I need assistance comparing a list of records. Within my file, there are
records with multiple records. I want to perform the following If
statements. But, I don't know how to arrange it in Excel or Access.
If all the items in a field (column) begin with CR,
then variable = "HQ"
If all the items in a ...
|
Excel as a Game Design tool
Fri, 10 Oct 2008 15:13:21 -0700 (PDT)
I have heard that "Excel is to game designers what Microsoft Visual
Studio is to programmers" -- and as a relative newbie, I'd like to
learn howso.
One common thing in game design is branching and recombining plots (or
story elements). I can break up the plot into least-units, and put
each unit in a cell. But ...
|
Merging rows
Fri, 10 Oct 2008 13:58:01 -0700
I am trying to find a way to merge rows based upon a value in column A:
For example:
A1 = Jake-----B1 (Blank)-------C1 "Orange"--------D1 (Blank)
A2 = Jake-----B2 "Apple"------C2 "Blank"-----------D1 (Blank)
A3 = Jake-----B3 (Blank)-------c3 "Blank"-----------D1 "Banana"
I would like the end result to be:
...
|
