I have various items in a spreadsheet. There are many different items in
various rows. Some items have the same reference number, just a different
description. I want to combine all of one reference number's descriptions
into one cell. I am doing vlookup, but it is only putting in the first
Is there a way to combine all descriptions into one cell? It's like this on
another sheet within the same file. I am trying to pull it from Sheet2 into
Reference # Description
123 Pant Set
123 2pc set
123 Shirt & Pants
I want #...Problem assigning new owner to account record
We are having a problem assiging a new owner to a specific account record.
This problem does not occur with assigning other account records. After
assigning the new owner, when the account form tries to save and refresh,
this error message occurs:
A record with these values already exists. A duplicate record cannot be
created. Select one or more unique values and try again.
There is no duplicate record in the system - either active or inactive.
I got that exact same error this morning trying to do the same thing.
Rick, if you figure it out would yo...One column with different widths
I want to make Column A with rows 1-29 one width rows 30 and above a
norrower width. Is this possible with Excel XP?
Calpitor's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28104
View this thread: http://www.excelforum.com/showthread.php?threadid=476080
Merge the cells of two columns for the section you wish to be wider
henry's Profile: http://www.excelforum.com/member.php?action=getin...Multiple e-mail account in MS Outlook 2003
I have 4 e-mail accounts set up (all from the same server) and can send from
all accounts but I only receive mail for the default account. Any
Does each account use the same account properties? (e.g. same mailbox name,
userid, and password.)
"Crazy Squaw" <Crazy Squaw@discussions.microsoft.com> wrote in message
>I have 4 e-mail accounts set up (all from the same server) and can send
> all accounts but I only receive mail for the default account. Any
...I know how to concatenate ,can one de-concatenate to split date?
We are using Quick Books and want to export to a Custom Label Quick Books
only exports to EXCEL in IIF format.
QUICK BOOKS PROBLEM- wrote:
> We are using Quick Books and want to export to a Custom Label Quick Books
> only exports to EXCEL in IIF format.
In the date column use the text to column feature under Data
on the menu bar. For the delimiter select / this will split
the date into three columns.
...Post department hours to unit accounts in General Ledger
I would like to see the hours that are allocated to departments in Payroll,
also be posted to unit accounts in General Ledger. Currently we have to do
this manually for doing analytical reporting on financial statements (Sales
per man hour or SPH) by taking numbers off the payroll posting journals and
then reentering them as a JE in General Ledger.
Douglas J Karel
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 t...How do I print a one page spreadsheet multiple time, each with its own page number? #2
Roy, thank you so much for this solution. I will try it right away.
Roy Wagner Wrote:
> If you want to use the center footer, replace the FOR/NEXT loop with
> the one
> below. You still need a placeholder on the worksheet, but the sequence
> statement is printed in the footer rather than on the sheet (only
> visible in
> preview etc.). You can eliminate the formula on the sheet that put the
> and number together. I also changed it so it increments the number
> printing instead of a...Display of CRM data in SharePoint
Is is possible to allow non-CRM users the ability to view CRM data on
SharePoint without using the CRM external connector?
Microsoft would require you to have a license per user I think
Microsoft CRM MVP
"Rick M" <RickM@discussions.microsoft.com> wrote in message
> Is is possible to allow non-CRM users the ability to view CRM data on
> SharePoint without using the CRM external connector?
> -Rick...Re: Two-Column Problem
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Charley Kyd <email@example.com>...
> But now, when I add a pair of pages, Publisher gives me guides for two
> columns per page but gives me only one page-wide textbox per page,
> not two.
Can't you create your text boxes yourself? Or change the text box that
appears to a two-column one?
Ed Bennett - MVP Microsoft Publisher
Before reading this message, view the disclaimer:
...Unable to display default folder in cached mode
I have installed and configured Exchange 2003/Outlook 2003 clients. Some of
them, after creating the Outlook profile, displays "Unable to display your
default folder" message on Outlook stratup and shuts down Outlook. When I
turn off the "Use cached mode", it works fine.
I have tried it on other computers/other users profile and still have some
3-4 user mailboxes with this issue.
There is Novell client installed on computers, but other 60+ users are fine.
Any help would be appreciated.
Do the users having problems have a local or remot...two-variable calculations continued ...
Could you be more specific, as I am still learning to program in excel.
"Gary''s Student" wrote:
> Use a worksheet change event macro. It can detect two cells entered and
> calculate the third, See:
> Gary''s Student
> "fredonic" wrote:
> > If I input a formula e.g. ‘A1+B1=C1’; how do I tell excel to calculate B1 if
> > I have A1 and C1’s values or A1 if I have the other 2 values – doing all this
> > using only the 3 or...Emails Account
How do I setup my outlook express account to recevie email from hotmail
"Milan Petrovic" <Milan Petrovic@discussions.microsoft.com> wrote in message
> How do I setup my outlook express account
This newsgroup is for support of Outlook
97/98/2000/2002/2003/2007 from the Office suite of products. Outlook
Express is actually a separate program despite the similar name.
For help with your OE questions, try an OE newsgroup such as
microsoft.public.outlookexpress.general (for OE 6), or
an OE help website s...account segments and posting account
1. Is it possible to have only one segment of account?
2. Is it ok, if Posting account setup do not have default accounts payable?
I think this accounts payable is use as a payable account in Payable
Distribution for a vendor, if vendor do not have accounts payable in vendor
account maintenance setup.
If there is no accounts payable in posting account setup and no vendor
accounts payable in vendor account maintenance setup, then which account
should we use as payable account for a vendor?
1. Yes, you can have a single segment account number in Dynamics GP
2. If you dont have an accou...displaying negative values
how do I hide the display of negative numbers?
Regards from Brazil
> how do I hide the display of negative numbers?
That will work if cell A1 has a formula in it.
If negative numbers are just typed in, you can use conditional formatting.
Highlight the range of cells you want to format.
Go to Format > Conditional Formatting...
Enter cell value is less than 0.
Click the Format... button and select Color: and then click the white icon.
> =if(A1<0,"&qu...compare two columns and display a third
here's the challenge:
-I need to compare 2 columns: A1:A10 and B1:B20 (different range)
-For each common value I would like to display the information contained in
a third column C1:C20
I did some research on this forum and http://www.cpearson.com/ but so far no
any help will be greatly appreciate to avoid doing it manually 2000 times.
=COUNTIF(A1:A10,B1) in C1 gives 1 if B1.value occurs in A1:A10, 0 if not.
Fill down to C10!
or =COUNTIF(A1:A10,B1) > 0 gives TRUE or FALSE respectively.
> here's the challenge:
> -I...Combine multiple tables into one
I took over a database in which the last person created a new table for
everyday worth of data (ie. Feb-21-08 is named 022108). There are over 100
tables in the single database with the same columns and table attributes, I
would like to combine all of these tables into one where I have a Date_Key
field in place of the table name. I figured out how to query the table names
using the following:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND
(Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY
Now I j...email account not found
I've added my email accounts to Outlook 2003 and they both show up when I go
to the "Add or Change" screen. But when I try to move them up or down I get
a message, "The specified account was not found. It may have been deleted".
Both email accounts are visiable when I try to ad or change them, but when I
go to send an email, I get no options when I click on the "Accounts" button
to change the accounts. Nor is there a SEND button. Other discussions
suggests that this means that Outlook does not recognize an active email
Try creating ...Retirement 403b account and budgeting
I'm trying to setup my budget and How I'm doing on my
budget report to register my employer matching 403b
I'm having 2 major problems with my account.
1) When I schedule a deposit into the cash transations of
my 403b account, it doesn't show up on my budget planner
as a scheduled payment as the others do. I have to enter
it in manually.
2)I have to uncheck the "retirement account" option in
the account details for the report to recognize my
account in the report at all.
It seems like something very strange is going on here. Is
there a fix or a...Transfer Roth from One Brokerage to Another?
I'm using the Microsoft Money Plus Deluxe Trial. How would I go about
telling Money about transferring a Roth from one brokerage to another (I'm
letting money download the data from my current brokerage)? Is there some
way to, perhaps, change the Financial Institution and account number and then
let Money continue as though nothing has happened? Or, do I have to close
the old account and then open a new one and somehow account for the shares?
In microsoft.public.money, David A. Lessnau wrote:
>I'm using the Microsoft Money Plus Deluxe Trial. How would I go about
>...Form will not display records
In Access 2007, one of our users has asked me to research the following,
She built one form, using fields from 5 tables, each table has a field,
Item_ID, it is the Primary key in all 5 tables, and a 1-1 inner join relates
the 5 tables. She then created the form, using the fields from the tables.
Data entry works perfectly, and the tables get populated, but when closing
the application and then restarting it, the data does not display in the
form, although it is still in the tables.
What could cause this behavior?
What is the SQL feeding the form?
Build a little, test a ...How to list accounts and their last balanced on date?
Is there a way to list accounts and the date they were last balanced
on? I have many accounts stored in MS Money and many times I forget to
reconcile some infrequently used accounts for months. Sometime it then
becomes too late to figure out the missing transactions to bring the
accounts upto their latest balance. I was hoping there would be a
report which can tell me all open accounts and the date they were last
balanced on instead of opening each account individually. BTW, I have
MS Money 2001 SE.
On 5 Oct 2003 13:53:44 -0700, firstname.lastname@example.org (P Adhia) wrote:
...Account Description Length
Is there a way to increase the amount of characters that a Account
Description can be from 50 on my current installation of GP 8.0 to
more, like 75?
You would have to start by changing the length of the field in the SQL
Then you may have to modify forms to allow you to input and display
Then you would have to worry whether that would cause any problems with
any forms or reports.
I wouldn't change it without "approval" that it would not cause
Plus, you have to be concerned with upgrades not going through or blowing
away your changes.
...Associated external Account #2
Just got some of our exch2k users migrated to another org exch2k3. Found
that associated external account rights which never seen before in 2k. Wish
to know the purpose of this account and when is the best time to use it.
Please help and thousand thanks.
Granting Access to External Accounts
"Elton Seng Yan Thung" <email@example.com> wrote in message
news:enFBAvpwFHA...How do I set up a sheet with date headers one week apart.
I am trying to set up a spreadsheet with date headers and/or side labels,
one week apart.
I have tried without success. Any help gratefully received.
1/1/2006 - 8/1/2006 - 15/1/2006 etc.
Dell Dimension 8400
4 Gig RAM
1.3 GigHz Pentium CPU
Windows XP Pro - SR2
160 Gig Hard Drive.
Type your first date in A2. In the next cell use
You can fill this across as necessary.
"mossbury" <firstname.lastname@example.org> wrote in message
>I am trying to set up...Cannot syncronize accounts in different currencies on my pocket
I often need to manage accounts in different base currencies but it seems
that accounts different from base currency, do no appear on pocket pc 2005. I
am using money 2005 on my desktop and recently downloaded pocket money 2005
to my ipaq.
This seems to be a serious limitation. any suggestions?
It is a (one of the) limitation of the pocket pc client.
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://regi...