how to make one colum respond to the next
In one column (F10), I punch an account number (ex. 1999) I would then like
Excl to write the appropriate account name in the following column (D10)
Perhaps you can also mail me your answer if you have a solution
Thanks in advance
You would set up the accounts on another sheet with the account numbers in
the first column. (You could either at this point use the range address in a
VLOOKUP function or name the range, (Edit>Name>Define), say Accounts)
On the sheet you want to put the data when typed use the VLOOKUP function so
if your account n...Not a make item error
I am trying to create a BOM for an item I just created. I set the Item
Replenishment Method to 'Make' on the Item Resource planning screen, but get
an error when trying to create a BOm for this Item. What have I missed?
You have to assign this item as Make item in the Item Engineering window also.
> I am trying to create a BOM for an item I just created. I set the Item
> Replenishment Method to 'Make' on the Item Resource planning screen, but get
> an error when trying to create a BOm for this Item. What have I miss...making a chnge in a report
i have a report and that report imports other data it is abotu 160 pages and
ther are abotu 5 pages that i need to make changes in how do i do that in
Revise the data that feeds the report.
Build a little, test a little.
"Meca Lee" wrote:
> i have a report and that report imports other data it is abotu 160 pages and
> ther are abotu 5 pages that i need to make changes in how do i do that in
...Make Exchagne 2000 reject invalid mail
How can I make Exchange 2000 work just like sendmail, where it rejects
invalid recipients during the SMTP protocol?
> How can I make Exchange 2000 work just like sendmail, where it rejects
> invalid recipients during the SMTP protocol?
> Event Sink?
> Any Ideas???
You can do this in E2003, but see if ORF from www.vamsoft.com looks like it
might fit your needs & your budget (it's inexpensive).
You can't. There may be some 3rd party products that can integrate or query
AD for the list of v...Critical Stop Sound Every 5 Minutes!!!
This is driving me crazy - I can't figure out why the critical stop sound
goes off every 5 minutes. Only the sound, no warning windows or popups
associated with the sound. I've run antivirus and an assortment of
spyware/malware software and nothing comes up. There's nothing logged in
event viewer that is every 5 minutes to point me in the right direction. Any
suggestions? I have Windows XP Media Center w/SP3. This has been happening
for 2 days.
> This is driving me crazy - I can't figure out why the critical stop sound
> goes off every 5 mi...make a menu when burning a mastered dvd
So I can burn a dvd to play in a dvd player, and I understand a general
menu comes up when playing on the dvd player - but the problem I'm
facing is getting the -separate files to show up in a particular order-.
For example, if I have a tv show, I'd like the menu to show up as ep1,
then 2, then 3, so that they would play in order.
I'm not sure if this is possible with the windows vista burning, but
it's fairly important for me.
Please help! Thanks!
On 17 Mar 2010, sweetz88 <email@example.com> wrote in
microsoft.public.windows.vist...make a letter in a cell automatically equal a dollar amount
need to know the formula to have a certain group of cells set up so that when
a specific letter is entered, it will automatically enter a dollar amount
Set up a lookup table that will match the numeric dollar amount to the
corresponding letter, assume this will occur in columns A and B like so, and
starting in row 1:
Column A Column B
Row1 A $100
Row2 B $200
Row3 C $300
Now, assume you enter all of your letters column D starting on row 1 (so
first value is i...Data labels: Making the value currency & use % in a chart?
Is is possible to have in a pie chart BOTH the value with a currency format
and the 1,000 comma option on, with the percentage checked as well?
You might have to construct your own labels in an extra worksheet range,
using a formula like this:
then use a utility like those below to assign these labels to the pie
Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com
Jon Peltier, Microsoft Excel MVP
Peltier Technical ..." error andthe "making new profiles"-solution
Since a week or two I get the error "Unable to open the outlook window"
most of the times when I try to start Outlook for the first time
(OL2003, from Office 2003, winxp prof latest patches for all).
When I click ok, I try again to start outlook and that works ok all the
The MSKnowledge base (
tells me to delete a registry key and make a new profile. Before I try
that solution I would like to be sure about what exacly happens if I
delete the regkey and therefor delete the profil...how can I make a chart with the x-axis in logarithmic scale
how can I make a chart with the x-axis in logarithmic scale. the built in
function makes the y-axis log
You need to use the xy scatter chart type if you want an x-axis log scale.
> how can I make a chart with the x-axis in logarithmic scale. the built in
> function makes the y-axis log
Andy Pope, Microsoft MVP - Excel
Where do I set log scale for x-axis on scatter plot
"Andy Pope" wrote:
> You need to use the xy scatter chart type if you want an x-axis log scale.
&...how to make postcards for mass mailing?
I have blank postcards from post office and wish to put a message on the
postcard for mass mailing. Has anyone done this before? If so, how did you do
Create the appropriate size page, type the stuff on it, put the cards in the
"lilfrogr" <firstname.lastname@example.org> wrote in message
:I have blank postcards from post office and wish to put a message on the
: postcard for mass mailing. Has anyone done this before? If so, how did you
For individual cards, if yo...MS Word 2007 makes files read-only for no apparent reason
Many have experienced this and I haven't found any solutions on this or other
Normally, like most others, I like to save the word document I am working on
every once in a while. The first few times I do this, there is no problem,
but eventually Word will decide that the file you are currently working on is
read-only and cannot be saved.
The read-only box in the file properties is NOT ticked and all security
permissions are in force for the user.
Please help. I am tired of saving my file under a different name every 5
...Convert hours into days hours minutes
Is there a function or a code I can create in Excel where
I can create hours into days with hours and minutes. For
example I have 10.66 as hours..I want to change that in
another cell to read 10 hours and whatever minutes .66
resepresents I think its like 37 minutes or so.. the same
if I had lie 28.5 hours..want it to read 2 days 4 hours
and 30 minutes. Thanks
Excel stores dates and times as a number representing the number of days
since 1900-Jan-0, plus a fractional portion of a 24 hour day: ddddd.tttttt
.. This is called a serial date-time.
http://www.cpearson.com/excel/d...Making my Publiscation Smaller
How do I make my publication smaller? Right now its at 50 MB, and I would
like to make that smaller if possible.
> How do I make my publication smaller? Right now its at 50 MB, and I
> would like to make that smaller if possible.
You have neglected to mention the most salient thing - the version. If
you're running 2000 or earlier, and using JPEGs, there is very little you
can do (save buy 2002 or 2003) as Publisher decompresses them before saving
Facon - the artificial bacon bits you get in Pizza Hut for sprinkling
o...Calculate Time Using Minutes and Seconds Only
I am trying to calculate a race time using just Mins and Secs to give the
overall race time . How can I format my fields to show only mins and secs
without Access trying to convert to Hour Mins and secs when the mins are 60
On Wed, 19 Mar 2008 07:21:06 -0700, Val@AGIS
>I am trying to calculate a race time using just Mins and Secs to give the
>overall race time . How can I format my fields to show only mins and secs
>without Access trying to convert to Hour Mins and secs when the mins are 60
>...converting hrs to minutes
I have a large database with values in hrs (i.e. 1:06, 123:45, 345:56
etc) I want to convert these to minutes (1:06 to 68, 123:45 to 7425
I've been fooling with the convert and format functions but haven't
Help would be appreciated.
If your time values are in column A, type = A1*1440 in column B1 , then copy
Format B1 as Standard
"Jerome Ranch" <email@example.com> a �crit dans le message de
> I have a large database with values in hrs (i.e. 1:06, 123:45, 345:56
> etc...How do I make criteria = dates
I want to do a query, part of this query I need to know if a date is
i.e if john has completed training on the 20/03/06 and this training expries
on the 20/3/08. When I ran my training query I need to know any dates that
are 60 and 30 days from the expiry date.
I hope there is someone where that can help me out
In query design view, type an expression like this into the Field row:
Due: DateDiff("d", Date(), [ExpiryDate])
In the Criteria under this, you can use:
Between 0 And 60
"Ian" <firstname.lastname@example.org>...how do I make a voting ballot?
Any easy ways to make a ballot with six candidates, space for write in as well.
This should not be a difficult thing to do. A couple of squares to check,
the candidates' names or a blank line. Am I missing something?
The harder part should be deciding who deserves your vote. Is "None of the
above" a valid option? ;-)
MVP Microsoft [Publisher]
"Jackie Lee" <Jackie Lee@discussions.microsoft.com> wrote in message
> Any easy ways to make a ballot with six candidates, s...Macros to select multiple sheets to make simultaneous change
I need to have a macro such that it'll select all sheets
from the first to the sheet before a sheet called "test".
After selecting these sheets, i want to make simultaneous
changes to them. So how do I add the code in the macro to
choose all these sheets?
I can't put the names of the sheets coz the names changes
This will loop through the sheets
Dim num As Integer
Dim a As Integer
num = Sheets("test").Index - 1
For a = 1 To num
MsgBox .Na...how to make a query to find the company with large number of selli
I have two tables, one for the companies' info and one for t selling
In the selling table there is data for customers, companies, prices etc.
What I want to do is making a query to know which company has the large No.
Can any body help me plzzzz
What do you mean by "which company has the large No. of selling"? Most sales?
Largest dollar amounts? Most items? In other words, which field determines
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
&g...How do I makes the left Word icons smaller?
The icons in the left vertical task bar have been resized too large and cause
me to have to scroll down to Close. I'm sure I did this by mistake. How can
I restore them to a smaller size?
As far as I can see there is no "Large Icons" option in Customize in Word
2007 as there is in earlier versions, so the only explanation I can think of
is a change in screen resolution.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Nannie" <Nannie@discussions.microsoft.com> wrote in message
news:CB...Making a UserForm show above a any opened doc
I am using a userform to load document into Word, but when the
document is opened, the userform window will be covered by the opened
file. This happens whether the ShowModal property is set to True or
I checked online and found this posted by Doug:
Making a UserForm show above a newly created Word 2000+
but the link is removed. :(
I also tried to minimize the newly opened file with the following
wrdDoc.Windows(1).WindowState = wdWindowStateMinimize
(The wrdDoc is the file object and I v...make column headings automatically appear as axis chart labels
if i highlight a range (say two columns ) of data and i have the first col as
'x' values with the data type as a column heading eg 'length (metres)' and
the 2nd column as say 'weight (kilograms)', can I get Excel to automatically
use these upper cells as axis labels when i insert a chart?
Not automatically but you can link a chart title (axis or main) to a cell by
selecting the title, typing = in the formula bar and clicking the cell to
generate a reference such as =Sheet1!$A$1
Microsoft Ex...Exchange 2007: How to make OWA-users auto-login?
Without using forms based authentication, how can I make everyone login
automatically in OWA?
Now I receive a popup asking for credentials.
Use integrated windows authentication on the exchange virtuel directory.
"Prem" <email@example.com> wrote in message
> Without using forms based authentication, how can I make everyone login
> automatically in OWA?
> Now I receive a popup asking for credentials.
Thanks for reply, but I'm sorry, but that does not work, creden...Making sure Comment in Workbook is never deleted
Excel 2002 SP3
Win XP Pro SP2
I need to pass a spreadsheet around to others BUT I also need to have a
clearly visible explanatory comment on the first sheet.
How do I make absolutely sure that no matter what, this comment is never
Just write the comment, make it visible and lock that cell?
Is that the best way or is there a better way?
Don't forget to protect the sheet as well.
On Feb 29, 3:39=A0pm, stef <notva...@nomail.nul> wrote:
> Excel 2002 SP3
> Win XP Pro SP2
> I need to pass a spreadsheet around to others B...