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...how to convert lookup values to the "display text"
I'm using an sql code (below) which uses a few lookup fields. Unfortunately
in the datasheet view, I get the "bound values" instead of the "display
values". How can I change the properties for the these lookup fields so I
can see the "display values" from the datasheet view?
UNION ALL SELECT
UNION ALL SELECT
[Funding],[Date],[Description],[C...Need Help, Task Start Date is wrong
I’m using MS Project 2007, have several task linked with finish to start. I
have set date to schedule from, hours per day set to 8 and Working Monday
My schedule shows Task 1 Duration 4 days, start Wed 6/2/10, Finish Mon 6/7/10
Task 2 Duration 3 days, start Mon 6/7/10, Finish Thu 6/10/10
Task 2 should have a Start Date of 6/8/10 not 6/7/10; what is causing this?
Thanks in advance for your help.
...Looking for Excel Help
I'm a very novice Excel user and am looking for a little help with
creating a formula for a spreadsheet I'm creating for
my personal use. I would appreciate some
assistance if possible. Thanks in advance.
Message posted from http://www.ExcelForum.com/
Post a sample of what you want to do.
Your question is just a tad open ended <g>
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"DanB4105" <DanB4105.ywtpa@excelfor...New to excel
I'm new to Excel ( and to this forum :) ) and so I hope somebody may b
able to help me.
I've got 2 questions....
I've got a spreadsheet which takes data from one worksheet and uses i
to calculate data in a second worksheet using the following code
=IF('4th November 2005'!B19="","nothing here dude",IF(B19<'4th Novembe
2005'!B19,"UP",IF(B19='4th November 2005'!B19,"Same",IF(B19>'4t
The problem is, when I create a new worksheet I have...hide a row
I have a worksheet with information in column A and B.
If Column B has no information I want to do nothing, but if there is
something in Column B, I would like to hide the row.
Is this possable in an if statement?
not possible with a formula. This would require VBA
"Bob" <email@example.com> schrieb im Newsbeitrag
> I have a worksheet with information in column A and B.
> If Column B has no information I want to do nothing, but if there is
> something in Column B, ...Auto transfer of row
I have a list of components to be ordered in each row is a cell with
order number entered in it. What I want is to copy the row to anothe
sheet (which is to be displayed at goods) when the order number i
entered in that cell. Is this possible? many thanks for any help
alanled's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3094
View this thread: http://www.excelforum.com/showthread.php?threadid=57297
this could be acheived by using VLOOKUP function.
if you want a perfect soluti...Please help #8
I have Exchange 2000 and Outlook 2003 in Cache mode. Has anyone seen this or
know how to fix it?
Task 'Microsoft Exchange Server' reported error (0x8007000E) : 'Out of
memory or system resources. Close some windows or programs and try again.'
"John S" wrote:
> I have Exchange 2000 and Outlook 2003 in Cache mode. Has anyone seen this or
> know how to fix it?
> Task 'Microsoft Exchange Server' reported error (0x8007000E) : 'Out of
> memory or system resources. Close some windows or programs and try again.'
>...'top' is not a valid value for the 'vertical-align' property.
Well, it is, actually, and the resulting .chm file works properly in HTML
But it's a bit tedious getting that wrong useless error message from VS2002
on every build. (Well, not every build, it only does it sometimes actually.)
Any idea how I can persuade it to stop telling me this?
Brett Ward Limited - www.brettward.co.uk
...How to delete a set of rows depending on Value
I have two worksheets
I need Worksheet A to look at each cell in Worksheet B, if a cell exists in
Worksheet A, then I need the row deleted...
Basically I have a list of Grand list of items to do, then a list of items
already completed. I need to now remove all entries in the grand list that
have been completed.
Is this feasible or should I look at using some Unix script.
It sounds like you could use VLOOKUP to find out if the value in B exists on
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel....How do I overlay text to a row without loosing the text in the ba.
I would like to know how to give an entire row (or column) a text overlay
such as "VOID" and still be able to view the text in the underlaying row (or
Thanks in advance.
Use WordArt from the Drawing toolbar. Change the Fill to None.
"Bruce Charles" <Bruce Charles@discussions.microsoft.com> wrote in message
|I would like to know how to give an entire row (or column) a text overlay
| such as "VOID" and still be able to view the text in the underlaying row
| c...Redirect Exchange 2000 IS backup to different Exchange 2003 server
I recently added an Exchange 2003 server to the same org as a 2000 server. I
have dbs from the 2000 server that I need to restore to retrieve email from a
user whose mailbox was moved to 2003. So I need to restore the db for that
mailbox from BEFORE it was moved because when you move mailboxes you lose any
deleted items that were being saved by retention policy.
Is this possible? I'm using Veritas Backup Exec 10 but nothing in their
support KB seems to follow this exact scenario.
If it helps, the old Exch 2000 server is currently empty of users and is
ready to be uninstalled. W...Over Time Pay rate 1.51?
Its that time of year again, Audit time.
The auditors have come across a very strange problem it seems that around
October of last year random employees have had there OT pay rates increased
to 1.51 (instead of the standard 1.50), I cant for the life of me figure out
how this has come to be. Has anyone come across this problem before? And is
there something I can do to fix or prevent this from reoccurring? It’s just
not feasible to check each employee every week before payroll. Im certain
that the employees were setup correctly initially.
I have seen this and have not been ab...Change position ID in HR
We would like to change the position ID in human resources. Does anyone have
a suggestion on this.
You would need to do it behind the scenes using a tool like Query Analyzer.
Charles Allen, MVP
> We would like to change the position ID in human resources. Does anyone have
> a suggestion on this.
careful though when you change it on the background as you need to know all
the tables that use this position ID or Position Code and change it there too
otherwise all the link would be gone and you end up with orphan records that
its just the same as creatin...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@188.8.131.52>,
Burp <firstname.lastname@example.orgINVALID> 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...I need a macro
I would like a macro to do the following:
I would place the the cursor in any cell and this macro would give me the
average of all the entries to the left if the selected cell. EX: I place the
cursor in cell M12.
I want this macro on display in cell M12 the average of all the values from
Col C12 to Col L12. Note that there may NOT be entries in all the cells in
that range. Also the start point would always be col C .Thanks
You can do this easily with a worksheet_selection event in the sheet module
but you would probably want to restrict to a certain range or columns and
rows or it woul...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...Average of absolute values of moving ranges
I'm trying to get the average of the absolute values of a set of data over 8
weeks. Each week is on a seaparate sheet so to capture the moving ranges I've
been using the formula below to get my result. Is there an easier way?
=AVERAGE(ABS('Week 1'!G2-'Week 2'!G2),ABS('Week 2'!G2-'Week 3'!G2),ABS('Week
3'!G2-'Week 4'!G2),ABS('Week 4'!G2-'Week 5'!G2),ABS('Week 5'!G2-'Week
6'!G2),ABS('Week 6'!G2-'Week 7'!G2),ABS('Week 7'!G2-'Week 8'!G2))
The use of t...Help with importing data
Can I have users fill in a form in Access and have that data be transferred
and updated to a spreadsheet. Need for fill out several fields and then
export to a specific spreadsheet and place that data into the cells that will
update that cell (add to the total in that cell) of a spreadsheet.
...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...Business Portal Development
I know how to use Rational XDE, VS and the BP SDK to create new entities in
BP, but how does one go about chaning labels?
For example, if I wanted to change two labels on a requisition mgt screen:
Can I just crack open the ASPX page and change the caption property?
To edit the lables you can use front page server extensions 2003.
"Dwight Specht" wrote:
> I know how to use Rational XDE, VS and the BP SDK to create new entities in
> BP, but how does one go about chaning labels?
> For example, if I wanted to ch...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?
...How do you change the APR?
How do you change the APR in a Credit Card account? Like if you have to
change it from 13.250% to 14.240%
Depends on the version but (in M2007) go to the CC Account and click on
Change Account Settings. Scroll down to Credit Information and click on
Change Credit Details. If you want to change the Minimum payment rate/amount
as well, click on the Minimum payment amount and a side window opens.
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically ...After editing example1.xls and click SAVE, the filename changes to AABBEE.xls
After editing example1.xls and click SAVE, the filename
changes to AABBEE.xls. The original file still exist and
has been updated but the 'funny' filename also have the
same content, and editable. The example1.xls is stored in
a server and accessed by many people within the company.
Everyone accessing to the file will change the filename
unknowingly after saving it.
...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