Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...How do I send a welcome message to a new created mailbox automatically?
My exchnage send a message automatically but I need to change the message
where do I change it?
On Tue, 21 Jun 2005 16:35:53 -0700, "Ron" <firstname.lastname@example.org> wrote:
>My exchnage send a message automatically but I need to change the message
>where do I change it?
Exchange doesnt do that unless you have something scripted.
If you are referring to the welcome message in Outlook, its called
welcome.msg , but I dont think its been used since Outlook 2002.
So where would I plug in the script? Also I searched for welcome.ms...Creating a template using Publisher
I need help creating a neighborhood directory template using Publisher and
merging an Excel spreadsheet into it. It keeps printing multiple pages of the
first page after I merge.
What version Publisher?
If you have 2003 use the catalog merge for your directory.
Otherwise you need to setup your page as though it is labels. Determine the size
of the area you need for each entry, select labels in page setup, type the size
you determined in the page setup. Adjust the gaps and margins when you are ready
to print (2000 and bel...Comparing first and last names in two lists
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...Contact looses Post Office Box field when synchronized to Outlook
When I sync contacts from CRM 4.0 to Outlook, the Post Office Box field from
the contact gets empty.
Anyone has the same issue?
...List Running Horizontally-Pivot Table Possible?
I just had a customer ask this one and I'm not so sure
1) The customer has setup a list of information that is
running horizontally instead of the typical list running
2) I just taught him how to do pivot tables and he wants
to generate a pivot table with his "horizontal" list.
3) I know he can copy and paste special and use the
Transpose feature to change the list from horizontally
oriented to vertically oriented.
4) the question is: can he leave the table in its original
orientation and still generate Pivot tables? I can't seem
to make it work ...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...Creating a worksheet in Spanish
Is there a way to create a worksheet on MS XP Pro running
Office 2003 Pro all in Spanish?
All valid formulas -except the ones from the Analysis Toolpack- will
automatically translate to the language of the Excel it's opened in. So any
spanish speaking Excel will translate formulas to spanish, no matter which
version it was written in.
The rest, text constants and such, has to be typed or pasted. Excel will not
translate this herself.
HTH. Best wishes Harald
"Kent" <Kent@discussions.microsoft.com> skrev i melding
news:ACCCBA3A-53B4...Rule to automatically mark header to download based on contact list?
Is there a way to do this, or an add-in?
On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> Is there a way to do this, or an add-in?
What version of Outlook are you using?
Ben M. Schorr, MVP
"Ben M. Schorr - MVP" <firstname.lastname@example.org> wrote in message
> On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> > Is there a way to do this, or an add-in?
> What version of Outlook are you using?
>...List folders to file
Does anyone have a macro that would list all the folders (with path) and
subfolders to an excel sheet but not the files?
There's a function called CELL() that should return your filename (or
any of a number of parameters) but I can't get it to work properly on
my machine, so I can't make it work for you. The syntax is
=CELL("filename") which ought to return the path and filename of the
current file, and which you could then trim down to show just the path.
Can anyone provide some guidance here?
If it isn't working for you, it pro...Combo
I am able to create a list of items with a drop down menu. I can
select specific item but how do I select all item to get a query
Your help would be much appreciated.
You can't select multiple items from an Access combo box. To do that would
require a listbox with it's MULTI-SELECT property set to SIMPLE or EXTENDED.
See more info about list boxes here:
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post ...Disable people picker in a sharepoint list
I would like to disable the users/groups picker field in a SharePoint list
I managed to disable the field itself (text box) but it's still possible to
click on the "Browse" button and search for people that then get eneterd in
Is there a way to disable the browsing?
Thank you in advance,
I think you will delete that column.
1. Settings>List settings>Click you wnat column name on Colums category.
2. Click "delete" button.
And then you can make other column.
> ...Combining Lists within excel.
I'm hoping someone can help here. I'll try to explain the
problem I have.
I have 2 worksheets both containing a product list. I have
entries on one worksheet which I need on the other, so
basically my question is... might there be a way of
combining these two lists so one updates the other with
the missing entries.
Help on this would be great, as they are very large lists
which I dont much fancy the thought of looking through
Are you familiar with the VLOOKUP function? I use it all the time for this type
vlookup(Product cell in first sheet, Array...filter records in a form
I've created a form with its subform to enter tasks of employees. however I
need filter records only for active employees
The form has as a source, the table CARD_EMP (employee card). It has a field
ST_EMP for the employee status (Active , Pasive)
In the Event Form_Current I wrote
but it doesn't work
Thanks for advance
Message posted via http://www.accessmonster.com
Your advice was the solution
Thanks a lot
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscodin...MFC DLL Dialog Box
I am trying to link a MFC DLL to a MFC executable. The MFC DLL has a
dialog template in it and has one entry point function in it. Dialog
box template has the corresponding class as CLoadDlg.
>From the executable I call the entry point function. Everything is
working fine till this point. Now in entry point function I am creating
a dialog box object and trying to display the dialog box (by calling
DoModal). But this is not working and I see an assertion failure.
Can someone give me some hints on how to get this dialog box up from
extern "C" ...User accout shows new email
On start up a message shows in my user account that I have new email messages
but am using Outlook 2003 and all incoming emails have been deleted. How do I
clear the message
...Services Invoices Get "DROP SHIP" box checked Automatically
This is a multi-part message in MIME format.
Hello Everybody, Here is another story.
we are GP 10 SP3 and we also a Field Service (Depot Module) installed =
for which we use an Invoice ( SVC000000) and our type is Service type =
At the time of posting the Service Charges being generated by the Depot =
Module, the Drop ship box gets checked automatically for which we can't =
charge the customer for shipping charges.
Basically we eve...drop down lists #7
I haave a drop down list which is in a table. When I change the selection (on
the list) I want another cell in my "price column" to change value with it.
Is this possible?
You could create a list with values relating to the items in your
Set up on Sheet2 in cells A1:B100 a list with Item in A and price in B
Supposing your Column with the dropdown is Sheet 1 column A, and your
Price column is column C. In C1
"Vivek" <Vivek@discussions.microsoft.com> wrote in message
news:B16A028...Pivot Tables filtering data
Using Excel, I have query(using an ODBC connection) of all customer order
detail over a two year time period. The detail for each customer is
different in that some customer have multiple orders, and the amount of
individual sales parts they order may be 1 or 100. My query gathers detail
by order line item. We were able to provide management with comparative
Now that we have shown this report to management, they want three things
that I'm unsure how to provide. 1) Customers that are new in the current
year2) customers that had orders in both years, 3)customers that ...How do I get a list of data on one sheet into the form on the fir.
I have a timecard form on the first tab of a workbook & the various employee
crew combinations on each of the subsequent tabs (each crew on a seperate
tab). How do I format the for to get the employee name info from the
individual crew tab required?
Let me clarify my question - I am trying to use the first tab (the form) as a
constant form & just change the employees names in that specific field based
on the crew I want to generate the timesheet for. The crew lists are on the
sugsequent tabs. I would like to be able to select the crew & print the form
with only those emp...Having marketing lists in outlook as Distribution list
We have already CRM specialized Distribution lists for contact, lead,
accounts, we should also find here all the marketing lists owned by the user
and with members accepting email contact.
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 the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microso...How can I delete a line created with Shift+underscore?
I can no longer select this line, so how can I delete it. When I search help
for how to delete a "rule," it brings up everything BUT what I'm talking
I'm using Office 2007, and ever since it was installed, I can't find
anything and stuff happens that makes NO sense at all. How and why did that
simple underline become some permanent fixture in teh email I'de REALLY LIKE
TO SEND, NOW.
Please help! Outlook Help is Useless! WCW
That line is actually a "Border Line". Try the following:
- Select eveything above and below the line
- Select the FOR...Add record and update List
This message has two questions:
When I click my command button (Code Below) I need it to open the form in
ADD mode but still linked to the Parent form as it is doing now.
Second, that Parent form has a list box that needs to be updated when the
record is added.
This is the command button form:
Private Sub cmdProvADD_Click()
On Error GoTo Err_cmdProvADD_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "f_ProvDetail"
stLinkCriteria = "[ICNNo]=" & "'" & Me![ICNNo] & "'"
...In excel, how do i create a box on a form for a customer to click #2
how do I create a box on a email excel form for a customer to click on to
acknowledge they agree with the terms and it automatically put a check mark
in the box.
...alignment within text boxes
within a text box, how do I keep the text lines in the heading flush left and
make the body justified? I make the heading flush left, then highlight body
and justuify it-- but when I do-- the heading becomes justified.
Select the heading (high-light) click left justify.
"rebecca1227" <firstname.lastname@example.org> wrote in message
> within a text box, how do I keep the text lines in the heading flush left and
> make the body justified? I make the heading flus...