Excel 2007 Pivot Tables Custom Style SheetsIs there a way to create a custom style sheet and have it available to
all pivot tables in various spread sheets.
...
Comparing-Merging Two FilesIs there any way to take 2 similar files and find what changes you have added
to one and combine it with the original?
denny,
Just saving the new file using the old file's name will do that.
Or are you talking about file sharing, where more than one person can work
on the workbook at the same time?
Henry
"denny" <denny@discussions.microsoft.com> wrote in message
news:11A8050C-2565-4AF2-BDA3-971D91FC013D@microsoft.com...
> Is there any way to take 2 similar files and find what changes you have
> added
> to one and combine it with the original?
"H...
table not updatedi have a form/subform that i have added a new field to, netamt. I added the
field to the table, then added it to my query, then added it to my subform
that is in my form. The field is set to currency and has =Nz([Quantity],0)*Nz
([UnitPrice],0) as the ControlSource. The number in the subform is not
updated in the table? Why is this? I dont need this number to show on the
form, just on the Report.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200706/1
"stephendeloach via AccessMonster.com" <u32891@uwe> wrote in message
...
Excel Pivot Tables #3I have been able to reduce the file size by unclicking
the option "save data in pivot table". I can't seem to
find an article on the web that will explain to me if I
will lose functionality of the pivot table if I turn this
option off.
Can you help?
As answered at your other post:
You won't lose the functionality, but it may take longer to refresh the
data. There's information in the following MSKB article:
How to optimize PivotTable performance in Excel 2000
http://support.microsoft.com/default.aspx?id=273583
Mandy wrote:
> I have been able to reduce th...
compare two columns and pull out differencesI have two columns of numbers. I want to know the numbers that do not have a
match or are not in both columns. But I need all of each column to be
compared to all of the other column...not cell by cell. It would be great if
I could pull out the differences and put them in a different column. Looking
at two long lists of numbers to pull out the different number is very time
consuming! Thanks for any help you can give me!
To check column A against column B:
=IF(ISNUMBER(MATCH(A2,B:B,0)),"",A2)
vice versa:
=IF(ISNUMBER(MATCH(B2,A:A,0)),"",B2)
Any number lis...
Why do inline tables disappear when automaticallyshifting or resizPublisher 2003
Scenario: I have a parent table which contains a list of inline tables
arranged vertically in one of its cells.
Problem: Any time I perform an action that requires one of the inline tables
to shift position (ex. adding text above/below it) or automatically resize
(ex. adding text within it) the entire page layout disappears. I can cause
the layout to reappear by selecting to view the Master Page (View->Master
Page) then selecting to hide it.
Thank you.
Slide the acceleration down on your video adapter, control panel, display folder,
settings tab, advanced button, ...
Count cells with specific text between two dates?I have the following formula
=COUNTIF(Orders!D:D,"*Stood Down*")
How do I modify it to count text between two dates which are in cells:
Orders! H3
Orders! I3
Hi,
You told us where the date criteria are but not where the dates are on the
worksheet so I have assumed ORDERS!C:C
In additiona, unless you have to cut backk the range from full columns to
something more closely matching your dataset
=SUMPRODUCT((Orders!C:C>=H3)*(Orders!C:C<=I3)*(ISNUMBER(SEARCH("stood
down",Orders!D:D))))
--
Mike
When competing hypotheses are otherwise equal, adop...
Using subtotals in Pivot table formulasThe set up:
Our legacy database provides 30 different report types that our
clients can run from our website.
I have a spreadsheet listing every report run by customers over the
past 2 years; including unique ID#, Client name, report name, User
name, Year, Date, Time, etc.
The Pivot Table:
My pivot table is set up as follows:
- ClientName, ReportName, and Username as Row labels
- Year as Column Label
- Count of ClientName as value
- Count of ID# shown as "% of column" as another value
The pivot lists ClientName in column A, ReportName in column B,
Username in C and the count of Clie...
VLOOKUP & table array selectionI hope someone can help me. Is there a way to select the table array i
VLOOKUP from a cell reference? Cause i can't figure out how to do it.:
=VLOOKUP(A6,'MY WORKSHEET'!1:65536,27,FALSE)
Where MY WORKSHEET would be a ref from A
--
Message posted from http://www.ExcelForum.com
Hi
try
=VLOOKUP(A6,INDIRECT("'" & A1 & "'!1:1000"),27,FALSE)
Frank
> I hope someone can help me. Is there a way to select the table array
> in VLOOKUP from a cell reference? Cause i can't figure out how to do
> it.:(
>
>
> =VLOOKUP(A6,'MY...
Can i view two inboxes at the same timethe question says it all.
I have a main account at work that people can specifically e-mail me, but
because i am an admin assistant another has been set up so people can e-mail
that one to ask me to do certain jobs and order stationery etc. it is used
between 3 people to see the content. i was wondering if there is an option to
have my personal e-mail for work and the admin assistant one open at the same
time
Is the secondary mailbox added to your profile or do you just have rights to
see and respond to the in-box? What version of Outlook and have you asked
your mail admin at work to...
Entering 2 incomes, one self-employedMy wife's income is from an employer, who withholds taxes. I am
self-employed, so my freelance income has no taxes withheld.
What's the right way to enter the income(s) in Money? Should my wife's be
entered as Paycheck-->Net Pay?
I plan to use Money to estimate quarterly withholding taxes for myself, but
do not want my wife's income included in that calculation. Do I need to
specifically label income as either hers or mine? Or will Money know that
"Net Pay" has already had taxes taken out?
Thanks for any help.
Use the paycheck wizard for your wife. Con...
How do I best pass data between two programs.I have a program that receives data from a serial port. No transmit. I want
to build a separate program that will run on the same PC that also needs to
receive the same serial port data. No transmit.
I figured one program would pass data to the other program. I could use a
TCP socket to localhost. This would be easy. Is there a better way?
"Paco" <paco_beams@gmail.com> wrote in message
news:UbwLi.1053$ua4.736@newssvr22.news.prodigy.net...
>I have a program that receives data from a serial port. No transmit. I want
>to build a separate program that will run on th...
select only companies having more than one unique zip code?In the following list I have 4 different companies -- 'abc', 'bcd', 'cde',
and 'def'
'abc' is listed 4 times and contains 2 different zipcodes, 'bcd' is listed
twice but only contains one unique zip code, 'cde' contains 3 different zip
codes, and 'def' is listed only once with one zip code. I need to select
companies 'abc' and 'cde' because they contain more than one unique zip code.
What is the tsql to accomplish this kind of query?
create table #tmpA(rowID int Identity(1,1), Co varchar(50), zip ...
yet another: which is faster table or query ?using A2k;
seen LOTS of posts about this topic, but none seem to address the
heart of my question.
Let's break this into 2 parts: queries (stand-alone); and form data
sources (and control data sources)
queries - stand alone:
Let's say I have a query (#1) that relates information in 3 tables.
Now I want another query (#2) that uses that same information, and
relates it to more tables.
Would query #2 be faster if it uses query #1, and relates that to more
tables;
OR would it be faster if it had all the table relations in query #1
built into it (not use a query inside a query) ?
---
...
Relating One cell Value to another to the left of it.Below is an extract from an excel spreadsheet I am
currently working on. There are three columns, one with
standard hours (Stnd Hrs.) one with Overtime hours (Ovtm
Hrs.) and one with an Overtime Code (Ovtm Code).
Sunday
03-Aug-03
Stnd Hrs. Ovtm Hrs. Ovtm Code
7 2 A
7 3 B
5 3 C
5 3 C
3 6 F
4 2 D
5 6 B
4 3 A
0 ...
transfer data from one text box in a form to anotherhow do i transfer data from one text box located on a form to another text
box located on a sub-form on the main form. complicated i know.
what vba code do i use.
any solutions
thank you
you need to specify if you want to make the operation after which event in
subform.
then you need to put something like this:
[textboxinsubform] = Forms!FormName![texboxinform].text
LD
--
Lorenzo Díaz
Cad Technician
"vss85" wrote:
> how do i transfer data from one text box located on a form to another text
> box located on a sub-form on the main form. complicated i know. ...
how to change font size of datalabels of two charts in a sheet
hey guys
i have two charts in a sheet
how to change the font size and AutoScaleFont of datalabels in them
through VBA??
--
amrezzat
------------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28766
View this thread: http://www.excelforum.com/showthread.php?threadid=540051
The required syntax is discoverable using the macro recorder. The final
result would look something like this:
For Each chtob In ActiveSheet.ChartObjects
For Each srs In chtob.Chart.SeriesCollection
If srs.HasData...
Pivot tableWhen I create a pivot table by using wizard, I drag fields to the diagram. For fields contained numbers, sometimes it appears to be sum of xxx and sometimes it defaults to be count of xxx. I know I can change it by double clicking. I'm not sure if there is a way to default it to count or sum.
Thanks, Lily
If all the data in that field are numbers, then you'll get Sum.
If any of the data is text (or blank), then you'll get Count.
I don't think you can change this behavior.
Lily wrote:
>
> When I create a pivot table by using wizard, I drag fields to the diagram...
question on narrowing a query or report by one fieldI have a query that pulls 6 columns out of a table. These columns are:
Record #, Date Issued, Part #, Qty Rejected, Comments, DMR Complete. In the
table, the DMR Complete field is a text field with either 1(yes) or 0(no). I
am wanting to have a report that only shows the records that are not
closed...or 0 in that field. How and where (in the query or report) do I do
this? Any help is greatly appreciated.
Open your query in design view and in the grid row named Criteria under DMR
Complete enter the numerial 0 (zero).
--
KARL DEWEY
Build a little - Test a little
"SteveP"...
How can deleted data reappear in a refreshed pivot table in ExcelI am using Excel 2003. I have a worksheet full of data and built a pivot
table on another sheet (within the existing datasheet). Nothing too
complicated.
I updated my data by pasting new data over the top of the old data and
updated my pivot table.
The problem is that in the pivot table one of the fields still allows me to
select on data that no longer exists in the data. More specifically, I have
a column in the base data entitled "Vendors" and have approximately 20
different vendors that appear throughout the data. When I update my pivot
table, in the vendor select...
How do i compare two excel sheet and get it to show me diff.How to do do a differences check of two excel sheet of two different version.
Can Excel shows and direct me to the cell or format that has change from the
original copy
Maybe you could use a program written by Myrna Larson and Bill Manville.
You can find a copy on Chip Pearson's site:
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla
Sky Yeo wrote:
>
> How to do do a differences check of two excel sheet of two different version.
> Can Excel shows and direct me to the cell or format that has change from the
> original copy
--
Dave Peterson
Hi Dave,
I h...
Trying to mimick having two Exchange account in Outlook 2003I'm building an SBS2003 server for a client of mine who has a unique mail
requirement. This is about my my eighth SBS build. I've already searched the
newsgroup and found several people ask 'How can I receive email for two SMTP
domains?" That part's easy. I've also seen several people ask, "How can I
send from two addresses?" That's also not difficult. Here's the hard part:
Summary:
They currently have their mail hosted externally and each client POPs from
two mail servers, one for each company. We want to move their mail to
Exchange, but they ...
can i save one value in a table but print a different value in a .i want to save a value such as "wnl" in a table but print out a meaning in a
report for example " well developed, well nourished in no distress" to
decrease the amount of data stored for each patient.
Access 2007
One solution is to create a lookup table with an ID field and a text field.
Store the long text strings in this table, but only store the ID in the
original table. Then use a query to produce the data by linking the two
tables.
"sheepsrn" wrote:
> i want to save a value such as "wnl" in a table but print out a meaning in a
> re...
Copying data from one Word field to another with Tracked Changes on, but this deUsing a 2003 Word form document, I have two fields on the first page that I
want to auto update to corresponding fields on a second page. I set up a
{REF} field on page 2 and set the form field to calculate on exit. It works
perfectly after protecting the document, entering the page 1 fields, and
exiting the fields. However, when I switch on track changes and protect the
document, the {REF} fields on page 2 are deleted as soon as I enter something
in the first form field on page 1. Sometimes one is deleted, sometimes both,
and sometimes the markup shows "deleted" and someti...
Delete a Table StyleIs there a way to delete a table style? They do not show up in the
Style pane and the Apply Style pane has no delete button.
You cannot delete the built-in table styles; this applies to all kinds of
styles in Word.
To delete a custom style, do the following: First display the Styles pane
(Ctrl+Alt+Shift+S). Then click the Manage Styles button. In the dialog box,
click the Import/Export button. Word displays the Organizer dialog box. You
should see the styles of the active document in the left pane. Select the
ones that you want to get rid of and click the Delete button.
--
...