Excel Lists Dependencies
i have a problem to solve:
I want users to be able to pick a project from a list (no problem) and
then i want excel to pick the project number according to the project
name automatically from a list. To make my problem clear let's say a
user picks Project A from a drop down list in cell A1, then I want
excel to display the correct project number in cell B1 automatically.
Not all employees know projects by name in our company hence this
idea. The best would be to store the project number in a list similar
to a list used for drop down menus. The projects change and so do the
I have someone who says they entered data into a database, but the data isn't
there. Others have entered data into the same database and that data is
there. All users have used the same front-end. Save is automatic when the
form is closed. There are no signs of corruption.
Is this possible?
"Tara" <Tara@discussions.microsoft.com> wrote in message
>I have someone who says they entered data into a database, but the data
> there. Others have entered data into the same database ...about transfer order
I created a transfer order "TO666", transfer items from store01 to store02,
the system automaticly created a TO No."00001_TO666 ". And the strange thing
happend: the items in "TO666" is so different with the items in "00001_TO666
where is the problem?
with a lot of thanks.
Try creating another order with the same items, if the problem still exists,
most probably you have a problem in the IDs of those items.
What HQ does is to map the items in the created order in Store1 to the
corresponding items in HQ, then map them again to Store2 and th...Org Chart -- Imports from Word of Job Descriptions?
We are new to Visio, using the trial version. My wife's boss just dumped a
project on her that I said I'd try to help her with. Her new, computer
illiterate, boss is making many organizational changes (small university) and
wants to make a PowerPoint presentation illustrating these changes.
He wants to be able to click on a position and have the job description for
that position pop-up as a new page/slide. The job descriptions are in Word
2003. My wife has Word & PowerPoint 2007 on her machine at work, and we have
Office 2003 on our PC's at home. Is this possible ...Accessing Excel API without installing Excel
Can I access MS Excel APIs and Excel Object model without installing MS Excel
on the target machine?
Any information will be helpful.
...Scroll wheel not working in Word 7
I have Word for Windows 95 version 7.0. I am using it on my current
XP Home SP3 system, and it works fine, except that the mouse scroll
wheel doesn't work in Word. It works fine in all other apps.
It is a Labtec mouse. Device Manager says:
PS/2 Compatible Mouse
This device is working properly
Driver Provider: Microsoft
Driver Date: 01/07/2001
Driver Version: 5.1.2600.0
Tried installing "WizMouse" (www.antibody-software.com), which has an
option to 'Enable mouse wheel for applications without mouse wheel
support', but that doesn't cure the problem. Any ...Excel spreadsheet not opening
Working in Office 97 and having Trouble opening a document
in excel. The document will flick, and then minimize and
will not open when the icon is clicked. The only way of
opening it is to open another excel document and then open
this particular document. It has worked well for months
and this is the only spreadsheet I am having trouble with.
sounds like this sheet got corrupted. Best way: create a new file and
copy your data to this new file
> Working in Office 97 and having Trouble opening a document
> in excel. Th...Line selection for formating in Excel chart
Have "plain vanilla" line chart in excel spread sheet. Data series consist of
several lines closely space. Normally I can select and RClick a single series
for formating such as line color and thickness. Is it possible to
simultaneously select all data series to change a common format such as line
thickness. I'd like to do this without individually selecting each line while
the control key is depressed. (lazy and not that good-a shot). ~Dave
No you can not select multiple series, like you can with shape objects.
The only time saver is, select 1 on the series and the f...Preserving Fornatting in Pivot tables
I run quite a lot of pivot tables and update them
I am struggling to preserve the formatting on them. When I
refresh the table they lose some or all of the formatting.
I have played about with table options - Autoformat &
preserve formating but without any success...
Pick on one of the fields in the data area that has a value in it. Right click and choose Field
settings / Number / Choose a format, hit OK, and it should be retained.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro /...Transfering messages
I want to transfer all my messages from one PC running Vista to another
running Win7 which I have Windows Mail running on. However, I have two
1. On transferring some of the transferred folders contain the full message,
some only contain what you might call place holders e.g my transferred Inbox
has 'From' with a list of 30 or so messages but just shows an envelop and
the date and time but no message
2. Is there away to transfer attachments too?
"Ron O'Brien" <firstname.lastname@example.org> wrote in message
news:uBH3g6UjKHA.218...deleting phrases in Excel and/or Word
My question is for beginners but I am working with spreadsheets and documents
which contains a lot of the same words I want to delete. Can anyone please
tell me how I can do this? THANK YOU BEFOREHAND FOR YOUR HELP!
Here's one quick play using SUBSTITUTE for progressive deletion ..
Assume text data is running in A1 down
Enter the exact words/phrases (case sensitive) you want deleted in say K1
down. Eg assuming you have 3 words to delete:
in K1: the, in K2: Oops, in K3: milk
Then place in B1:
Copy B1 across by 3* cols to ...Word as an editor
I have Outlook 2000 and Word 2002. When I compose an email I get a message
that tells me that I need to update my Outlook to the same version as Word
to use Word as the editor. In the past I was able to use these two programs
together without any problems but now I cannot.
If you were once able to use these 2 programs together, I would dearly like
to know how you accomplished it since different versions of Outlook and Word
(except for Outlook 98/Word 97) have NEVER functioned together.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discus...database creation
i am trying to creat a directory in excel. I have about a 1000 listings i've
found, but it is very tedious entereing them all (name, address, phone #) one
by one. Is there a spider or bot or something that can take this info and add
it into excel for me?
Where are the listings you found?
Maybe you could use the Data>Import External Data and choose Import Data or New
Gord Dibben MS Excel MVP
On Wed, 3 Oct 2007 11:07:04 -0700, erok <email@example.com> wrote:
>i am trying to creat a directory in excel. I have about a 1000 listings i've
>f...Extender tables #2
We are implementing an integration from Microsoft CRM into Microsoft Great
Plains and this would include writing CRM fields to Extender Fields. Are
there any available SDK's for Extender or maybe any table lists?
There are but I think only partners can get them.
Please send me a message and I'll send you what I have.
"Andi Saldana" wrote:
> We are implementing an integration from Microsoft CRM into Microsoft Great
> Plains and this would include writing CRM fields to Extender Fields. Are
> there any avai...Automatic .Doc Mail merge
is there any way or Method of the proxy dll, that allows to
execute the mail merge of am Offer / Quote / Order template
generating a .Doc document ?
...Send Excel 2002 spreadsheet to MacIntosh Excel 2004
How do I save my Excel 2002 spreadsheet so that someone with MacIntosh Excel
2004 can read it properly?
...i can't seem to delete a document from 2007 word.
i have documents on word that i created during trial period on word. i want
to delete them and i can't. isn't there a simple delete method where you
highlight the document and it deletes? when i right click i get options
about ribbons. when i open saved files, i can't find the documents that are
on word 7
"imeighty" <firstname.lastname@example.org> wrote in message
> i have documents on word that i created during trial period on word. i
> to delete them and i can'...HR Position Transfers
Is there a way to import a mass amount of position changes in GP HR?
We are getting ready to effect changes for our upcoming fiscal year.
There are numerous changes to our departments, positions moving from
one department to another and some of the departments are altogether
new. Is there a tool to import Position Change/Transfers? If not,
does anyone know all the tables I would need to hit if I need to
import the data?
...E-mail Excel Attachments to People Who do not have Excel
I want to send a short Excel table in an e-mail to allow for recipents to
input their basic contact information and hit reply with the updated table.
The table will be 2 rows (1 row will be a header) and about 8 columns.
Alot of these e-mail recipients do not have Excel, and some have no MS Office
products at all.
I want an easy way to collect basic contact information from people and
import it into a large Excel spreadsheet for a club I am doing work for. Our
club does not have the money or knowledge to setup a input database on a web
site to collect such information.
How can ...Print Excel file to PDF
Is there a VBA code, or a program whereby I can print an Excel file to a
PDF? (Maybe an add-in?)
I'd like to do it directly from Excel similarly to the way Word Perfect has
that option in the file menu if possible, but anything will be a help.
(I'm using Office 2000)
You could purchase Adobe Acrobat.
An alternative to buying Adobe Acrobat....
I have had success with the free file downloads and instructions for use here
at Dale Nurden's site.
Saves first to single *.ps file which is then converted to *.pdf
Return...Excel to PDG Format Error
I am used to using Excel 2007 to convert my workbooks into PDF's. However,
recently, all of a sudden, everytime I PDF a workbook my Formating and graphs
are all wrong. I have noticed that this only happens when I do multiple
sheets, but the problem with doing individual ones is that I can't combine
them with reader.
Try Dr. Dan's All-Purpose Excel-PDF Cure:
Select all worksheets by <ctrl> or <shift> clicking
from the menu bar: File > Page Setup
click into the Page Quality box, and select 600dpi, if it already says
600dpi, select it again.
...Windows Easy Transfer
I am having trouble with Easy Transfer from an XPhome to XPhome installation.
Actually it is the same computer after re-installing XP. I ran the Easy
Transfer to back up the data onto an external drive. When I run it now on the
new build I don't get the "Continue transfer in Progress" option. It does not
ask if this is the new or old computer. I haven't used it before so maybe I
am not using it as intended. I have user the XP File settings and transfer
program for a situation just like this with no problems.
Computer is a basic HP Pavi...Access an excel file through FTP without write protection
I placed a question yesterday - approximately 28 hours ago - nobody have
reacted on it - please tell me if you don't understand my question because
my English is to bad.
...Simple Template excel for Books
I need free Excel Template for my list of reading Books, Thanks
"=?Utf-8?B?c2FtLWM=?=" <email@example.com> wrote in
> I need free Excel Template for my list of reading Books, Thanks
Have a look here:
It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)
...Transferring an order to an invoice...
We are transferring over to GP 10. I have a question about invoicing that
I hope someone here can help me with.
In GP 8, there was a transfer button on the Sales Order Transaction screen
to transfer the order to an invoice. In GP 10, the transfer option is in a
pull down menu. Can we make the transfer option a 3rd button on the screen?
If someone could let me know, I would appreciate your help greatly!
yes you should be able to do that if you wish using a button and a bit of
This posting is provided "AS IS" with no warranties, a...