format changes when copying from one cell to another
I'm sure this is simple, but it is not clear to me...
I am copying the contents of a group of cells that exist on one worksheet to
another. In Sheet2, I tell cell A1 that it should equal Sheet1's A1 value.
That works fine. But if the cell is blank on Sheet1, it comes up as "0" on
Sheet2. I figured it was probably assuming numeric formatting, but when I
right-click > format cell on both Sheet1 and Sheet2, both show up as
"general", so why would Sheet2 take a blank value and populate it with "0"
I gather than you are putting a formula in one...How to get TASK_ID field for summary tasks without using Project.a
I know for tasks which are not summary tasks we can get TASK_ID field using
statusing web service. But i could nto find any other options than Project
web service to get TASK_ID field for summary tasks and the top level project
Problem of using Project web service is that in my custom sharedpoint web
part where we are using PSI web services we get all the data required using
Resource and Statusing web service for the logged in resource. But Statusing
web service retrieves TASK_ID only for actual tasks and not for summary
Now just to get TASK_ID of summary tas...Move to match cells
A B C D E
1 000801025-8 009601025-3 2007 000801025-8 2007
2 000801026-9 009601026-4 2004 000801026-9 2004
3 000801028-1 009601028-6 2006 000801028-1 2006
4 000801036-8 009601036-3 2008 000801036-8 2008
5 000801044-5 009601044-0 2007 000801044-5 2007
6 000801044-5 009601055-0 2004 000801055-5 2004
7 000801055-5 009601064-8 2001 000801064-3 2001
8 000801055-5 009601091-2 2006 000801091-7 2006
9 000801064-3 009601095-6 2002 000801095-1 2002
10 000801091-7 009601097-8 1998 000801097-3 1998
11 000801091-7 009601098-9 2004 000801098-...Results from blank linked cells
I am linking cells from different worksheets in the same workbook, using the
copy/paste/link cell method. How can I get a blank space (as opposed to the
zero I am presently getting), in the destination, if the source cell is
blank. I am linking a input sheet to several forms that must be sent out,
but I don't want a form that will have a number of zeros in it.
If the linked cell looks empty, show empty, else show the value.
Mr. Anolog wrote:
> I am linking cells from different worksheets in the same workbook, using the
Project desktop expert, new to Project Server 2007 and working with a sandbox
When I use the PWA Build Team...Replace to replace a generic resource on a
project with an actual named resource after first publishing a plan, my
updates don't appear to be reflected in Project Server. If I check out and
open the Project Plan in MSP Pro, however, the updates were made, and then if
I publish the schedule, the updates appear in server.
I thought when you made resource updates using PWA that they should be
reflected immediately (or as soon as the request...Permissions is not allowing me to use my print preview.
Help! Don't understand My Permission in Excel. Even though I unrestrict, it
still doesn't allow me to Preview my documents. How do I reset?
...Case select returning error when cell contains #N/A : how must i avoid this error
Title says it all
maybe this will do what you want
If Not IsError(Range("C1").Value) Then
Select Case Range("C1").Value
"Luc" <firstname.lastname@example.org> wrote in message
> Title says it all
Thanks for your help !!!!!
"Gary Keramidas" <GKeramidasAtMSN.com> schreef in berich...Developing a robust database at one co. then using it at another c
Are there any legal implications of using the type of database listed above
to perform similar functions for another company? The 2 company's are in 2
totally different industries and the new database will have to be modified to
fit the requirements for the industry it is in. The database was developed at
the old company.
there is no such thing as a robust Jet database.
Move to SQL Server if you want to build a solution that will work for
the next decade.
Jet is and always has been depecrated
On Apr 7, 12:14=A0pm, BoaMan10 <BoaMa...@discussions.microsoft.com>
w...How to slant cells in Excel on top of chart at about 45 degrees
Trying to make a chart and slant cells at the top at about a 45 degree angle
with borders and still be able to type into it. Is this possible?
> Trying to make a chart and slant cells at the top at about a 45 degree
> with borders and still be able to type into it. Is this possible?
Try Format > Cells > Alignment Tab and set the Orientation to 45
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2...Question on multiple NICs used by Exchange 2003
I have a requirement to bind four virtual SMTP servers to unique IP
addresses. The server has four NICs and each IP address is uniquely bound
to a virtual SMTP server. I used telnet to confirm that the appropriate
virtual SMTP server responds to each assigned IP address.
In case you are wondering why I did not use virtual IP addresses- Per
Microsoft, the virtual IP address schema will not satisfy our requirement
that the same IP address be used for sending (relaying) the e-mail that
received it. Their recommendation was to have a NIC for each virtual SMTP
The problem that I am ex...retain only rows with condition that cells in column H containing "AU"
I have a large database containing columns with one column specifies
the product name. In one instances, I need to retain only rows with
condition that cells in column H containing "AU" of the entire string
in the cell. Delete those rows without it. The problem is , that the
AU of the string can appear in any position, not a fixed position.
Is there any simple way of doing it?
You can use AutoFilter. Choose the command Data, Filter, AutoFilter. Then
open the autofilter drop down in the column H and choose Custom and from the
first drop down, t...validation list or combo box dependant on cell value
Am i able to determine the values shown in either a validation list or combo
box being dependant on a value in another cell?
ie: Cell A1 = BOB then validation or combo box would then base it's list
from the named range (or whatever the solution may be) based on Bob.
if i was to change A1 to ROY then it would also change the underlying list?
I have tried everything that i think SHOULD work but that it pretty
thanks in advance
I'd start with Debra Dalgleish's site:
Richard Edwards wrote:
> Am i able to deter...worksheet labels based on cell results
How can I build a macro to use the contents of several cells in a column to
label a corresponding number of worksheets with their contents. Ideally this
would also build links to the tabs so that a user could click on a specific
cell (in that column) and be redirected to the corresponding worksheet
for labeling the tab try something like
For the second question try using a Hyperlink (Insert - Hyperlink)
> How can I build a macro to use the contents of ...Move a particular named sheet to the end.
Using macros, how can I move a sheet called TOTAL to become the very last
sheet within a workbook?
Your assistance will be appreciated.
Thank U and Regards
> Using macros, how can I move a sheet called TOTAL to become the very last
> sheet within a workbook?
> Your assistance will be appreciated.
> Thank U and Regards
Works a treat, thank you for your assiatance.
Thank U and Regards
"Barb Reinhar...How to use AjaxToolKit in asp.net for DHTML Editor
Please tell me how to use AjaxToolKit dll for DHTML purpose using
Thanks in Advance
"Deep" <email@example.com> wrote in message
> Please tell me how to use AjaxToolKit dll for DHTML purpose using C#.
...AutoFilter on Protected Worksheet
I need to protect a worksheet to prevent users from editting certai
columns. It's a log, so I would like to allow them to use AutoFilter t
sort the log. So when I protect the worksheet, I check the box tha
says, "Allow all users of this worksheet to: Use AutoFilters".
Seems pretty straightforward, but when I then go to Data > Filter th
AutoFilter selection is grayed out.
What am I missing?
Message posted from http://www.ExcelForum.com
That setting will allow users to apply filters to a table where the
AutoFilter is already turned on. However, they won't be able to...How do I create a summary page from multiple worksheets
Trying to roll-up information from multiple worksheets within the same
workbook to a summary page. These worksheets are copies of each other. For
example: each worksheet has a column labeled "defect number". The users can
record multiple defect numbers within a cell (e.g. 897, 992, 1001)
So sheet1, row1 = 897, 990
sheet2, row1 = 992
sheet3, row1 = 995, 1001, 1012
sheet4, row1 = empty
How do I (or can I) rollup this information to a summary page where sheet5
is the summary worksheet and row1 = 897, 990, 992, 995, 1001, 1012.
Here's what I have so far
[=Sta...Using the classes created with xsd.exe
I have created classes from several xsd files. These files create about 150
classes and spot checking them they do represent types in the xsd files. the
question is how do I use these files. How do I load data into them and create
xml from them. Is there some articles about this subject.
As for the classes you've generated, are they normal classes or dataset
classes? As for the normal classes you generated through xsd.exe, you can
use XML serialization to convert those class instances into XML content or
deserialize the XML content back into objec...IN EXCEL, WHEN I CLICK ONA SINGLE CELL It HIGHLIGHTS WHOLE Page
"confused" <firstname.lastname@example.org> schrieb im Newsbeitrag
> please help
Just click on a cell and nothing else?
Or perhaps you mean click on a cell then as you move the cursor around other
cells are selected like the cursor is stuck?
If the former, you must have some event code which selects the cells or you
are clicking on the gray box at intersect of rows and columns(top left above
ro...File Naming for Picture Order
I want my photos within a folder to appear in a certain order and want them
in numberical order; however, when I put them in numerical order and get past
9 (into 2 digit numbers) the order gets all whacky.
> I want my photos within a folder to appear in a certain order and
> want them in numberical order; however, when I put them in numerical
> order and get past 9 (into 2 digit numbers) the order gets all whacky.
1, 2, 3,.....10, 11, 12...
0001, 0002, 0003,.....0010, 0011, 0012
If you are batch renumbering the f...Output to excel ==> replace worksheet
Usually out to excel will replace a workbook.Can we make it
to replace worksheet only.Thank's
"shiro" <shiro@myname?.com> wrote in message
> Usually out to excel will replace a workbook.Can we make it
> to replace worksheet only.Thank's
How about, just replacing the contents of a cell, or cells?
Dim appXL As Object
Dim wkb As Object
Dim wks As Object
Set appXL = CreateObject("Excel.Application")
Set wkb = appXL.Workbooks.Open("C:\MyFolder\MyWorkBook.xls")
Set wks = wkb.Worksheets(1)
wks.Cell...Help with cells auto formatting
I have posted a similar question before however I never really got this
sorted so sorry for repeating myself.
Basically I use two spreadsheets daily at work all with various information
on and various formats in each Column. My problem is when I close the
spreadsheet and reopen it the cells that are formatted as 'general' or
'number' turn into Euro currencies.
Does anyone know why this happens or how I can stop it? The spreadsheets
aren't stored locally they are stored on a serve that only myself and my boss
can get onto and we both have the same p...Displaying Sheet Tabs Names in Cells
Can anyone tell me if there is a way for me to display the Name of a Sheet
Tab in a cell.
Take for example I have 4 worksheets, labelled Shawn, Kevin, Mary, & Data.
In data, I want it to show the name of the worksheets. So in Cell A4 I
would like it to say Shawn, then in B4 I can put Shawn's data in. Is there
a function or a formula that allows me to do this.
Thanks for any help.
Maybe this UDF will do for you.
Public Function TabI(TabIndex As Integer) As String
TabI = Sheets(TabIndex).Name
Insert the function in...help with Excel Chart, Series name
I am using ORACLE OLE2 package to print a series bar graph in excel. I need
to rename "Series Name" that comes out in as a char in excel. By defual the
series are names as Series1, Series2, Series3,.....SeriesN. How can I access
the handle to "Series Name" which help me change its name. Any help will be
Manally, you do this with Chart - Source data - Series tab. There's a
series name box. Select the series to be edited in the drop-down at the
left first. It may have a cell reference currently in it, or you can...mapping keystroke to a cell
I would like to map a keystroke to a cell and have it add up the number of
times the keystroke has been applied.
For instance if I touched the A key 3 times it would give me the value of 3
in one cell. If I touched the B key 2 times it would give me the value of 2
in another cell.
I'm thinking of using this in a laboratory situation. Where I could count
the different types of blood cells under a microscope using the keyboard.
Once I reached a total of a 100 diffent types of cells it would play a .wav
file that would alert me that the count of 100 had been reached.
Using a differ...