How do i link from one work book to another?
Sorry to be a pain, i know its more than likely a simple answer but i cant
work it out on my own.
i have a file with a bunch of worksheets on it and one summary page on the
front with all of the totals on it. I also have a seperate file (excel) that
has all of my repairs on it. So basically when the boss says why did we spend
so much on machine x, on the totals page, i want him to be able to click on a
link or something like that, that will take him to the other file with all
the repairs listed on it.
Thanks For Your Help
Right click on the cell>Hyperlink>From the lef...Linking Check Boxes or List Box to Query
Hello, I am hoping someone can help me out here as I am pulling my hair out.
I have a form that has unbound fields as follows
Text Box - Start Date
Text Box - End Date
Combo Box - Call Type
and a button that runs the query which includes the fields
Call Date - Between [forms]![FrmMarketingStats]![txtCallDateStart] And
Call Type - [forms]![FrmMarketingStats]![cboCallType]
Company (no criteria required)
Successful (this is the part I need help with)
The available options for Succesful are - Yes, No or n/a
I can achieve this by add...Exporting Customer Mailing List Data From RMS
The objective is to export customer mailing list data in a format useable to
a mailing service company.
When you use the Mailing Labels option within Crystal Reports, the
city/state/zip data is contained within one field. The preferred format is
for that data to be in three separate fields, so that ZIP sorting can be
Can someone guide me through the process I need to follow to make this
Do a customer list report (you will have to add the address fields by
editing it with a text editor) from the reports menu and export it to CSV or
&quo...reduce document print size
This seems like it should be an obvious answer, but I can't figure it out.
I have a 24"x18" sign in Publisher, I want to reduce it to postcard size, or
about 6"x4.5". I can't find any print driver setting to allow me to do
this. There is a setting for 25% reduction but thats a function of the
printer driver. Does publisher have a function to allow me to reduce the
print size down to 12.5%?
Hmmm.... I suppose I could output to jpg and reduce with photoshop....
surely there is a much easier answer though. Thanks!
If there is text involved, the conversion...Converting numbers to "database" format
I want to convert numbers in excel to a format with a set amount of digits.
For example, 1 becomes 001, 12 becomes 012 etc.
I have created a special format using 000. This works until I want to work
with these numbers, for example by using CONCATENATE. So if I have 01 and
012 and want it to be 01012, it ends up as 112.
Any suggestion on how to preserve formatting?
with leading zeros i am assuming that these are "text"
numbers or numbers you are not going to do math with.
so your problem is the excel thing that they are numbers.
format them as text and make sure that t...Linking data from the Internet
Please guide me if I'm in the wrong group, I don't want to cross post
I want to modify a working Spread sheet to pull stock values from the
internet and plug them into cells.
Has this been done and can someone show me an example? It would save me
hours of work each week.
2003 Data>Get External Data>New Web Query
2007 Data>From Web
Gord Dibben MS Excel MVP
On Tue, 05 Jan 2010 16:07:52 -0800, Doug Sanders <firstname.lastname@example.org>
>Please guide me if I'm in the wrong group, I do...Global recipient limit and distribution lists with a lot of member
I have to set the global recipient limit to 100 in our Exchange 2003
We have some distribution lists which have more than 100 members, but
everybody does not have the permission to send messages to these lists.
I set the recipient limit to 5000 at user-level at those users who have
permission to send messages.
Will it work? Will they be able to send messages to DLs which have 2000
members in spite of the global setting? Will it work with query-based
distribution lists as well?
Thank you very much,
Should work, the user setting should override the global se...How to reduce table?
I have a table with over 5000 rows. However, only about 2500 rows contain
info, the rest are empty rows (one row with info, next empty, etc). I
deleted a few rows by clicking on them and holding Ctrl key. But is there a
way to delete several hundreds of empty rows at once? If there is, may
someone please tell me how to do it!
Fort Myers, Florida
Select a column that has empty cells.
Gord Dibben MS Excel MVP
On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" <email@example.com> wrote:
>I h...how do i set up a group task list?
I want to set up a group task list that can be edited by 3 different people?
I know I can share a task list but that means others have read only rights,
which isn't enough. All help gratefully accepted.
"steelygal" <firstname.lastname@example.org> wrote in message
>I want to set up a group task list that can be edited by 3 different people?
> I know I can share a task list but that means others have read only rights,
> which isn't enough. All help gratefully accepted.
Share the t..."How does Money Get These Numbers?"
Hi! I know that there's a link to a rather vague answer for the above
question in Microsoft Money, when it comes to how Money calculates
existing data to crunch trended/budgeted items or spread a trended
budget item across the cash forecast graph. The help entry shrugs it
off like "Money uses your existing data." Duh.
Does anyone have ideas of EXACTLY how Money totals and divides your
existing budget items to create a budget entry? Does it add the value
up and total by the number of months you've recorded? (My experiments
don't line up close enough for me to be sure that...Money 2006 Update Brokerages List
Does anyone knows if there is someway to update the brokerage list for Money
I have the Principal Brokerage Investments that shows in 2007 and 2008, but
in 2006 I get is Principal Fincial Group(which also shows up in 2007 and
2008)and when I try to log in it says the username and password is incorrect.
The password works fine when I add Principal Brokerage Investments in MSN
Money. I tried to create a new money file and pull from MSN Money and it
pulls all accounts except Pricipal Brokerage.
Any ideas? I really want to user Money 2006 since 2007 and 2008 does not
provide in...Tracking Number on SOP Invoice Form
I am trying to get the Tracking number that is entered in the Sales User
Defined Fields Entry Window onto the SOP Long Invoice Form. Does anyone know
what tables to create the relationship with? I know the SOP10107 table holds
the tracking number into and I was able to get the table in the table list
but i must have the incorrect relationship because nothing appears on the
report when i add the tracking number.
If you are on GP 7.5 SP2 or higher you can refer to KB article 874762. If
you are on GP 7.5 SP1 or lower you can refer to KB 859212. Both art...Text box layout settings are changed when the document is closed
I have a text box in my footer. I have set layout settings for it so that it
displays in the right place. The wrapping style is Square, the horizontal is
aligned right relative to column, the vertical is absolute position .47"
below Bottom Margin, and the Options are Allow overlap and Layout in table
cell. (Some of these may be irrelevant to the problem, but I'm not sure
After saving the document, when I close the file and reopen it, the
horizontal and vertical layout settings are changed - horizontal to an
absolute position to the right of Page and vertical t...can I make access remember a last unbound number
I want to 'store' a number (which changes frequently) in an unbound text box,
but do not want it stored in any tables. Can this be done?
The number is used to reference a user start point, but I want it to still
be there when the database is reopened.
"efandango" <email@example.com> wrote in message
>I want to 'store' a number (which changes frequently) in an unbound text
> but do not want it stored in any tables. Can this be done?
> The number is...Reporting Services Lists & CRM
Has anybody tried aligning column headings located outside and above of
a Reporting Services' list to their respective fields within the list?
Everything lines up fine in Visual Studio's preview of the report.
But, when published to CRM, the fields within the list are slightly
shifted to the right or left of their intended position below the
headings. The accumulative shift can be substantial. I've tried just
about everything, including the use of fixed-width fonts. Nothing
works, except placing the column headings within the same list... which
has the obvious and undesirable ef...The Distribution List Form
Is it possible to add some column headers to a Distribution List Form (now
contains only the Full Name and the Email Address (or Email 1?).
If I can add fields with the Field Chooser, it becomes much easier to use.
Can it be done, short of VBA which, like the jitterbug, seems to just plumb
Oops; sorry; Outlook 2003, using Exchange Server, on XP.
> Is it possible to add some column headers to a Distribution List Form (now
> contains only the Full Name and the Email Address (or Email 1?).
> If I can add fields with the Field ...Help With Numbers To Dates
I am trying to paste into Excel, columns of numbers (from Word) that are
separated by hyphens. Excel is converting most of these numbers to a date
format. How can I stop this from happening? I have attempted every Special
Paste feature that Excel 2005 has.
Select the columns in XL that you intend to use to receive these numbers
from Word, and *PRE-Format* them to text.
Then, simply copy and paste.
Please keep all correspondence within the NewsGroup, so all may benefi...Reducing the Database
I hope someone can verify this for me as I read it and cant find the original
source again. I had a user with a mailbox size of 1g. I have deleted every
item in his mailbox, with the exception of a few emails (no attachment) and
expect his mailbox size to be well under 50 mb. I have did not perform an
offline defrag on this mail server, but rather moved the user to a new mail
server. Should his current mailbox size now reflect 50 mb or will it show 1g
as it did on the other server? Thanks
Depends :-) What is your Deleted Items Retention policy? If you deleted
everything yesterda...Can I stop links from converting backslashes to slashes?
We have an application where we launch Excel sheets with a backslash
switch. I am putting the same line we use in our applications, into
i.e. <file:\\filename.xls /e/test/>
When Outlook tries to open it, it converts to
Argh! I've tried the "%5C", and that doesn't work. And "quotes"
doesn't work either.
I searched for an autocorrect option to turn off, but I see nothing
related to hyperlinks.
Anyone have an idea?
well, you need more that the %5C to make it work - you need %20 for spaces
too... ...the viewstate hidden field, how can I reduce it?
I see in my page that the hidden field viewstate is relativly very large,
and are looking for ways to reduce it. Because I think it can improve
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE"
value="WJ6eLjF5Grnr80+KngeZIcTDmEbX+zjv6ptIUmMgYaqKCBB/5hAKJ748W52U1l74GfNLHDuTLuwC/O4GQE/Sp+BnQYsW+nJHK+Qkg6xfb467kHRpiCUUl/Uv2tgQssSa2K4sfbMyaL/IIlb03091A3lbQV1wLMDvL7NPqXgwJERA1+Cx2eNlzll2WkbhNQw5Ne0FmtmBXaZysPeDEeQIrl5R2IesEHnCbrG5Mz2otNviv2JKia1yXgAKw3ljDlH7wmYWOF+WXn9lhsF5YElQnMZV2hpzQjJ91O5YARub/ci77gftNaI2Z6FqHjH...How do I add a number of working days to todays date to get a dead
I'm looking for a function, similar to NETWORKDAYS, but that will allow me
to add a number of working days to todays date to generate a deadline,
hopefully I'd like to include Holidays too, just like NETWORKDAYS can, so
based on established timescales, I can generate a date the job will be
For instance, If Cell A1 has todays date, and A2 has the number of working
days a job takes to complete, I'd like a function for A3 that will work out
what the date will be when the job is complete.
A1 and a2 are as you describe, str...Can't send web link or page by email with outlook
See the big white space? Please include some information there so we
can help you. Include at a minimum your version of Outlook, exactly
what you're trying to do and exactly what error messages appear and at
...Problem with maito links
If I click on a mailto link in a browser a new mail message doesnt
open in Outlook. What happens is about 50 new browser windows open
with the folowing address:
Does anyone know what I can do about this?
Thanks for your advice
shaun <firstname.lastname@example.org> wrote:
> If I click on a mailto link in a browser a new mail message doesnt
> open in Outlook. What happens is about 50 new browser windows open
> with the folowing address:
> Does anyone know what I can do about this?
Repair the &quo...Determine number of rows with data
I am using the macro below to pull some data from an external workbook.
The 2 issues I need to sort are:
1. The number of rows in the external workbook can vary. How do I amend this
code to pull all of the rows with data?
2. The number of rows in the autofill also may vary. How do I autofill only
the number of rows required? i.e the number of rows in column A that contain
'Lookup Previous Month Sales
Selection.NumberFormat = "General"
Selection.FormulaArray = _
I have over 400 entries in a colomn which start with 0015...and then more
how can easily edit on mass so that they now begin with only 015 ???
To get these leading zeroes there are 2 likely possibilities:-
1. The cells are formatted to show them so simply alter the format.
2. The numbers are really text and I have assumed this is the case.
So if the 'numbers' start in a1 put this in b1 and drag down
Copy this new range and then select the 'old' range and
Edit|Paste special - select values - OK