can i carryover data automatically from page to page and how?
I am trying to set up a month-to-month data sheet. Can I set it up so that
the accumulated total from one month carries over to the next?
"JimVT" <JimVT@discussions.microsoft.com> wrote in message
>I am trying to set up a month-to-month data sheet. Can I set it up so that
> the accumulated total from one month carries over to the next?
Of course - at the top of sheet 2 in the required column type in
=Sheet1!(Cell the total is in on sheet 1). if you are uncertain as to how to
...Changes to the global template
Recently I had to start a new username because of some corrupted files. I
was able to save my documents.
However, everytime that I quit microsoft office a dialogue box appears and
"Word cannot save changes to the global template because it was opened with
read only access. Do you want to save the changes in a template with a
Initially I tried to save it, because I was afraid that the changes to my
document would not be saved. Now I click save, and the next dialogue box
"Microsoft Visual Basic"
"Run-Time errror "5995"
Word c...Split Forms
Is it at all possible to hide the Data Sheet portion of a split form at run
time in 2007?
The only solution I have found is to play with the SplitFormSize property,
but I am afraid that it does not support different display sizes.
Any suggestions ?
...Excel data disappeared after getting message about compatibility M
I tried to save changes to a spreadsheet, and received the following message:
"Compatibility Report for New Customer List.xls
Run on 4/6/2010 19:52
The following features in this workbook are not supported by earlier
versions of Excel. These features may be lost or degraded when you save this
workbook in an earlier file format.
Minor loss of fidelity
Some cells or styles in this workbook contain formatting that is not
supported by the selected file format. These formats will be converted to the
closest format available."
I clicked OK, because fidelity is not imp...Synchronize data across 2 sheets
Excel 2007 Workbook with a sheet called 2010 around 700 rows/records and a
sheet called Previous around 5000 rows records.
Both have 31 columns and identical column headers
On the 2010 sheet there are records that have changed, how do I get the
changed records details onto and overwite the same record on the Previous
Not sure if it would help but each record has a unique reference number.
How do i do this ?
Hope this makes sense
thanks for any help offered
If you know which colums are to be changed I would use vlookup function.
Vlookup(lookup valu...Language change in outlook express
I cannot change th language to english in outlook express by defult it has
please help me how to change in options. i check all my regional settings
shows english(us) execpt in word and express.
nishkrish <firstname.lastname@example.org> wrote:
> I cannot change th language to english in outlook express by defult
> it has French.
Ask in an Outlook Express newsgroup.
Brian Tillman [MVP-Outlook]
Ask in the Outlook Express newsgroups
Outlook Express with IE7
http://www.microsoft.com/co...Querying Excel data without another program
I'm an intermediate user of Excel, but I have lots of experience using
Access. If you can give me clues on how to handle the information below
using only Excel, I'd be grateful!
I have a spreadsheet in Excel 97 in which there's a Worksheet named,
"Datasource" with a column "B" containing repetitive data.
I'd like to create a new worksheet in the same Excel file which shows a
single instance of each item used in Column "B".
If I were writing the query in SQL, I'd say
"SELECT DISTINCT [Column B]
FROM [MySpreadsheet]![Datasource...How to total cells in a range with data input
Greetings to all members
I am running Excel 97.
An office colleague presented me with an issue that might be of interest to
any Excel whiz and seasoned programmers. I would certainly appreciate any
pointers in solving it. So here goes.
The set of values includes 33 cells ranging from B4:D14. The data type is
numeric. Data is only input in a few cells.
What would be the function to enter in, say, cell A15 to indicate the total
number of cells in range B4:D14 that have received data input? Or does it
involve some behind the scene VBA programming?
B6 = 9 C9 = 4 D11 ...Insert Data From Multiple Worksheets Into One (With Criteria)
Ok, I have created a sales report list that tracks what customers we are
contacting, how we are contacting them, if they are a new or existing
customer and if we sent a quote, along with some other details. There is a
worksheet the salesmen fills out for each day of the month (its linked to a
calendar) and that all goes into a "dashboard" that shows the breakdown with
graphs. Now what i would like to do is have another worksheet list all the
customers that we sent quotes to so they can mark if the quote was won or
lost , state sales projections and give reasons why won ...change direction of cursor after enter
In excel 2003, how do I change cause the cursor to go the next cell to
the right, rather than to go to the cell below? Thank you!
Tools > Options > Edit > Move selection after Enter > select Right.
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"duke" <email@example.com> wrote in message
> In excel 2003, how do I change cause the cursor to go the next cell to
> the right,...How-To: Last change date on row
When I set up a database I always include a last change date that auto
updates every time any field in the record changes. Does anyone have a
suggestion for how to achieve a similar function in a spreadsheet. i.e.
put the current date/time in a field in the row whenever anything in the
GGG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29220
View this thread: http://www.excelforum.com/showthread.php?threadid=489447
For example, to put the last change date in...Creating a word2000 document with access 2000 data
I have a database in access 2000 it is basically customer info.
address and dates and timesof appointments. I need to place a button
on the formpage that prints a letter using the customer details and
the date & time entered in the database. Anyone have any clues as to
the easiest way to do this.sort of done it using mailmerge but not
what I want. Actually want a word document to pop up that the staff
can just double check and press print. Any help would be appreciated
even just a point in the right direction to a good source of
to see if the following website's offer...joining data points on graph
I am merging two graphs and one has 23 data points, the other has 9. The
category axis will have 23 data points but the 9 points are spread out, i.e.
they may be at points 1, 3, 7, 15 etc of the 23-point scale. At the moment
the graph will only join points that are beside each other; how do I get them
to connect to the points that have spaces between them?
minihana wrote on Fri, 10 Feb 2006 11:29:04 -0800:
m> I am merging two graphs and one has 23 data points, the
m> other has 9. The category axis will have 23 data points but
m> the 9 points are spread out, i.e. they may be...Stop running sum(Over All) when customer change
I hv report based on tblTransaction which contains many customers with their
transactions by date wise. I grouped report on CustomerID sub Group by
Fromat(trnDate,”MMM-YY”) to get monthly transactions for each customer. I
made calculated field to obtained closing balance with running sum over Group.
I want to make the Running sum – over all but when customers is changing it
must stop and start again, by default it will give running sum of all the
customer, exactly this I don’t want. Any idea to stopped or make running sum
based on customer when month is changing it ...Dynamic data label placement for graphs
I've read the article KB179199 on how to create custom
data labels for charts and it's good, however doesn't meet
all my requirements.
Is there a way to have the data labels automatically move
to a desired location relative to the graph?
For instance, I'm using 50 bar graphs per work book and
would like each data label to be just above their
I looked up article 179199 and got this:
BUG: Grid Based on .QPR File Appears Blank in Visual FoxPro 5.0
which probably isn't the one you meant. By above the bar, are they
horizontal bars and you ...How to change labels on a chart from numbers to words?
Can Someone Please help me? I can't figure out how to change the labels on my
chart in excel from numbers to words!
I'm not sure which labels you want to change to words, but maybe Jon
Peltier's charting tutorial will help you:
> Can Someone Please help me? I can't figure out how to change the labels on my
> chart in excel from numbers to words!
Excel FAQ, Tips & Book List
I suspect it's this page:
http://peltiertech.com/...Separating data in a column
the spreadsheet i am working on has 1 column with 2 possible answers, i.e.
yes/no. what i need to do is separate the replies and then total the yes
replies in another cell and also total no replies in a different cell. How do
i do it?
The following COUNTIF function can be used
The sort or data filter command can be used to separate the replies.
> the spreadsheet i am working on has 1 column with 2 possible answers, i.e.
> yes/no. what i need to do is separate the replies and then total the yes
> replie...Batch Number Changed
I recently upgraded GP from Ver. 8 to 10. few days back i notices that around
800 SOP orders transfered to One batch. This Batch was not existing before.
system created the batch. How this could happen? i checked in the activity
tracking table, no clues from there.
...Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy
and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
user. my client want to know how to enable it. hope for your prompt action.
Only works for SQL 2005. If you client wants to use a beta database server...
> I'm curious why are the Change Password Next Login, Enforce Password Policy
> and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
> user. my client want to know how to enab...change from SIZE ON DISK: 4:00kb
I am using publisher 2000. How can I can size on disk:
4:00KB into bigger number such as 16:00KB in "properties"
You can't. The file size is what it is because of the content. Why do you
want to change the file size? This won't help you to open it.
If you are getting an error message, that's a different story. Are you
running Norton Antivirus on your system?
MVP Microsoft [Publisher]
"nguyen" <firstname.lastname@example.org> wrote in message
>I am using ...Grouping Same Data in column
Using: Excel 2000
Issue: Is there a way to create groupings based on same values down
Example: I have phone numbers listed down column L. But some of th
numbers appear more than once. Can I automatically create groups base
on the same phone numbers so it would be easier on the eye to follow.
Hope this makes sense.
Message posted from http://www.ExcelForum.com
You could sort the list by the phone numbers, and use conditional
formatting to highlight the rows that contain a duplicate phone number:
Select a cell in the list
Choose Dat...How to get combo box selected index changed event in another page from the existing page in winforms
I am working on windows forms project. I have two winforms (window1 and
I have a combobox called cmbEmail in window1 and Textbox called txtName in
I want to retrieve some information into the txtName in window2 when I
selected something from cmbEmail in window1.
If I write code to retrieve something into the txtName (which is in window2)
in cmbEmail SelectedIndexchanged event in window1, I will get an error of
txtName doesn't exist in this page.
Can anybody help me to solve this problem..
Thanks and Regards
"Naresh" &...Merge data by macro
Hi all, I got data in column A and B as show below.
Row A B ......col
1 ID DATA ...headings
2 XY01 Record
5 XY02 Time
7 XY03 System
I need macro which should merge column B data and put result in column
C as shown below
Row A C ......col
1 ID DATA ...headings
2 XY01 Record Time Left
5 XY02 Time Right
7 XY03 System Record Ti...format cell to change color when copied
I do alot of cut and pasting. Is there a code that will change the color
of a cell if I right click to copy it, so I can track what I have worked
tawnee jamison's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16137
View this thread: http://www.excelforum.com/showthread.php?threadid=346063
Can be done, but you'll soon end up not knowing which was which.
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, _
Cancel As Boolean)
...Viewing Spreadsheet Data
When viewing the spreadsheet data on a particular excel
file, using a network. The spreadsheet file shows a blank
sheet until viewed in print preview. The data is visible
on one computer but not the other. The data prints OK but
is not visible! Any suggestions?