Identical Name on multiple workbook pages
As a hardened Excel/VBA nut, I'm probably going to be really embarrased when
I get the answer to this, but here goes...
I have a workbook containing a worksheet that records weekly data. I have a
named range ("Data") which I select then clear, via GoTo.
Each week, I copy the latest week's worksheet and create a new worksheet for
the new week. And each week, I select the range "Data" and clear it in the
most recently created worksheet.
the thing is, I always thought that Range names were unique across a
workbook, and that you couldn't have the same Range N...Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that
have subtotals associated with them (automatically generated via the
pivot table). I need to to take the subtotals for 2009 and 2010 and
calculate the % difference.
Here's a screenshot of what I'm talking about:
Is this even possible or am I going to have to do this manually?
Hi I have'nt seen the screenshot as am at work , go to Pivot
>This is what I need to do: I have rows of ...New workbook/sheet defaults
I'm using Excel 2003 and have put two files Book.xlt and Sheet.xlt in the
startup folder whose path is specified in:
Tools|Options|General|At startup open all files in:
Sheet.xlt works fine for adding new sheets and Book.xlt works fine for new
workbooks created by clicking the New icon on the Standard toolbar, but not
if I create it using File|New then select Blank Workbook from the New
Workbook task pane or if I click Templates|On My Computer then select
How do I have these actions use the Book.xlt and Sheet.xlt files that I've
created for the purpose?
I would p...PIVOT tables and publishing thrm on a webpage
Is there a way to publish a pivot table in a html page but still kee
exactly the same funcitonality that you have on a Excel spread sheet
either by converting it to a java applet or something else . Any hel
would be much appreciate
Message posted from http://www.ExcelForum.com
...Is it possible to export Excel sheet data to..
Subject: Is it possible to export Excel sheet data to..
Is it possible to dump Excel sheet data to Access DB in real time (or once a minute or so, or per calculation event or other event)? if so - how?
You may be able to use a linked table in Access. File - Get external data -
Link tables. The data is kept in the Excel sheet, but can be used in Access
as with any other table.
"avinoam.aharoni" <avinoam.aharoni@SupportX.com> wrote in message
> Subject: Is it possible to ex...Insert Rows in Balance Sheet Template
Using Excel 2002 I cannot find a way to insert/add additional rows to the
existing 12 rows allotted in the Balance Sheet template. I learned from
another question that I can Ctrl+D to copy the formulas down to blank cells
to keep the balance going, but no way to add more rows, since the template is
so short. Rows is greyed out on the Insert menu, and Nothing comes up on a
right click. Can you please help me. Thanks.
Try unprotecting the sheet and they should work.
goober's Profile: http://www.exce...Pivot Table question #4
I have spreadsheets that take data via a pivot table from an OLAP cube that
is held on a terminal server.
The spreadsheets hold figures entered by me and figures obtain from the
I want to enable the automatic update on the pivot table but the pivot table
is sorted by a project number obtained from the OLAP cube. My problem is if
a new project is added to the OLAP cube then it is automatically selected
from the drop down list. I want to be able to turn this off so that it only
selects the project I have previously chosed. For example if I have selected
the filter nu...add a header and or footer to all sheets/tabs
I have a large workbook that I need to add a header and footer to each
sheet/tab. I do not want to have to go to each sheet and do this, there are
grapghics and propreitary notes, etc. it would be a lot of work to have to go
to each sheet.
Can I add the header and footeronce and have it apply to all sheets/tabs in
the workbook? Please advise ASAP. Thanks for any help you can provide.
Group the sheets first. Right-click any sheet tab, and hit Select all
sheets. Don't forget to ungroup when you're done!!
"Sharon" <Sh...how do Ii remove the grey page numbers in a work sheet
how do Ii remove the grey page numbers in a work sheet
Try going to the View menu and unchecking Page Break Preview
On Wed, 2 Feb 2005 11:01:08 -0800, "parker1230"
>how do Ii remove the grey page numbers in a work sheet
You may be in page break preview mode.
Go to "View" and select "normal"
"parker1230" <firstname.lastname@example.org> wrote in message
> how do Ii remove the grey page numbers in a work she...Allen Browne Client Search Multiple Like Statements
I need to have this code search multiple fields, but I keep getting
"Expected end of statement" on the Me in the second to last line:
If Not IsNull(Me.txtFilterMainName) Then
'strWhere = strWhere & "([MainName] Like ""*" & Me.txtFilterMainName
& "*"") AND "
strWhere = strWhere & "([Address1] Like ""*" & Me.txtFilterMainName
& "*"") OR " & _
strWhere = strWhere & " ([StreetName] Like "" * " &
Me.txtFilterM...opened Excel w/sheet from email attachment, updated, saved & cant
I emailed an Excel worksheet from my office to my home - opened it from my Outlook Express folder - updated file extensively - saved several times during the four hours I worked - closed & now can't find the updated file. I forgot I had opened it from the email and never saved it to my C drive. However, I saved it several times while I was working on it. Shouldn't the file in my email be the updated saved file? It's not and I can't find it anywhere. I believe this happened once before to me.
Any suggestion would be appreciated. I've lost a lot of work if the file...Support of multiple users in Outlook?
Palm convert here with a question.
In my Palm desktop I was able to separate my Notes, Calendar, Tasks, etc.
from my wife as a separate user. We both had palm devices and each
maintained separate schedules on our devices and on the desktop.
How do we do that in Outlook?
"John" <email@example.com> wrote in message
> Palm convert here with a question.
> In my Palm desktop I was able to separate my Notes, Calendar, Tasks, etc.
> from my wife as a separate user. We both had palm ...Multiple POP accounts in Outlook 2003
I have multiple POP accounts on my Outlook 2003 client. How do i
setup Outlook to save mail from the multiple POP accounts to different
folders so that it makes it easier for me to sort out my mail? TIA!
you'll need to use rules... or use search folders configured for each
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: ...Do Pivot Tables have an automatic data range expansion?
As I add new rows of data to my data base, my pivot table will not expand to
include them after refreshing. Is there any way of setting the pivot table
to include the entire database regardless of its continuously growing size?
Right now, as I add a new row of data I must delete my old Pivot table and
create a new one from scratch. Is this normal?
You can use a dynamic range that grows/contracts with your data.
Debra Dalgleish explains it all at:
> As I add new rows of data to my data base, my pivot table wil...Calculate from another sheet
If i in a sheet have
a1=1 , b1 =2 , c1 = 3 , d1 = 4, e1 = 5 and so on
a2 = 100, B2 = 100, c2 = 100 , e2 =100 ans o on
Then in another sheet
i write maybe 4
then i want a cell there have a sum from 1 to 4
In this case from a2 to e2
if I write maybe 2
The a sum from a2 to b2
Can i do this?
If 4 is A2 to E2, and 2 is A2 to B2, presumably 3 is A2 to about half way
between C2 and D2?
It sounds as if you want the OFFSET function; details in Excel help.
"alvin Kuiper" <alvinKuiper@discussions.microsoft.com> wrote in message
new...How to add multiple message senders to the blocked list automatica
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
...How do I create a spread sheet for tracking batting statistics?
Trying to keep a running log of batting stats for the season. Can anyone help?
> Trying to keep a running log of batting stats for the season. Can anyone help?
...Transfer combined investment transactions to multiple new accounts
In Money 2005 Deluxe, I have an investment account (with related cash
account) with about two years of transactions. This mutual fund account (TRP)
uses a separate account number for each mutual fund holding so that when I
upgraded to Money 2005 and set up on line services for this account it
downloaded each mutual fund investment as a new account. I can't merge all
of these duplicate accounts in Money as it only allows you to merge one time
so I then transfered (using copy) all my investment transaction from the
combined existing account to each of the new individual investment ac...COUNTIF
I need to calculate how many same products are chosen in a table from
validated data to show a tally (using 2 sheets, 1 v/data & Tally List [Sales
Sheet] and 1 v/lookup [Data Sheet]). I've tried SUMIF and COUNTIF but didn't
seem to work at all on the v/data sheet unless I stuffed up, but where?
How do i calculate how many "Blue" items are listed each time a Blue item is
added to the Sales Sheet via combo/lists? Each time a new item is listed, it
will automatically appear in the tally list as a new item and/or count tally
of appearences sorted by ranking. There are ...Splitting multiple cell contents from 1st column into 4 columns
n my first column I have 4 cells (1-4) (5-8) etc. with general content.
The content from each of these 4 cells needs to be placed in a separate
column to make a list that I can sort etc.
Example: COLUMN A
2 Heatherridge Road #301
3 Harry Smith
4 H25 Condo Fairfax Place
6 McGrath Street # 56
7 Mary Jones
8 B45 Condo Lemon Circle . . . . . . and so on and so on
every 4 cells.
I have hundreds of 4 cell descriptions. I just can't do this one by one.
Can anyone help, PLEASE, PLEASE. I am really a novice at Excel though I
use it for e...Receiving duplicate emails 01-20-10
In Windows Live Mail I'm receiving the same emails over and over again. This
only happens to my pop3 accounts in Windows Live. I've looked at the
properties on both pop3 accounts and the "Leave message on server" box is
unchecked. This problem just started within the past 36 hours. I delete the
same ones when they come in each time but as the day goes on I'm receiving
dozens and dozens of repeating emails as well new ones which then become
I've checked the emails on my server and they are not doubled or tripled, etc.
HELP! Anyone have a solut...Merging to-do/task lists from multiple inbox folders
I am using Outlook 2007 and am trying to figure out how to merge to-do/task
lists from multiple inbox folders. I have my inbox associated with my name,
and then also a folder with my name that is associated with another inbox
that is used by several people on one project. (When emails come into the
latter folder, I sort the ones that I can deal with into the subfolder with
my name.) For my personal inbox, I can flag emails and they will pop up in my
to-do box, but when I flag things in my sub-folder they don't show up in my
to-do box, and I can't figure out where t..."A Formula or sheet..."
Windows Vista Ultimate - SP1 RC1
Office 2007 Professional
When I try to copy a worksheet I get the following:
"A formula or sheet you want to move or copy contains the name '_XXXX',
which already exists on the destination worksheet. Do you want to use this
version of the name?"
This messages appears many time before the sheet is finally copied. I have
been clicking the yes button and the task is completed. Is there a
work-around, or add in, that allows me to go in and delete all these names
so I can just copy the sheet w/o all the extra effort. It seems to me I ran
i...Fixed Assets GP 10 Security
I have added the Fixed Asset module to GP 10. I have added the FA_DEFAULT
Role to users who will be using FA. When I go to Cards the Fixed Asset menu
option does not appear. The only people who do see it are the Power Users.
What step am I missing?
FADEFULT_USER task will only provide access to set of FA lookups and few
other options. You have to set security task for Users seperately for each
window and other accesses by going to Security Tasks, Roles and then to Users
"Rich Wheeler" wrote:
> I hav...Comments & protected sheets
I'm guessing I already know the answer to this, but is it possible to leave
comments on a protected sheet?
Did you mean add/edit/delete comments on a protected sheet?
If yes, then there's an option to protect (or leave unprotected) objects when
you do Tools|protection|protect sheet that you can choose.
> I'm guessing I already know the answer to this, but is it possible to leave
> comments on a protected sheet?