Can data validation be set up to accept a 0( (zero) or any whole number
between 25,000 and 10,000,000? Or does this have to be controlled with VBA?
This needs to work with xll03 and later versions
This DV formula should work fine:
Joy? hit the YES below
> Can data validation be set up to accept a 0( (zero) or any whole number
> between 25,000 and 10,000,000? Or does this have to be controlled with VBA?
> This needs to work with xll03 and later versions
One worksheet has 600 + lines with a lot of expenses, including SOME of the
local expenses. This is a check register..
Another worksheet has 300 + lines with ONLY local expenses.
Trying to get ALL expenses together, but eliminating the duplicates from new
list. Thinking B2=date. C2=name, E2=amount - - SO B2&C2&E2 on first long
worksheet and then the same on short worksheet... Bring BOTH over to new
tab and then stuck. Any ideas greatly appreciated, or another better way to
You could use excel filter:
Data - Filter - Advanced Filter - Unique records on...Which Office X 10.1.5 duplicate fonts can be removed from which folders?
Which of these duplicate fonts can be removed from the
Applications/Microsoft/Office X/Office/Fonts folder AND/OR the
All of the following are duplicated in the two folders. Two of them, Times
New Roman and Verdana, also are in OS 10.3.3/Library/Fonts.
Comic Sans MS
Copperplate Gothic Bold
Copperplate Gothic Light
Edwardian Script ITC
Times New Roman
On Tue, 6 Apr 2004 04:42:59 -0400, Norman R. Nager, Ph.D. wrote
(in article <...No data in my journal!
I'm new to RMS and have recently installed our first customer with RMS 2.0 So
far, we have gotten everything installed working to the customers liking
minus a few things here and there. One of these things is that reprinting a
receipt or reprinting from the journal doesn't seem to work. It contains no
data in the journal to do any kind of reprint. Is this an option i have to
enable to retain receipts in the journal?
Yes - you need to check mark "journal receipts from this printer" in the
receipt printer tab / tabs of your register - in SO manager go to database -
regi...view data from one table update and save to another table
I have a tabl do this without amending te with item data which I sow on a
form to create a purchase order, where the item data may require amending
before publishing to the supplier. How do I do this without amending original
data which for audit purposes must remain as original.
"Bloggsy" <Bloggsy@discussions.microsoft.com> wrote in message news:74D11113-3C3F-441F-8031-FA31035ED0B7@microsoft.com...
>I have a tabl do this without amending te with item data which I sow on a
> form to create a purchase order, where the item data may require amending
> before publish...Clear contents of last two rows of data on sheet
I'm using v 2003.
I need a couple of lines of code that will delete or clear the contents of
the last two rows on a sheet that have data in them. In other words, if there
are 800 lines of data and I want rows 799 and 800 to be deleted or contents
cleared. The number of the last row varies everytime I run the report.
Can anyone help? Thanks!
Here are 2 options. See the comments for when to use the option.
'When a specific column will always have data in last row.
Dim lastRow As Long
With Sheets("S...Scatter Chart Data Point Highlighting
I have a scatter chart with smooted lines and no data markers tha
represents a (one) mathematical function. Is it possible to highligh
(mark) one data point and from that point draw parallel (dashed) line
to the x and y axes?
By hovering over the chart you can pop up the data values but I wan
(if possible) the parrallel lines to better visualize the position o
the selected point on the axes
rvExcelNewTip's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1566
View this thread:...Convert calendar data
I am trying to export my calendar data from one program into yahoo.
Here is the current format layout in a csv file:
Subject, Start Date, Description, Start Time, End Date, End Time.
Here is the layout that I need it to be:
Subject, Start Date, Start Time, End Date End Time, All day event
1. I need to have the Description field moved to the end of th
2. The Description data from the current layout needs to be to be unde
the Subject header not the Description.
2. The new All day event field needs to be added and populated wit
3. And I think each data ...XML heading on the Data menu in excel?
Mine is missing on my newly installed copy of MS Office Professional
Enterprise Edition 2003. It is also missing the XML Schema tabs in Word!
I need to know how i can find XML please help...
email me at email@example.com
If the XML item is missing from the Data toolbar you might try resetting
your menus. Select View, Toolbars, Customize. On the Toolbars tab select
Worksheet Menu Bar near the end and click Reset.
"karenButterfly" <karenButterfly@discussions.microsoft.com> wrote in message
news:BFEA2D2A-3EB0-45CC-990E-F16BCBD2F965@micro...enter data in cell which will start macro to move data to sheet2
I have two sheets, one sheet has name, score, handicap, net score. I have a
macro that I run after I enter the new score and it updates sheet2. I would
like to enter data on sheet1 and it auto update on sheet2. The column's are
a, b, c, d.
I update column b. When it updates it needs to take column (a) name, and
column (b) score and update it on sheet2, with the lowest score first. Again
I have a macro that I start and update after I've finished entering the
scores, just looking for a quicker way to do this.
...Duplicate data from field into another field in same form?
Can I duplicate data from one field on a form into another field in the same
On our exhibitor entry form, the Program Contact info (fields for name,
address, phone, fax, email) is entered first. Mail Contact info is often the
same, but not always.
Is it possible to autopopulate the Mail Contact with the data from the
Program Contact, but allow me to enter new data if necessary?
If so, can you tell me exactly how?
On Fri, 23 Mar 2007 09:46:24 -0700, Andi <Andi@discussions.microsoft.com>
>Can I duplicate data from one field on a ...Filtering out Data
i have a spreadsheet, were i want the user to input all data onto the first
I then want to be able to transfer, certain rows based on set criteria to
Is this possible using any excel functions, or does it require me to use
macros and or programming
Use rhe Advanced Filter feature on the Data menu.
Debra Dalgleish has an excellent tutorial on Advanced Filter at:
Note particularly, Debra's instructions for 'Extractng data to another
&qu...Some questions about crm performanse on large amounts of data
Hi all! Our organization planning to use ms crm solution. We have
about 3 000 000 of customers, and we worry about performance on this
data. Can anyone of you manage relative amount of information? Where i
can read about it?
On Feb 16, 6:14 am, "Alexandro" <non.alexan...@gmail.com> wrote:
> Hi all! Our organization planning to use ms crm solution. We have
> about 3 000 000 of customers, and we worry about performance on this
> data. Can anyone of you manage relative amount of information? Where i
> can read about it?
> Thank you.
i m someone wor...group & summarize diff rows of data that have something in common
I am trying to arrange a large amount of data (inventory) in 2 different
ways. 1) Group all identical parts into one row and 2) Group all identical
locations into one row. I dont know how to do this. I am dealing with over
3,000 rows. Any suggestions?
Depending on your workbook layout, you may be able to use a pivot table
to summarize the data. There are instructions in Excel's Help, and Jon
Peltier has information and links:
> I am trying to arrange a large amount of data (inventory) in 2 different
&g...Receiving duplicate emails
I have just recently created my email account in
Microsoft Outlook and now when I receive email I get the
same one 15 times (and that is no stretch!) Is there
something I have done wrong? How do I fix this?!
What version of Outlook do you have? What sort of mail account(s)? Do you
only get a single message many times, or all the messages many times?
This posting is provided "AS IS" with no warranties, and confers no rights
"Carrie" <firstname.lastname@example.org> wrote in message
news:email@example.com...Sort column containing different data types
Can anyone help, I have a column with project codes in the following format
Is there any way to sort the column by the numeric values to the left of the
character symbol only, so that it reads:
102/3 and not 123 result with normal sort
Is there any way round this other than separating the code into separate
My Excel add-in Special Sort will sort by the first group (or last group)
of numbers in the cell entry. It sorted your numbers as follows...
1...Duplicate, Duplicate, dupli ...
I'm new to the group, so hope I don't disgrace myself.
I have a list of names in the first column, and their respective postal
codes in the second. Unfortunately, many of the names, (and respective
codes), are duplicated... sometimes there are up to four of the same name,
(and code), under each other.
Is there a way to get rid up the duplicates and make a usable list please? I
can do it manually of course, but ..
Data>Filter>Advanced Filter. "unique records only" and "copy to another
For more on this visit Debra Dalgl...Quit creating duplicate desktop icons when doing upgrades/hotfix
Upon any sort of upgrade or hotfix, RMS creates a whole new set of desktop
icons. What a pain! Pls fix. Ask if we want to create new desktop icons,
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.microsoft.com/Businesssolutions/Community/NewsGroups/...Easiest way of moving CRM 3 data to new server
We setup all of our CRM 3 data on an old server. Now that we are using CRM
for real, we have ordered a nice new shiny box for CRM to run on.
Is there an easy way to move the CRM data across from the current box to the
new one? If not, its not a great problem, but would save a lot of boring jobs
for someone here.
Check the Implementation Guide for the recovery options. You can follow
those basic steps to "restore" the data to the new SQL box. Another option
would be to explore the Redeployment Tool.
MVP - Microsoft CRM
"Oliver Marshall" <O...How do I duplicate numbering on a raffle?
I am creating an event ticket but would like to number the tickets on both
the left and right sides of the ticket.
Create a data base with your numbers. Use mail merge for the tickets. You can
insert a mail merge field on both sides of your ticket.
When you merge have one ticket on your screen. What version Publisher are you
using. Some early versions of Publisher shows all the merge items the same in
print preview. This is a Publisher bug.
Mail, e-mail, and catalog merge
"Candi...How to delete "non-identical" duplicate records in an Access table
How to delete "non-identical" duplicate records in an Access Table? Where
"non-identical" duplicate record means a record in the table that has
slightly different datum in one of the fields, but an identical duplicate
datum in the field that I am concerned with. For example:
SSN MRN CLIENT NAME
001-00-2222 11170419 Smith, Jane
001-00-2222 11170419 Smith, Jane T
001-00-2222 11170419 Smith, Jane Thompson
The data of these two records in the fields SSN and MRN are identical; but
"non-identical" in the CLIENT NAME field (notice...excel graphs are locked up; no dragging or additional data entry a
my excell graphs have locked up and do not permit additional data entry or
dragging. i note the file extension now has -group- next to it where it just
contained file name only before today. must have hit wrong button but can't
figure out what i have done. want to unlock graphs. thanks
Sounds like you have select multiple worksheets, which will cause the
[Group] to appear.
Right click a sheet tab and choose Ungroup sheets.
> my excell graphs have locked up and do not permit additional data entry or
> dragging. i note the file extension now ...Duplicate ItemLookupcode
Any clues on how I could get duplicate itemlookupcodes?? I found a few of
them recently. No SQL queries have been run to generate them and if I try to
create a duplicate itemLookupCodes I am stopped with a message telling me to
use a unique name. How could they have gotten in the database? Any clues,
boos or comments appreciated.
Thanks for all the help!
This is a multi-part message in MIME format.
As you mentioned, RMS Manager doesn't ...How? compare two worksheets and identify rows of data that appear on both.
Suppose I have 2 worksheets.
Sheet 1 has 1000 lines of data spanning xNumber of columns.
Sheet 2 has 500 lines of data, also spanning the same number of columns.
An unknown number of identical lines of data appear on both sheets.
How can I get to a point where I can build one worksheet that is a composite
of both sheets - such that no identical line of data appears twice on the
Thanks in advance, Simon.
You could do this several ways. It really depends on your data
integrity and what sort of data it is.
-- Use a VLOOKUP OR INDEX/MATCH formula to compare the 500 row...Questions on data security
if i set all MsOutlook client in my 2000 network with Exchange2003 in
"Offline use" what can be the advantages and the disadvatages ?
I say this because i think that in this mode is possible to have a double
security backup, one in each client on the network and one on the type of my
Is it correct my opinion ?
What do you think ?
Thanks a lot
The advantage would be faster local access and less stress on the server.
This is also ideal with servers located in remote offices or saturated
networks. The disadvantages is a latency in delivery (delivery notification