Changing Cells and entering data in them
Thanks for the help again.
Big thanks to Steve you've got me this far.
I went out and bought a book, but it's like reading a
I was informed today that I can't have message boxes come
I need to have the code point at the cells and if they are
blank turn which ever one is blank red or if both are then
both turn red then pause for each cell to be filled in.
Cell F14 "Last Name" then automatically go to Cell
F16 "First Name" on tab or enter.
Basically if Cell F22 or F23 has an X in it, Cells F14 an
F16 turn red and cell F14 has the focus...Formula without using numbers after decimal in the answer
I have a formula that derives the answer from a figure with a decimal. I
don't want to use the figures after the decimal. Is there a way to just use
the whole number and omit the numbers after the decimal without having to
manually key in all these numbers manually?
You can use the INT function. This 'rounds down' any number to th
nearest integer, e.g. if A1=2.567, a formula in B2 of =INT(A1) return
swatsp0p's Profile: http://www.excelforum.com/member.php?...Linking files 2 ways
I have a work book that is linked to another and vise versa.
Workbook A is where the input of data is made;
Workbook B has a link to the input from workbook A;
Workbook A retrieves the altered data back as a link.
Although this all works fine with both books open, I note that if I open
workbook A by itself, that the data it retrieves from Workbook B is not
updated . If However, both books are open, there's no problem. I thought
linked books were updated automatically if the Update remote references has
been selected?? But it appears that the second book is not updated until it
...More Columns #2
I am using all columns through IV on one of my
worksheets. Does anyone know how to get more columns?
know way using Excel. this is the maximum!
Stacy Haskins wrote:
> I am using all columns through IV on one of my
> worksheets. Does anyone know how to get more columns?
As Frank said, that's the maximum cols
But maybe you could try transposing your table / data ?
(Excel has a lot more rows than columns)
If so, try: http://tinyurl.com/2nmyy
for an example on using TRANSPOSE()
For a one-time Tranpose:
Copy > Paste Specia...conditional formatting sort
Is there a way to sort after conditional formatting. So, if I've set up a
conditional format to color my text red if the number is between 0 and 95,
then I want to sort so all red numbers are at the top of the spreadsheet?
Thanks for your time and assistance.
On Thu, 25 Oct 2007 05:08:00 -0700, rrupp
You can't sort by color, but you can add a column to your query like
SortColumn: Iif(SomeValue >= 0 and SomeValue <= 95, 1, 2)
Then sort by this column.
>Is there a way to sort after condition...Find and Replace Footnote Numbering
I often have documents where I need to put formatting before or after the
footnote number for every footnote, often for hundreds of footnotes...anyone
know how I can do this in one shot? I know I can specify ^f in find and
replace, but only in the find portion...it gives an error if you put it in
...Contacts in Exchange #2
We are running Exchange 2003 and Outlook 2003. I have tried to give a user
rights to her boss's contacts through delegation and setting the rights on
the contacts folder, however, while she has the rights she is unable to add
or see her boss's contact folder in her Outlook. She can see it if she runs
a search, but can not permanently put it in her list of contact folders. IS
there a way that I can accomplish this through the back-end?
...Offline Synchronization Problem #2
I get the following error when I try going offline. The excelption is taken
from Event Viewer of the Client Machine.
Event Type: Error
Event Source: MSCRMOfflineSync
Event Category: None
Event ID: 6000
Time: 5:03:33 PM
An error occurred during Offline Synchronization. Try going offline again,
or restart Microsoft Outlook. saInsert failed for entity
'ActivityMimeAttachment', batchRows=0 with exception System.FormatException:
Index (zero based) must be greater than or equal to zero and less than the
size of the argument li...Show date, time & day of week in one cell
Can I show the date, time and day of week in one cell.
09/03/07 8:30 AM
in one cell using the format (Format/Cells/Custom):
[$-409]mm/dd/yy h:mm AM/PM;@
Excel refuses to accept ddd for Mon or dddd Monday at the end of the format
I want it to read:
09/03/07 8:30 AM Monday in 1 cell.
I have Excel 2003.
mm/dd/yy h:mm AM/PM dddd;@
In article <Xns99B8A3CAF9130pencilunlistedcom@126.96.36.199>,
Burp <email@example.comINVALID> wrote:
> Can I show the date, time and day of week in one cell.
> I have:
> 09/03/07 8:30 AM
> in one cell using the for...Goal Seek #2
Can anyone tell me a little about goal seek?
basically it's used to change an input variable so that the result of the
formula equals what you want it to ...
say i have the following
A B C
1 10 20 =A1+B1
now C1 will give me 30, but if i want to know what B1 will need to be if i
want C1 to show 50, i can use goal seek
Set C1 to value of 50 by changing B1
Hope this helps
"Jamie Hart" <firstname.lastname@example.org> wrote in message
> Can a...How do I Remove a Split from my Comments in Excel 2003? #2
I have set my current workbook to split/freeze the first column and first 2
rows. Now, when I add a comment to the second row (in any column) my comments
are cut off if I should scroll down.
I don't ever remember the behavior before. And I don't know what I've done
to enable it but it's really annoying.
How do turn this off ?
...default values in a cell
Hello, can you help me please
Cell B1 contains a complex mathematical formula which requires (in several
places) a number from cell A1.
Cell A1 can contain any integer number, but it is usually the same (30).
I would like to be able to leave cell A1 empty, and only enter a number when
it is not 30 ,
ie the default value of A1 is 30, unless specified.
How do I go about this ?
Should I look at conditional formatting, or put lots of IF functions into an
already complex formula?
Thank as always
Use 2 cells
Modify the complex formula to use B1 rather than A1 ( or any other un-u...random number generator
Hey is there a way to generate random numbers like you would for a
draft. In other words, i have numbers 1 through 10 and generate a
random order for those?
Use the RAND() function. If 1-10 are in A1:A10, enter =RAND() in cell B1 and
copy it down through B10. Recalc (F9), then sort by column B.
Hope this helps,
> Hey is there a way to generate random numbers like you would for a
> draft. In other words, i have numbers 1 through 10 and generate a
> random order for those?
You would have to generate 10 random numbers ...number format with leading 0
Dose anyone know how to create a number format that would show a leading zero
for the numbers 0-9. That is, so that 1 would show as 01. I can do with a
text format but would like to retain the integrity of the number.
Does that help?
> Dose anyone know how to create a number format that would show a leading zero
> for the numbers 0-9. That is, so that 1 would show as 01. I can do with a
> text format but would like to retain the integrity...Increment A2 from A1 and A2 Sum #2
I have two cells:
A1 - manual value
B1 - automatic increment = B1 + A1
How can i make it?
(=error: circular reference)
Note: I have this formula repeated in some lines:
= B2 + A2
= B3 + A3
Message posted from http://www.ExcelForum.com
...ERROR: 5.1.2 or other punctuation after the recipient's email address.
I am trying to send a email to a group address I created with 58 addresses
When I try to send the email to this group I get the following Error:
"5.1.2 or other punctuation after the recipient's email address. "
I have gone back to the original contact cards and made sure the addresses
were all legal.
I have re-created the list, same problem
I have re-booted, same thing.
Any thoughts out there?
My wife and I have MBP's and are both running MS Office for Mac's, Entourage
Both of us have messages cued up in the out boxes th...Fixing a formula to read a general format?
A few months ago I had asked a question and got this answer:
I have a a set of values in A1 through A100.
I need to look up each value and find a match in
another set of values located in C1 through C200. If a match is found then I
need the formula located
in column B to return the value in the same row but
the next column over (D).
Copy down through A100.
The formula worked fine, however the reference value and the look up value
are not any more numbers but a combinatio...Call & Place Graphic Based on Cell Value?
Is there any way to call & place a graphic image based upon a cell value?
Maybe you can look at J.E. McGimpsey's page:
> Is there any way to call & place a graphic image based upon a cell value?
...HOWTO: Customizing CRM
We would like to customize our CRM Opportunity form. We want to
include a OpportunityNumber field, which will be auto-generated when
the new opportunity is created, similar to auto-numbers for Contracts,
Cases, Articles, Quotes, etc. Is it possible and how do we go about
I've looked at CRM Deployment Manager. It's possible to create a
simple custom Attribute for particular object. But I couldn't figure
out how to make it an auto-generated number, like SQLServer
Identity... Could I just modify OpportunityBase table in MSCRM
database? Do I need to change METABASE databas...Converting Formula into Numbers?
With a cell/s selected is there a way to convert the cell's formula into
straight numbers (in turn removing all formula and leaving the same
Emp-Designer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37564
View this thread: http://www.excelforum.com/showthread.php?threadid=571948
Emp-Designer a �crit :
> With a cell/s selected is there a way to convert the cell's formula into
> straight numbers (in turn removing all formula and leaving the same
&...COUNTIF MULTIPLE CRITERIA #2
To count if Col A=aa and Col B=bb and Col C=cc. Must meet all situation.
Adjust range references to suit your situation
Does that help?
"will A" wrote:
> To count if Col A=aa and Col B=bb and Col C=cc. Must meet all situation.
> will A
SUMPRODUCT does not work on a complete column, just a defined range, and all
ranges must b...Is there a way to cut off unused cells on a sheet
It seems there are an infinite number of cells on a sheet. As I really dont
have much info to enter on each sheet I was hoping there was a way I could
somehow cut off all the extra stuff to the sides and bottoms. It is a hassle
because everytime I scroll, it will scroll off the side or bottom way past
what I was looking for.
A manual way is to goto the last used row and delete all rows below. Do the
same with columns. SAVE
"newbie" <email@example.com> wrote in message
news:469AABE7-8D17-4B72-91C1-...Automatically copy input from one cell to another
After I enter a value in one cell, how can
I have it automatically enter it into another cell,
within the same worksheet, or into a different worksheet.
Message posted from http://www.ExcelForum.com
If you enter the value in A1 of sheet1, put this in the other cell in
or in another worksheet:
In article <firstname.lastname@example.org>,
picktr <<email@example.com>> wrote:
> After I enter a value in one cell, how can
> I have it automatically enter it into another cell...Calculations adding Text formats
I am new at this so please bear with me.
I am using Excel XP. In my column I have a list of
numbers. Some are formatted as text and some are
formatted at numeric.
When I insert by formula it seems to be calculating the
entire column, even the text formatted cells.
What am I doing wrong.
Cell A1 = 5 - numeric
Cell A2 = 5 - text format
Cell A3 = 5 - text format
Cell A4 = 5 - numeric format
formula states =sum(a1:a4) the total should be 10 not 20.
You're not doing anything wrong, per se.
Changing formats cannot change numbers into text values or text values
into...2 different Qty in order details in northwind
im pretty new with access 2007, i decide to use northwind template.
In order detail both form, i have 2 different Qty, the original Qty is the
Qty that will link to Inventory and I add another field Qty1 for invoice
purpose. For example, I got 1 roll of tape, 1 roll will be cut into 10 pcs.
We need to bill according to customer request qty 10, but actual qty sold is
only 1. Anyone come across this issue. How to modify it w/o effect the
table/form as below:-
QUANTITY (FOR INVENTORY)
QTY1 (FOR INVOICE)
AND SO ON
Is there a...