Search file and within the file
I have several files in a folder most of them are CVs in word format, I want
to create a query or access program to get the subject with some criteria -
If I search for a particular Text, that should check and matching file name
and also inside the word file.
I tried google desktop search, coppernic search and even the MS Search - but
nothing helped in a way I want.
I appreciate your valuable time.
To develop a bespoke Access application will take much effort and involve
using Windows APIs. I suggest you don't want to do this.
Instead consider upgrad...Table Changes
Where is the documentation for the table changes for GP 9
It should be in the help menu.
> Where is the documentation for the table changes for GP 9
I have yet to install it.. I am trying to make sure that I have
everything covered do to the fact we have numerous outside apps that
talk to the backend of GP and want to prevent any possible headaches
> It should be in the help menu.
> "Brian" wrote:
>> Where is the documentation for the table changes for GP 9
What...What is the cell data reference for 5th row and 7th column called
Can someone help me with this question? I need to get the answer for my
homework. Thanks for your help.
I'm guessing, but might it be G5?
Please keep all correspondence within the NewsGroup, so all may benefit !
"Shyfirstname.lastname@example.org" <Shyemail@example.com@discussions.microsoft.com> wrote in
> Can someone help me with this question? I nee...Cell Contains Data.
How can I tell a cell that IF a cell contains data (numbers, text, whatever)
do x or y. How can I identify data?? I don't want to tell the function to
look for a specific number or text, just data, just something in the cell...
"GEM" <GEM@discussions.microsoft.com> wrote in message
> How can I tell a cell that IF a cell contains data (numbers, text,
> do x or y. How can I identify data?? I don't want to tell the function ...Active cell highlight
I would like to know if there was a way to have an active cell always in
yellow or any color.
Example: If the active cell is moved around, the active cell will be always
Thank you in advance
you may want to try Chip Pearson's Rowliner:
> I would like to know if there was a way to have an active cell always in
> yellow or any color.
> Example: If the active cell is moved around, the active cell will be always
> in yellow.
> Thank you in advance
Dave Pet...Need to separate multiple numbers in one cell
I have multiple number in one cell and i need to somehow put each number into one separate cell for each number:
I have :
row1 2 5 8 10
column B column C column D column E
row1 2 5 8 10
How do I do it on Excel 2007?
EggHeadCafe - Software Developer Portal of Choice
Map Stored Procedure Output To Class Properties
Use Data > Text to columns and specify the delimiter as space
...copy value in cell above to cell below for a whole column
I have a spreadsheet that was saved from a report. this report only lists
the employee name once. There is a way to copy the value of the cell above
to the cell below. I can get as far as highlighting the blank cells with the
Go To function, then I can not remember the steps to tell excel to copy the
data into the blank cells.
Can anyone help?
Ctrl+D will copydown the value of the top cell to the highlighted cells below.
> I have a spreadsheet that was saved from a report. this report only lists
> the employee name once. There is a way to copy th...How can I remove the previous lock cells and keep the new ones.
Could you please help me?... I locked and protected the cells A1:H20 in the
sheet 1 two months ago. However, yesterday I wanted to unlock and unprotect
these cells and locked and protected the cells A21:H40 instead. However, for
some reason the cells A1:H20 are still lock and protect.
How can I remove the previous lock cells (A1:H20) and keep the new cells
In EXCEL 2007 take the following actions to unlock cells A1 to H20:-
1. Home / Cells group / Format / Unprotect Sheet / enter the password to
Unprotect Sheet / OK / highlight cells A1 t...formulas changing when emailed
At work, I have created a spreadsheet that has links to workbooks in a
user drive..called the "U: drive."
When I transfer this excel project to others via email, I make sure
that the other workbooks also have the same name in their U: drive as
However, whenever I email it... I have to change many of the formulas
at their computers bc the references in my formulas change to a really
I have tried using "CNTL+H" to replace the "=" to a "+" but it doesn't
work for me bc I have "+" "=" elsewhere in my formulas....Adding data from multiple cell and linking to a new worksheet
I have data in a sheet with names and amounts due. Like
There is a second sheet named summary. I want the totals of each person to
appear in the summary sheet. These should be linked cells and any change in
data in sheet 1 should be updtaed automatically
Create a PivotTable
"Rashmi" <Rashmi@discussions.microsoft.com> wrote in message
>I have data in a sheet wi...Move cells down to match cells
A B C D E
1 000801025-8 009601025-3 2007 000801025-8 2007
2 000801026-9 009601026-4 2004 000801026-9 2004
3 000801028-1 009601028-6 2006 000801028-1 2006
4 000801036-8 009601036-3 2008 000801036-8 2008
5 000801044-5 009601044-0 2007 000801044-5 2007
6 000801044-5 009601055-0 2004 000801055-5 2004
7 000801055-5 009601064-8 2001 000801064-3 2001
8 000801055-5 009601091-2 2006 000801091-7 2006
9 000801064-3 009601095-6 2002 000801095-1 2002
10 000801091-7 009601097-8 1998 000801097-3 1998
11 000801091-7...using data from another cell
I would like to type a name in one cell(1) then check in list (different
column) if the same name is there, and if it is there get a value of another
cell locate in the same row where. Can some one help me?
Create your second list and use VLOOKUP as follows:
Name is typed in: A1
List of names and values in: C1:D10
"leo" <firstname.lastname@example.org> wrote in message
> I would like to type a name in one cell(1) then check in list (different
> column) if the same name is there, and if it is t...How to exclude cells from a datasource?
I have an XY chart in excel97 that uses a range of cells
for the data source.
Every now and then I would like to exclude a XYnode from
the chart. Without having to reselt the datasource.
Is there a value one can enter in the cell that exludes it
from the graph (compare: putting text in a cell excludes
it from the SUM() function).
point X Y
a 1 1
b 2 2
c 3 3
Gives a graph with two lines connecting the three points
point X Y
a 1 1
b ? ?
c 3 3
Should give a graph with one line connecting point a and c.
Point b is left out.
Or is the...What must I do to get gridlines printed for both filled and empty cells?
What must I do to get gridlines printed for both filled and empty cells?
I'm a teacher, and I'm trying to replicate and print, in Excel, an
attendance book format, with a series of tiny squares next to each student's
name. The printed form of this would allow me to register if a student were
present or absent on a particular day.
Hubert Earl, vendor of fine Jamaican art, coffee, etc. on eBay:
Fine Jablum Blue Mountain Coffee sales page:
http://stores.ebay.com/Jamaican-Coffee-Art-and-More-Store_Jab...Excel Cell Formatting #3
How do I centeer a picture in an Excel cell?
you can't as such objects 'float' above the cells in Excel
"Tom Coffey" <Tom Coffey@discussions.microsoft.com> schrieb im
> How do I centeer a picture in an Excel cell?
...Chart changing based on change in data source (number of rows/colu
As I see, the data range for charting is normally fixed. I have to produce
chart based on chaning rows and/or columns in data source table. Has anybody
got some suggestion for me?
Bal Ram Bhui -
For Excel charts in general, I suggest Jon Peltier's web site:
For dynamic charts, I suggest:
- Mike Middleton
Decision Analysis Add-ins for Excel
"Bal Ram Bhui, Jakarta" <Bal Ram Bhui, Jakarta@discussions.microsoft.com>
wrote in message news:DD0B5564-26B0-4...Cell possibilities?
I have a spreadsheet which has dates when people have attended a course.
The sheet then updates itself through conditional formatting and formulas to
let me know when course dates have run out.
Is it possible through using either a formula or conditional formatting that
after a certain time period e.g. two months after a course date has run out,
that the date in the cell is erased?
If so how id it done?
Thanks in advance.
What formulas and conditional formulas are you presently using to determine
when course dates expire?
And what exactly do you mean by "erased"?
Do you me...How can i change tab control 's background color
I create a class derived from CTabCtrl. If i handle the
WM_PAINT message, there're nothing left on the control.
Does it mean that I should draw all the things?
And the WM_CTLCOLOR doesn't work,too.
How can I change the background color simply?
...How to change the Volume 1, Issue 1 template
How do i change and work with volume, and issue template in Publisher?
everytime i click on it it wont let me change the numbers. does this work by
how do i work with this feature?
is there a tutorial that discusses this item?
You double-click on it and then you can change anything you want.
MVP Microsoft [Publisher]
"hotmail problems" <email@example.com> wrote in
> How do i change and work with volume, and issue template in Publisher?
> everytim...cells don't adjust
when worksheet is sorted the corresponding cells or the cells linked to the
right, don't move with them. they stay in the same spot. Also this is a big
work group with worksheets that are linked and referenced together....
In other words the cells to the right of the cells be sorted don't shift down
when I sort the page. If you need meto explain more I can!
> when worksheet is sorted the corresponding cells or the cells linked to the
> right, don't move with them. they stay in the same spot. Also this is a big
> work group with work...Ability to change parent account for National Account children
I have several clients using National Accounts that have a need occasionally
to be able to change the parent account for child customers. For one client,
the need arises when detists change affiliation from one practice to another
and the client wants to maintain history across all parent affiliations.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Mic...Changing coler of tracking cells
When I use "track changes" the changed cells are outlined in lavender which
is really hard to see. Is there a way to change the highlight color to a
...To display number in text format in cells
I have a sequence of digits like
I entered in a cell and when the cursor left the cell it displays as
How do I set the cell or the whole spreadsheet to display as text rather
than this format?
Change the cell format to either:
Please keep all correspondence within the NewsGroup, so all may benefit !
"Man T" <alanpltse_NOSPAM@yahoo.com.au> wrote in messag...Why only font size is changed?
i have try to change the font of the win32 common controls, such as tabbar,
edit control. but, it seems that only the font size is changed. i tried to
replace the default font of edit control and tabbar to "Tahoma" and
"Verdana" with some sizes. but the results are both as i mentioned
| winsays@:-)hotmail:-).com |
The psychic ablilities in this group is below par, I'm sad to say. It will
be easier to give you an answer if you show so...Displaying Color in Cells
Help -- I just installed Office 2003 and when working in
Excel am unable to select a cell for color. I know how
to do this (under normal circumstances) but the Excel on
this computer will NOT accept color! I tried opening up
a document created on another PC (Office 2003) that had
color in cells and the color DID NOT SHOW. I am also
unable to change font color. So it seems that color
formatting is not working. Any ideas?
If this is a problem with all files with coloured cells, the Windows OS high
contrast setting may be turned on. There is information in the
following MSKB art...