Consolidating multiple worksheets
I have multiple worksheets in one file. All have the same column headings,
but the row information is different. Example: Joe Smith's information on
Worksheet 1 may be on A5 but on Worksheet 2 he is on A10. I would like to
show all of this in one file so that I can summarize and sort the
information. Adding to the confusion, I need subtotals for each worksheet as
they are for different items in the company. I see that I cannot do a pivot
table from other posts but thought that a consolidation worksheet might be
better. Problem is, I have never done one and am unsure as to how...Format a combobox list as a heirarchy...?
I have a table that has a primary key and a parentKey column. I'm using it as
a Combo Box in the Lookup of a field in another Table. Right now, the
dropdown list is formatted normally, like this:
Program1 | Process1
Program1 | Process2
Program1 | Process3
Program2 | Process1
Program2 | Process2
Is there an easy way to make it look like this:
Program1 | Process1
- | Process2
- | Process3
Program2 | Process1
- | Process2
?"in a table"?
Are you saying that you are using a lookup field data type in a table? You
posted in ...Mass updating records with different data for each record
I need to update about 160 accounts with some data that wasn't imported, as
we added new fields in CRM that we now want updated for all accounts.
I have a spreadsheet that contains the account and the value that needs to
go in a custom account field. Each account has a different value in that
In my example I only mention one field, but reality is there over 10 fields
that need to be updated for 160+ accounts. Again, I've compiled the data in
a spreadsheet, and now need to "update" the records in CRM.
What is the best and/or easiest method t...Data Validation #11
Few Questions about Data Validation
1) I have a conditional data valdation set up to display a different
selection list in the second data field based upon the answer the user
provided in the previous cell to another data validation selection list
containing on Yes or No.
Lets say the user selects yes in the first field and then selects an
option in the second field based upon their previous answer of yes but
then goes back and changes yes to No, how can I erase the response the
user selected in the second field when the selection list is updated.
Now, the previous answer stays...preventing distribution lists from getting outside emails
We have an Exchange 5.5 server an have recently started receiving computer
worm/virus emails to our companywide (email@example.com) email address,
thus everyone recieves the email. Is there any way to block this particular
email address from receiving emails from the outside (internet)?
Why not just remove the SMTP address?
On Fri, 4 Jun 2004 16:43:16 -0700, "Jason Gallas"
>We have an Exchange 5.5 server an have recently started receiving computer
>worm/virus emails to our companywide (firstname.lastname@example.org) email address,
>t...I accidentally deleted a contact list
Right when I did it, a brief msg flashed that said something about where it
went - junk folder ? I don't recall. I am using MS Office Professional 2007
and find the Contacts and Distribution Lists very confusing! I meant to
delete a distribution list and ended up deleting a contacts list.
It's in the Deleted items folder - search for it there if you can't find it.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
mailto:dailytips-subscribe-reque...subform data needs to be saved in main form's table
I have 2 tables. One table will store student names temporalily and the
other will store several hundred company names - that are not temporary. I
have an unbound combo box in my main form which queries the company table.
When a company is selected, it's details appear in the subform. So, if I
have a company selected, and several student names typed in the main form, it
all looks perfect. Now, I want to save all of the information in the main
table (the student table) so I can do mail merge in MS Word...How would I get
that sub form information from the company table to save in...Sample Data Base error
I've installed CRM 1.2 according to the Implementation guide and added our
license key for 6 users. I assigned each user a license.
When I try to add the sample database, I get the error "You do not have 5
Microsoft CRM Suite Professional licenses available. For more information,
contact your system administrator.".
I also tried removing the licenses from the users so i had 5 free/unassigned
licenses but I got the same error.
Can anyone help?
Double check to make sure that the licenses really were removed from
the users. Assuming you did this via the web clie...Data Selection Help
I need a little help
Picture my screen
I have 16 teams and about 12 to 15 people per team
Cell C1 TO C100 Contains Various Team Names
Cell D1 to D200 Contains peoples Names
In Cell A1 Contains "Team Name"
in Cell A2 i want to select a person from the list i have created in C1 & C2
but it needs to filter out only the people that play for that team selected
Anyone Got any idea's
Thanking so much in advance
...Making long alphanumeric list
Sorry guys this is a newbie question I know...
But how do you make a long alphanumeric list in excel automatically
without having to type all the figures etc...
Medtner's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29547
View this thread: http://www.excelforum.com/showthread.php?threadid=492512
Just enter Lan01 in the first cell,, then move the cursor to the
bottom-right corner of the cell until it changes to a black cros...list spacing
I am using ON 2010 beta. Do you have any idea how I can change the space
size between the list items? For example, I have a list as follows:
I would like ON to give automatically a line line space between the list
items, but it does not. How to do that?
...Recognising the user switch between Form view and Data sheet view
My Uncle has an Access application where he would like to sometimes switch
from a Form's Form View to Data sheet view and back. He would like certain
settings for each view (eg form maximisable when in Data Sheet view but not
when in Form view,and certain fields hidden in data sheet view but visible in
text boxes in Form view. So,is there an event which is fired when the form's
view style is being changed,so that I could put appropriate coding there?
Either Access 2003 or 2007 could be used,preferably 2003.
I realize I could put a button on the form in form view, say,whe...Quick Campaign lists
Is there a way to add names inot the quick campaign list and have it not go
inot the leads, and also is there a way to bulk transfer the owner for the
"Jasmine" <Jasmine@discussions.microsoft.com> wrote in message
> Is there a way to add names inot the quick campaign list and have it not
> inot the leads, and also is there a way to bulk transfer the owner for the
> whole list?
...move/copy data w
Is it possible to set it so if i type a word in a
particular cell that the data that is in the corresponding
row is then moved to another sheet in the workbook?
For example: When I type the word Confirmed in Column X on
sheet1 I want the info from column c and k-aa on the row
that I just typed Confirmed for to copy over to sheet 2 in
cells A and B-R
For example: I type Confirmed in cell X9 on sheet one, I
want C9 and K9 - AA9 to move over to sheet 2.
I think I'd take a slightly different approach.
I'd select my range and do Data|filter|autofilter.
Then I could...merging data with ms word letter
I have a situation in which the users want to merge records in a table to a
Word letter template. Once the merge takes place, a field in the table is
updated with the date the merge took place. Then later when the user goes
against the table it is filtered against the empty field records so the newer
records can then be sent the letter and not those that were already sent.
There will be multiple records accessed each time the merge takes place.
I am a bit lost on how to do the merging of the record data into MS Word and
seek the expertise of the group. If there is are any samples/ex...Dropdown List Help
Does anyone know how I can make the dropdown button on a list stay
visible whether the cell is active or not.
Thanks for the help,
You can't if you use data > validation, you would need a combo box from
either the forms or control toolbox tollbars
> Does anyone know how I can make the dropdown button on a list stay
> visible whether the cell is active or not.
> Thanks for the help,
Same answer as yesterday when you posted the identical question.
No. T...Summarizing Data
I am working on summarizing data that was given to me in a format like:
Ref Num Group Score Category (below are in one cell)
205 AA 3 Asset, Liability
206 BB 2 Revenue, AR, Asset
207 AA 1 Liability
208 CC 3 Expense, Liability
208 AA 2 Asset, Expense
205 CC 2 Asset
I want to end up summarizing the information into a report/pivot table,
chart, something that would look something like:
Group Category Ref Score
AA Asset 205 3
AA Liability 205 3
AA Asset 208 2
BB Revenue 206 2
BB AR 206 2
BB Asset 206 2
This would break out the category column to allow for each...Distribution List #2
How do I import a distribution list that someone emailed
to me so that I can use it in outlook 2002
...Data Migration #4
Hi, i can't migrate from sage line 50 into GP 10.o
Microsoft Dyanmics GP 10
Did you have a question or just wanted to make that comment?
East Coast Dynamics
i am asking for solutions on Migration from third party products to GP (Sage
Line50,Line 500, Peachtree and Simply Accounting)
Microsoft Dyanmics GP 10
"Frank Hamelly, MCP-GP" wrote:
> Did you have a question or just wanted to make that comment?
> Frank Hamelly
> MCP-GP, MCT
> East Coast Dynamics
> www.eastcoast-...steps to restore data files
Here is my problem, I had a drive failure and 1 good backup of my email
store. When I rebuilt my domain I chose to rename it slightly so the
workstation connecting went a little quicker. I never considered that it
might have an impact on any restore of exchange. I did try to recover it with
NTbackup, but the store will not mount. Is there an easy way to get just the
data? Maybe as flat-files?
Does a different domain name make this impossible -or- since it was a fresh
install could it simply be that I don't have it patched to the same level?
Since I was not able to view/mov...Clean Up Code
I have code that contains the following:
ActiveCell.FormulaR1C1 = "USB"
ActiveCell.FormulaR1C1 = "04165"
ActiveCell.FormulaR1C1 = "14709"
ActiveCell.FormulaR1C1 = "14716"
ActiveCell.FormulaR1C1 = "24704"
ActiveCell.FormulaR1C1 = "44705"
ActiveCell.FormulaR1C1 = "44710"
and it goes on to ent...input not erasing old data without notice?
Here is the problem I need to solve with Excel and hope to hear solution
suggestions from this NG...
I have a sheet named "Gorev" where I enter the "teacher name",
"lesson&class" and "period for this lesson" info row by row for each
different task. This info is then used in another sheet named "Haftaplan"
where the top row holds the period labels, A:A column holds the names of
teachers while the matrix region (area) between these two axis displays the
data of the "lesson&class names" retrieved from lists via the formula
...Global Adress List #2
I added a new employee this morning around 11 am. Everything went as planned.
Our SBS server 2K3 and Exchange 2K3 SP2 accepted everything. The server
console shows the user in the global address list. Yet none of the other
users in the company see the person in the global address list. If you access
the users directories and other lists she's there. If you type her mail
address it will go to her. If you just type the name without the @ and ask to
check names she doesn't appear. Just not the global list on all other
workstations. Is there a certain amount of time req'd before...How do I create a report that shows the control names when no data?
I'm trying to create a report made up of about 10 subreports. Creating the
report isn't a problem but I want the subreports to show the control labels
even if there isn't any data (similar to a form) I've tried various formats
but can't get it to work. Anyone any idea how I can force the control labels
to show on a sub report even if there isn't any data for that report?
Tony Williams wrote:
>I'm trying to create a report made up of about 10 subreports. Creating the
>report isn't a problem but I want the subreports to show the control...Global address list does not appear in mail merge
I'm trying to use Outlook 2003 to send an email to multiple persons using
1) I create a new message
2) Go to Tools/../Mail Merge
3) Document Type = Email messages
4) Use current document
5) Select recipients = Select from Outlook contacts
.. and here only appears my private contact book, but it doesn't show
the Global Address list.
Thanks in advance