Linked Spreadsheets Grandfather Name Sticking
Here's an example of the problem.
Let's say I have a store that sells gasoline.
I want to record my store sales, and gasoline sales
So, I have a spreadsheet for store sales and a spreadsheet
for gas sales in gallons.
And these are setup per month. January sales sheets,
February sales sheets, etc.
I have the gas gallons spreadsheet linked to the stores
sales spreadsheet, so I can enter all the data while in
the sales spreadsheet.
Let's say I have entered all of January's sales and gas
data and want to move on to February's data.
I copy Jansale...Count File Names
I having an issue with version control on Buisness cases. I currently
have a spreadsheet that looks into a folder and picks up details from
a number of files. However, they require version control numbers so
there will eventually be multiple files say 2010-01 v1.0, 2010-01
v1.1. Is there a way I can:
1) Get a macro to count the number of 2010-01 files there are in the
2) Get my version control sheet to look at the latest version of the
file (in this example: 2010-01 v1.1)
See if this code works. I assume that 2010-01 is year and month.
...M2004: Change name on home page?
I'm using Money 2004. On the home page it says "So-and-so's Money Home
Page". How can I change the name that appears there?
> I'm using Money 2004. On the home page it says "So-and-so's Money Home
> Page". How can I change the name that appears there?
Figures... I always seem to find a solution right after posting a
question! Click Accounts & Bills, Account Setup, Update Personal
...Name prefixing in reply message
I'm not even sure what terms to google for related to this problem. If you
get an email from someone in the Office XP version of Outlook, and you click
reply to that email, then start typing inside the portion of the message
that contains the original message you replied to, it will automatically
prefix everything you write with your name. How does one turn this off?
Thanks in advance!
> I'm not even sure what terms to google for related to this problem. If you
> get an email from someone in the Office XP version of Outlook,
> and you click...Help with auto height of rows
I've got Excel 2002. Spreadsheet has over 3400 rows and 6 columns. No
merged cells. All fonts are Arial size 10. The first 1809 rows are set to
a height of '15.00 (20 pixels)' and the remaining rows are set to '12.75 (17
pixels)'. I've tried selecting all rows and then double clicking on a
divider bar to get them all to adjust to auto height, but they stay at the
heights listed. I want them all to be at the 12.75 (17 pixels) height when
you do the auto height adjustment. Why won't this work on this spreadsheet?
Nevermind - I fig...Server-Wide Auto-Reply / Address Change Notice
We are in the process of changing domains as far as email/web addresses are
concerned and I wonder if it would be possible to have Exchange reply for
each user with a message stating something like, "This is an automated reply
letting you know that the email address for User Smith is now
I realize that each user could create a rule in Outlook... but we would need
the rules to apply for a long period of time and that could be very annoying
for senders... getting hit with constant auto-replies.
Even if it would be possible for a user to create a rule th...Auto Filling Fields in Current Record from Previous Record
I have looked through posts related to Auto-Filling a field from a
previous record but am still a little unsure of how to do things.
What I would like to do is auto fill a field in the current record
with one from a different field in a previous record. What I have is
a form that records "engine hours" and "tonnes moved" for a piece of
equipment. The operator will record the staring hours and tonnes (at
the start of a day) and the hours and tonnes at the end of the day.
So in the database, I would like the "Starting Hours" and "Starting
Tonnes"...Comparing first and last names in two lists #2
I have two data sources that each contain about 8000 names in seperate
fields for first and last name. I can put them on seperate worksheets
or append one to the other. I need to make them match and find out
where they don't. Messed with consolidate but not sure if that will
work for more than one column at a time. FYI data set one is from a
school transportation database and data set two is from the main
student database from the same school district.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages dir...How do I set up an out of office auto response?
I'm a new user to Outlook and I was trying to initiate an "out of office
response"/auto reply for one of my colleagues. Can you help me out?
Thank you so much.
JenniferC <JenniferC@discussions.microsoft.com> wrote:
> I'm a new user to Outlook and I was trying to initiate an "out of
> office response"/auto reply for one of my colleagues. Can you help
> me out? Thank you so much.
Yet another stupid question what is the OOA & how do I enable it?
"Brian Tillman&qu...Different display names
Is there any way to have an account display differently in the FROM field
compared to the GAL (Exchange 2003).
We would like the user to appear in the GAL as "Bob User" but when an
external recipient reads an email it should be displayed as "Bob of Company
...File name from a cell
I am trying to have date in a cell become the file name and appear i
the save as dialog box as the file is saved the first time
Message posted from http://www.ExcelForum.com
Dim mySuggestedFileName As String
Dim myFileName As Variant
mySuggestedFileName = "c:\my documents\excel\test\" _
& Format(.Range("a1").Value, "yyyy_mm_dd") & ".xls"
myFileName = Application.GetSaveAsFilename _
...Unlocking named ranges
I am working with a spreadsheet created by a former employee. He used named
ranges a lot. I am trying to understand the worksheet. When I see an
equation in a cell like =Sum(Shipments) I feel I know what it means.
But how do I learn what the actual cell reference is ie = Sum(D2:G2).?
Insert a new, empty worksheet into the workbook. Then you can use The
Insert-> Name-> Paste menu option and click on the Paste List button to get a
listing of all the names and the definitions
> I am working with a spreadsheet created by a former employee. He used...Adding company name to the "From" field
Hopefully this is an easy problem. We are running Exchange 2003 on Windows
Server 2003 in a mixed domain. (Win2k and Win2003 servers)
Lets say I am working for a company named "XYZ". The owner of the company
wants the "from" line in the email client to say "Bill Smith, XYZ Company".
Unfortunately I can not find a way to do this. Any help is appreciated.
Just use ADModify to rewrite the Display name for every user in your
company, or for users of that company (if companys are sharing and AD)
ADModify can be found here:
http://www.gotdotnet.co...can't prevent a flash file from being cached
I've spent the whole day trying to get IE8 to reload a page to display
dynamic content in a flash slide-show. nothing I've tried prevents the page
from being refreshed from the cache. all the other browsers I've tried are
working properly (firefox, chrome, opera and safari).
here are some of the things I've tried
in the page <head>
<meta http-equiv="cache-control" content="no-cache"/>
<meta http-equiv="Expires" content="Thu, 01 Jan 2009 08:00:00 GMT" />
in my .htaccess file (for my local apache...reading file name from folder function
I am using Access 97. Just wonder if there is a fuction which can read all
the file name from a folder and put it to a column in a table. Please let me
>I am using Access 97. Just wonder if there is a fuction which can read all
>the file name from a folder and put it to a column in a table.
Please see the getFileInfo( ) function in the tip, "How to compare the
contents of two directories," on the following Web page for an example:
See http://www.QBuilt.com for all your database needs.
See http...Domain name not always needed to log into OWA?
This is something I've wondered about for a while.
Why is it that only some of our new Exchange Server installs insist on
the OWA login <up to 13 chars. of domain name>\<user name> while
others have no trouble with only <user name>?
"Julie" <email@example.com> wrote:
>This is something I've wondered about for a while.
>Why is it that only some of our new Exchange Server installs insist on
>the OWA login <up to 13 chars. of domain name>\<user name> while
>others have no trouble with only <user name>?
Probably b...edit suggest names when completing To, cc and bcc fields
Apparently I don't have an Address Book linked to Outlook
2000. No matter, because I seem to be ok with the suggest
names feature, which I guess is not Address Book-linked,
but linked to a memory bank of names and corresponding
addresses typed in during the past.
However, here is my question:
How do you edit this Suggest Names list? In particular,
A. Suppose you want to stop Outlook from suggesting a
particular name because it is not current anymore. Worse,
you might inadvertantly click on it and send msg to
somebody you don't want to receive it. Is there a way to
delet...I am trying to get access to display leading zeros and auto numbe
we use a sequential number system that begins new each month but we need it
to hold 4 places 0001, 0002. etc. I would like to know if Access will do
"Donna" <Donna@discussions.microsoft.com> wrote in message
> we use a sequential number system that begins new each month but we need
> to hold 4 places 0001, 0002. etc. I would like to know if Access will do
Yes, but ...
You can't use the built-in autonumber field to do what you want. Therefore
you'll need so...Report names in listbox
I recently upgraded to Access 2007 and am having some trouble with the
changes. I have a form with a listbox in which I would like to display the
names of all the reports in the database. I've tried using the following as
the rowsource for the listbox, but in form view nothing is displayed. Does
anyone know how to do this?
WHERE (((Left([Name],1))<"~") AND ((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;"
I think you made a slight typo. Try (((Left([Name],1))<>&quo...Named Ranges
I created several worksheets that contained huge lists, so I created a
dynamic named range. Now that the name has been inserted in my array
formulas, my Macro runs very slowly. The Macro unprotects one of my sheets,
sorts the data in a table, hides the blank rows and the protects the sheet
again. There are no related named range formulas in that worksheet, so I'm
not sure why it would be affected. The Macro ran quickly when I had a
defined range of data.
Would giving a named range like 'Date' and having text in my workbook with
'Date' create conflicts? Could this...Switching Names Around
I am getting a list of names imported into Excel. All the names are in the
order of LAST NAME FIRST MI/[SPOUSE] FIRST [SPOUSE] MI. All of them have
their last name at the beginning, and they're all merged into the same cell.
I am trying to print out mailers, so I need the 1st name moved to the back
of the line so it prints out normally. How would I write a macro to do this?
The only way I can think of is to signal is off the very 1st SPACE-
everything before that space gets added to the end of the line. Is this
possible to do? How do I do this? I'm not very good at VB, so...Access server name?
I have been using SQL Server 2005 and I'm now trying to move to Access
(Microsoft Office Access 2007).
One question, with SQL Server 2005, there is a Windows Service called "SQL
Server" which is running all the time and ready to be connected from a
database application. In the case of Access, what is the equivalent program?
I do not see any Access program in the Windows Service List.
Thanks in advance!
Polaris <firstname.lastname@example.org> wrote:
> Hi Experts:
> I have been using SQ...Send Emails With A Different Name Than How Its Listed in the GAL
Hi all, I have a quick question:
My client is unhappy with how his emails get sent out from MS Outlook.
The GAL on our server lists names as [Last Name], [First Name]. This is
how the majority of our clients want it. However, he wants his to be
[First Name] [Last Name]. So, all recipients getting emails from him
will see his name as First Name, Last Name. We can't do this for him on
our GAL, since it would obviously cause an inconsistency if we did it
only for one name. But, I figured I'd post here to see if anything else
can be done to accomodate him.
Thanks in advance for your help...Using a named range as a data source for a chart
I'm trying to build a chart that that has a named range as its data source.
The named range refers to a table that is 2x3 and is called geographydata. Is
there any way that I can have the source data for the graph to be
You can enter the name, preceded by the worksheet name and exclamation
point, for the data range, but Excel will convert this name to its cell
address. If you want the chart to be dynamic as the name changes its size,
you have to define a name for each series' data. This will not dynamically
change the number of series in the ch...Auto Empty Deleted Items on Exit OR after X days or X Items accumulated?
In Outlook 2003 is there a way to Auto Empty the Deleted Items Folder,
either on Exit OR after X days since deletion or when X number of
Go to "Tools" : "Options" : "Other"
First option is "Empty Deleted Items folder upon exiting"
You can set it to delete after x number of days for certain e-mail account
Go to: "Tools" : "E-Mail Accounts" :
Select, "View or change e-mail accounts"
Select account to chnage and click "Change..." :
Click "More Settings"