link custom field to resource names
i have created a custom field "Primary contact"
is there a way to link it to the list of Resource names?
maybe turn it into a drop down list?
"greg" <email@example.com> wrote in message
> i have created a custom field "Primary contact"
> is there a way to link it to the list of Resource names?
> maybe turn it into a drop down list?
...Display Field Name as Text Listing if Value True from Checkbox Fields
I have 40 or so columns in a table using the yes/no data type. Each
record in the table represents an audit of a paper form. Those items
filled incorrectly or incompletely on the paper form receive a check
on an access form during the audit process.
I would like to create a feedback form based on the audit record that
displays a listing of fields that received the check boxes, or rather,
were incomplete or incorrect on paper form that was audited.
On the feedback form, I only want to display something like this:
"Your form had the following errors:
Erro...Use Copied Outlook PST file as default...How?
If I copy a PST file on my PC, how can I configure my
Laptop Outlook to use that copied file as its default.
Is it possible to copy new Defined Views in Contacts from
one computer to another.
Dmahanay <firstname.lastname@example.org> wrote:
> If I copy a PST file on my PC, how can I configure my
> Laptop Outlook to use that copied file as its default.
> Is it possible to copy new Defined Views in Contacts from
> one computer to another.
I think views are registry items and not kept in the PST.
My outlook version is 2002.
>--...Preserving Cell Formats in Excel Query
I am doing queries on a large workbook of multiple Excel spreadsheets. When I query the data, the original data formats don't carry through to the query results. Is there a way to carry original formatting through to Excel Query results
Any insight would be appreciated
No, you can import the data, but not the formats. If you're importing
programmatically, you could apply the formatting as part of the import
Karen S wrote:
> I am doing queries on a large workbook of multiple Excel spreadsheets. When I query the data, the original data formats don't car...Format cells with dates
Is there a way to format cells so that dates would change when the lead date is changed. for example, when I input monday's date, tue, wed, thur, etc will follow suit.
Assuming the first date is in A1
C1: =B 1+1
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Pat" <email@example.com> wrote in message
> Is there a way to format cells so that dates would change when the lead
date is...URGENT!!! Problem with row data being truncated in a copy worksheet sub #2
Dave, Thanks for responding. I tried this but I could not get it t
work in conjunction with the entire module. It dies right afte
copying and PasteSpecial Values It does not kill the temp file or loa
the newly created sheet into an e-mail. Any Ideas
DoctorV's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=514
View this thread: http://www.excelforum.com/showthread.php?threadid=26863
You may want to post your current procedure.
> Dave, Thanks for respon...Search Multiple Worksheets #2
Is there a way to search trough multiple worksheets for a specific value?
Other posts have mentioned to use VBA, but I have never used that before. If
anyone can give me some advice on using that or a type of formula to perform
that can search multiple worksheets.
There may be other ways but, while holding down the ctrl key select each of
the worksheet tabs you want to search in then select Edit|Find from the
menu. Type in the value you want and it will go to the first instance of
that value. Now if you are wanting to preserve a specifice value for
reference or ???, then...map data (x-y axis) with diffent series name
I have a set of x-y coordinate data set and i would like to plot them showing
the respective series name. Is there an automatic way of doing this without
haing to plot the data points separately. eg
Name x y
A 1 6
B 2 3
C 3 4
D 4 2
E 5 5
.. . .
.. . .
.. . .
I will like to have a plot of x and y with A, B, C as series name without
having to plot the points one after the other.
Here are a couple of free addins that allow you to link data labels to
Rob Bovey's Char...Counting of Names ?
I have some names in some cells like " Abraham" " Sathish " etc . I
want the number of occurances of each name Counted ,within a range of
cells and made known at a perticulat cell
Name No of Times
Put the unique names in a column and use (eg)
If you want a fast way of extracting the list of names see:
Norman Harker MVP (Excel)
Excel and Word Function Lists (...How to goto cell containing specific date
Thought I asked this before, but can't find the thread w/ my question or any
I have a worksheet wih a full year's dates in the cells running down a
colum, with other data for each date in the the adjacent columns; Instead of
scrolling up & down to a cell with a specific date I'm looking for, is there
another way to goto a cell containing a specific date? (e.g., today(), or
another specific date)
In case this is pertinent: the date series begins with the entry of one date
(e.g., 01/01/2010 in cell A1), with the dates in subsequent rows arrived at
...opening excel worksheet
Operating System: Mac OS X 10.6 (Snow Leopard)
whenever I try to open an existing excel worksheet it opens very short. I have to drag it down to the bottom of the screen, is there a setting that i need to adjust?
No, simply SAVE the workbook after you adjust it.
Next time, it will open at the size you want.
On 27/03/10 6:42 AM, in article 59bb6065.-1@webcrossing.JaKIaxP2ac0,
"firstname.lastname@example.org" <email@example.com> wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> wh...How do I turn the pivot chart into a list with all cells filled?
I have the pivot chart and would like to copy and paste it so that all fields
Select the pivot table.
Select the cell where you'd like to paste the copy
Choose Edit>Paste Special
Select Values, click OK
There are instructions here for filling the blanks:
> I have the pivot chart and would like to copy and paste it so that all fields
> are filled
Excel FAQ, Tips & Book List
...How do you copy a cell's content verses it's formula?
I have 2 cells and combined them into a third cell with the following
formula... =a1&" "&b1. I was combining a person's first name (cell 1) with a
person's second name (cell 2) so cell 3 included the first and second name.
Now I want to copy and paste cell 3, but it copies the formula... I need to
paste in the content (first and second name) not the formula.
You could use a macro see JOIN macro on it's page
not what you actually asked because if would change
column A with the concatenated const...Conditional Cell Fill?
Is there a way to use fill colors based on formulas?
Look at conditional formatting in help
"Rusty Williamson" <firstname.lastname@example.org> wrote in message
> Is there a way to use fill colors based on formulas?
...Multiple copies of E-Mail messages
I am using Outlook 2002 (10.4219.4219) SP2 with a Windows XP Professional
Just in the last couple days I've started to experience a problem with
incoming e-mail messages. I use Outlook to retrieve e-mail from at least
four different accounts, from at least two different servers.
When I receive a new e-mail message that is addressed to one of these e-mail
accounts, I get two extra copies of that message, and each of these extra
copies are addressed to two of my other accounts. So what I end up with is
three copies with three different TO: addresses. This only happens ...10 free copies of iPrep Microsoft 70-290 for your iPhone
iPrep Microsoft 70-290 is an iPhone app which will help you to prepare
for Microsoft 70-290 certification exam "Managing and Maintaining a
Microsoft Windows Server 2003 Environment".
Download the app from the App Store:
Use one of the following codes to get your copy for free:
Each code can be used only once, first come first served. The codes
are redeemable only ...how do i switch to a right to left worksheet
Do you mean this ?
Regards Ron de Bruin
"li" <email@example.com> wrote in message news:C02DC0F7-14E2-4424-8A62-8191E853C48B@microsoft.com...
under Excel Options
"li" <firstname.lastname@example.org> wrote in message
...Formatting hyperlinks in an Excel cell 02-16-10
Two of the columns in a spreadsheet (Excel 2003) that I use record email and
All of them appear as hyperlinks i.e. blue and underlined but some
occasionally seem to lose their hyperlink properties. This means that when
one hovers over them, the cursor stays as the usual Excel cross rather than
changing to the hand/finger symbol. Also, clicking on the former does not
launch the browser.
Is there any way to ensure they are formatted, and work, as hyperlinks
...calculation of cells
Periodically I open a work book and the calculation option
has been changed to manual and I cannot figure out why. It
seems that it would have to be done by a user and most of
my spreadsheets are only used by me.
Any ideas out there
Calculation, auto or manual, is set by the first workbook that's opened. It
is that way for any other workbooks opened in that instance of excel. Look
for a workbook you might have opened first that's been set to Manual and
saved that way. Go figure.
mvpearl omitthisword at verizon period net
------------------------------...returning vlookup values for blank cells
I have a spreadsheet that lists "soccer players" by name
down the first colunm and "time in game" across the top
and the position they play in array.
I then use vlookup for another spreedsheet by "position"
down the first column, time across the top and puts the
players name into the positions. All this works fine.
Since there are 5 more kids than positions, the orginal
spreedsheet has blanks when the kids are out of the game.
How do I use vlookup or other to extract the 5 sub'd out
kids at the bottom of the 2nd spreadsheet? It only
returns the nam...Skip blank cells in diagrams
How do I exclude blank cells in diagrams. If I have an area of data and among
these data some is blank. How do I get excel to not display these data as '0'
but just to skip the cell.
You can include the function NA() in that field and the zero value for the
data won't be displayed.
"hlp" <email@example.com> wrote in message
> How do I exclude blank cells in diagrams. If I have an area of data and
> these data some is blank. How do I get excel to not display these data as
'0...Automating transfer of data in cells
I have a time management spreadsheet with data stored
against work type and date. I need to transfer this data
into a similar but more comprehensive spreadsheet and
wonder whether it is possible to automate this task by
using the work types and dates in a macro (I have almost
10 months of data to transfer), along the lines of check
date, check worktype, where argument is true enter data
from cell. I think I need to use visual basic, but I
can't find out how in the help screens.
Any advice is much appreciated.
This is not difficult providing you keep your data in simple tables...Printing a worksheet in two (or more) columns
I've got an extremely long spreadsheet table comprising two columns of data.
I'd like to print these data in a more compact form - in the same way that
the entries are organised in a telephone directory.
Say on average my page is 50 rows high - my first two columns on page 1
would appear on the left hand side and be rows 1 through 50, row 51 would
continue at the top of the page, but on the right-hand side. Row 101 would
appear at the top left hand side of page 2, etc.
I'd like to keep the orientation of the columns in portrait (I did find a
printer-associ...How do you copy contacts into an email?
Hello all. Outlook 2000 with all necessary service packs
and updates. I want to be able to copy a list of 30
contacts into the body of an email. I have to send emails
every now and then with the names of these individuals
listed in the body of the email. I already know how to
export contacts into an excel spreadsheet. However,
Outlook 2k does not give you the choice to export into
Word. When I export into excel and I copy more than one
name at a time they show up in the email with the
gridlines wrapped around the names from the excel
spreadsheet. I have removed the gridlines from the...File Name Length
Does anyone know if filenames can be longer than 31 characters in Office
In article <firstname.lastname@example.org>,
"JM" <email@example.com> wrote:
> Does anyone know if filenames can be longer than 31 characters in Office
> 2004? Thanks.
FIrst, you *can* have filenames longer than 31 characters in Office v.X
already - you just can't generate them. While v.X apps display a hash at
the end of a long filename, it keeps the filename intact when you save.
MS hasn't announced anything regarding long file names in 2004 ye...