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...String Table (VC6 IDE)
I have strings in English language in the "String Table" of my project
(myProject.rc). I'm loading them using:
Now, I need to internationalise my app. How can I do that? How can I add
support for multiple languages? Which is the best way to do that?
>I have strings in English language in the "String Table" of my project
>(myProject.rc). I'm loading them using:
>Now, I need to internationalise my app. How can I do that? How can I add
>support for multiple lang...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
&g...Reformat data to vertical format
Here is what I am trying to do.
I have about a thousand records that I need in a vertical format with
normal shared field name. Any suggestions
Psydwaze's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2437
View this thread: http://www.excelforum.com/showthread.php?threadid=37965
Creating a Spreadsheet from Database data (#dbdata)
http://www.mvps.org/dmcritchie/excel/snakecol.htm...pivot table %
I have 2 columns in a pivot table - decription and
amount. I need to calc a % of each value of the total.
I don't know how to do that.
...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" <email@example.com> wrote in message
> Title says it all
Thanks for your help !!!!!
"Gary Keramidas" <GKeramidasAtMSN.com> schreef in berich...Controlling printed records when report bound to multiple tables
I created a report that uses the control from a form to generate a report
based on that record's primary key. This form also has a subform which has
relationships tied to the primary key for record identification and is linked
to the main table. When preview the report the data from the subform either
does not show up in the preview when using the filter
[control]=[form]![control].[value] or makes multiple copies of the report
equal to the number of entries in the subform's table.
Is there any way around this? I have tried queries but have not found a way
to use a f...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...Line Graph with two different data points
I am trying to create a line chart with numbers from my product Vs a
competitor. The problem i am having is how can i make a chart that will have
four data points comparing to each other? For example
Product A- 1.5 1.2 1.6 1.8
Product B- 2.0 1.1 1.2 1.3
Product A- 70% 20 % 30% 67%
Product B- 65% 30% 65% 55%
How do i get all of these numbers on one chart? Is a line chart correct. I
want to see these numbers compared??
Thank you so much
Since the number don't appear related to the percentages you might plot them
on the same chart but two different axes. If they were relate...Query cross two table
I have two tables, tbAdmission and tbCode. In my tbAdmission, I have Code1,
Code2 and Code3. In my tbCode, I have Code, Description1 and Description2.
In my Form, frmAdmission, I have txtCode1, txtCode2 and txtCode3 that are
all bounded to tbAdmission. And txtDescription1Code1, txtDescription2Code1,
txtDescription1Code2, txtDescription2Code2, txtDescription1Code3 and
txtDescription2Code3 that are unbounded and only for displaying the
txtCode1, txtCode2 and txtCode3 all refer to Code in tbCode to retrieve
Description1 and Description2 for displaying in the unbou...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...Data changes when Analyzed with Excel
I have a query with 3 tables that represent master item list, count qty and
as qty. When I look at the results in Query, all is well and accurate yet
when I select Analyze with Excel, values change. For example, if a record
shows zero qty in the as of field and zero quantity in the count field, I get
a value in one or both of the fields that origianlly were zero. Other than
linking the tables and grouping by master item list (to show all parts
regardless of qty's), there are no formulas or expressions in this query.
One of the tables is linked to a FoxPro table via ODBC driver.
...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 ...Conversion Errors Table
I'm new to working with Access, I just converted an Access 97 databas
into Access 2002. It tells me there were errors, and to look at th
Conversion Errors Table. But nowhere in the message or in the MS Hel
is there anything telling me where to find this table. Can someon
pshaw's Profile: http://www.officehelp.in/member.php?userid=493
View this thread: http://www.officehelp.in/showthread.php?t=125029
Posted from - http://www.officehelp.i
I'd expect to find it in the new...Transferring Field from Existing Table/limitations and change of d
Thank you in advance for your help! I have two Excel spreadsheets that I
successfully imported into Access 2003 and created tables for. I need to add
the field from one table to the other, but there is not a direct match in the
relationship. The large table uses the Employee ID as the primary key. The
smaller table contains one field that lists a subset of these Employee ID
numbers (a selection of certain employees). I need to transfer this field to
the larger table, but I do not know how to tell Access to match up the
corresponding numbers (i.e., the large table lists all employees, bu...Access 2007 combobox will not "Auto expand"
I have a database converted from access 2003 to 2007. Now ALL comboxes will not allow the "autoexpand" functionality.
Obviously I set this property to yes (both in the properties window AND programmatically).
Most, but not all, of the comboboxes are populated by queries on ODBC coupled MSSQL tables. Again, in 2003, this worked fine.
Anybody an idea ?
Thanks in advance for any suggestions,
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-
...when i save a file that i have worked on, excel7 closes down work.
i have recently purchased office pro 2007.
Excel 2007, when i save a filethat i have worked on, excel closes down and
work is lost, done all updates, re installed from disc, please help i have
lost 2 hours of work this moring that i need for a report
a few questions:
1. what happens with save as?
2. what happens in safe mode? (hold shift key while starting excel)
3. do you have add-ins?
4. what operating system? x64?
"rob" <firstname.lastname@example.org> wrote in message
news:0483F09B-3289-42B4-8849-0C0A61380B11@mic...if value not found in table ?
I need to display a msgbox if a value is not found in a table.
If value not_in table.field then
I know that code wont work is just an ilustration of what i am looking
Thanks in advance
Use DLookup() to see if the value is in the table.
If it's not found, the result will be Null.
So, use IsNull() to test the result.
Here's how to get your Dlookup() expression working:
Getting a value from a table: DLookup()
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access us...IN EXCEL, WHEN I CLICK ONA SINGLE CELL It HIGHLIGHTS WHOLE Page
"confused" <email@example.com> 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...Auto Filter not working
I have a strange problem which occurs from time to time whereby I am unable
to activate the Auto Filter function on a list. The filter buttons simply do
not appear! Does anybody have any idea why this might happen??
Is the worksheet protected?
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Chris Jenkins" <firstname.lastname@example.org> wrote in message
> I have a strange problem which occurs from time to time whereby
I am unable
> t...report prefiltering does not work for custom entity
Please help. I've been trying for days but can't get the reports prefiltering
to work for my custom entity.
I created a simple report with the CRMAF_ prefix and deploy to the CRM
server. The report works fine and display all data OK. Except the pre filter
does not work i.e. the "Edit Filter" button does not show.
My question is: Does report prefiltering works for custom entity?
I saw a lot of posts regarding this topic and tried all the suggestions i
could find, but still no luck.
I tried the microsoft tutorial in creating a prefilterable report base on
the account...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...