A co-worker was working in a regularly-used workbook. Suddenly a second, seemingly identical workbook opened; the two were named *.xls:1 and *.xls:2 respectively. A week ago, a similar situation happened with the same workbook, except the duplication occured upon opening, rather than after it was already open. At that time, when we closed one of the "versions" the colon-number additional extention disappeared. But after closing the remaining document and reopening, the duplication appeared again upon opening. Can anyone tell us what this means? Did she accidentally hit a comman...How do I create a sample in Excel?
I am trying to create a sample, needing every 20th record out of around 3000
You need a VBA procedure.
Dim RowNdx As Long
Dim DestRng As Range
Set DestRng = Worksheets("Sheet2").Range("A1")
For RowNdx = 1 To 3000 Step 20
Set DestRng = DestRng(2, 1)
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Mary" <Mary@discussions.microsoft.com> wrote in message
news:ADE0AD7F-B459-41AE-8B2...Can I copy radio buttons so that the second set is independent of.
I have a group of four radio buttons that all point to one cell. My goal is
to create a second set that looks identical to the first but which points to
a second cell. This is for a questionaire that will have many questions with
the same four answer values. I want to be able to quickly create 100 button
groups that will each update a separate cell for scoring of the questionaire.
There are optionbuttons on the Control toolbox toolbar and there are
optionbuttons on the Forms toolbar.
Each has different behaviors.
If I had to use lots, I'd use the Forms version.
Here's a pos...Worksheet Auto update
I need to find a way to automate a process.
Is there a way to automatically replace the content of a worksheet with the
content of another one?
Every morning I get a sales report in excel for the previous day sales. I
save it in a folder and then I do a pivot table on this sheet to determine
sales by product category for example.
The following day, I open the previous day file, replace the sales report
with the new one and then refresh my pivot table.
Is there a way to have my sales report update anytime I get a new sales
To be more clear
I have a workbook with two tabs: Pivot...why does sorting change a scatter plot graph?
Why does the way a spread sheet is sorted change the look of a scatter plot
graph??? the graph is just a plot of two points, (X, Y) and these two points
are definded by two collumns for a given row. The two collumns don't change,
and the row all stays together, so why does it change where points are
plotted out on the graph when you re-sort it?
Usually, for an XY (Scatter) chart, with values of X in a column and
corresponding values of Y in an adjacent column, for three or more points,
Excel assumes (correctly) "Series in Columns."
But, when you have only...Can't create Organizational Forms Library in Exchange 2003 with SP
I cannot create an Organizational Form in EFORMS REGISTRY folder (from First
Administrative Group->Folders->Public Folders->EFORMS REGISTRY in ESM). When
I right-click the EFORMS REGISTRY folder and select New, there is no
Organization Form. Instead, I only see Public Folder in the popup menu. Do
you have any idea why Organizational Form menu does not show?
My Exchange Server is Exchange 2003 with SP2. The login user is Administrator.
Could you please help me? Thank you very much.
Is that account member of "Enterprise Admins" group?
Yang Zhang wrote:
&...Mail will not Send/Receive automatically
I have outlook set up to send/receive every minute but it suddenly stopped
doing so. Anyone have ideas why?
Several. For starters, a one minute polling interval is just nuts.
It is difficult to determine why automatic polling is failing when you do
not post your mail account type, connection type and polling settings. If
automatic polling once worked and now fails, you also need to examine what
changes were made to your setup before automatic polling stopped working.
In general, here are the reasons automatic polling might fail in Outlook:
1. You have created an unrealistic po...How do I create a click on + symbol to open a root and click on -.
I'm looking to create an excel file with drop down menus.
I'd like to have a category. Click on the "+" symbol and the category opens
up and shows all of the subcategories.
Each category can further be opened if I so choose.
Each category can be have a number total associated with it.
When you click the "-" symbol. The subcategories close and the sum total of
all subcategories is shown in the category total.
example. creating a budget.
Category is utilities
sub categories are: phone, cable, electric, gas, etc...
Monthly utility total ...Problem with macro assigned to custom toolbar button
Problem with macro assigned to custom toolbar button
I am having a probelm with macros assigned to a custom button on
custom button. I am using excel 2000.
1. I have created a macro called "Jump" in a workbook named "Test1"
2. I then created a custom toolbar and added a custom toolbar button t
3. Through the customize dialog box I assign the Macro "Jump" to th
Everything works fine UNTIL.
If I do a SAVE AS for the workbook "Test1" and call it something els
like "Test2" and then close "Test2" an...Sorting on Column headers
I have a spreedsheet that someone else created and I need to take the
Column headers, which are in date form, and rearrange them in
chronological order. Can this be done without cutting and pasting? I
really need to save time with this project if possible.
Message posted from http://www.ExcelForum.com/
> I have a spreedsheet that someone else created and I need to take the
> Column headers, which are in date form, and rearrange them in
> chronological order. Can this be done without cutting and pasting? I
> really need to save time with this project if possib...how create Quota filter in WIndows 2003 R2 using Script
I need create quota filter in Server 2003 R2 using vbscript. quota
filter should be applied to directories and not by users.
I searched information about it on google without success.
thank's in advance
First you need open your FSRM (File Server Resource Manager), then you
create a quota template, you must specify if your quota is "software" (just
monitoring, but never deny the user) or "hardaware" (deny users when they
use 100% of the quota), you must specify if you want send e-mail to user
when this user use...Outlook 2003
In Outlook 2003,
#1 Is there a way to refresh the unread folder so that read
messages no longer apear? Right now I have to click closed the unread
folder and click it again
#2 Is there a way to create a toolbar button that goes directly to
...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...creating a spredsheet and log the info into another spredsheet
I have a excel sheet that is printed out and a cashier manual enters
information, invoice number, invoice amount, cash amount, check
amount, amex amount.... I would like to have the cashier input this
information on her PC and print a copy to go along with the deposit
and at the same time log the information into a google excel document
I created. Any ideas how this can be done?
...Creating Exchange 2003 organization
Is it possible to have two Exchange Organizations in the same domain? I need
to reproduce a problem and was hoping to install an Exchange server to an
existing domain however I need the organization to be different. Is this
possible? When I installed EX 2003 I wasn't prompted for information other
than location of files.
Thanks in advance
On Mon, 28 Feb 2005 08:09:03 -0800, "RP"
>Is it possible to have two Exchange Organizations in the same domain? I need
>to reproduce a problem and was hoping to install an Exchange server...Why will my publisher 2003 not print graphics?
I have recently loaded windows 7, and since then I cannot print any graphics
from any publisher document, text and infills print but lines do not! I have
looked at the advance printer settings and the "Do not print any graphics"
box is not ticked.
I have also tried reloading publisher but this did nothing. Any ideas anyone?
Might take a look at the web site of your printer model to see if there are
Windows 7 drivers. Will the document print okay if you convert it to PDF?
There are free converters around. www.primopdf.com is free.
It is always wise to completely remove ...Setting Defaults in New Item Wizard
How can I set a default value in the New Item Wizard? I want to always use a
barcode type that is about 10 down from the top and I want Taxable Item to
always be checked. Help...
Good question, I need an answer too.
"A StanTech Associate" wrote:
> How can I set a default value in the New Item Wizard? I want to always use a
> barcode type that is about 10 down from the top and I want Taxable Item to
> always be checked. Help...
You can set the default sales tax under Manager, File, Configuration, Sales
Tax, Default item tax group.
To set a default barcode type yo...Can't create the item #2
I use Outlook from MS Office 2003 Business Edition.
Everything has worked fine until the past few days. Now,
whenever I click on an E-mail address link inside a
webpage, I get a message from Outlook that says "Can't
create the item."
One person on this group gave me the following advice:
>Close Outlook, find and rename the frmscache.dat to .old
I did searches on all my drives and the file named above
was not found. I doubled checked the search to confirm
that it included hidden files and system folders in the
search. Still no luck.
...Sorting Cells by Colors
Is it possible to write a VBA code to sort excel cells by colors, and the
followed by other criterias, as in the normal sort?
Thank you in advance.
See Chip Pearson's Sorting By Color page at:
"swiftcode" <firstname.lastname@example.org> wrote in message
> Hi all,
> Is it possible to write a VBA code to sort excel cells by colors, and the
> followed by other criterias, as in the normal sort?...new activity not in the appropriate queue
I installed the Rollup 3 for MS CRM 4 and since then all created activities
are redirected to the users assigned folder in queue and not in progress(my
current activities) folder!
It's not logical because a new activity is not yet assigned to a different
user to be in the assigned folder !!
I can't believe this is on purpose and I DON'T have a workflow on this.
Can someone tell me how to fix this?
...creating template for multiple emails
How or can one create an email template (same subject line
and message)for multiple emails (approx 100's)?
Needing to shorten the time it takes sending 100's of
individual emails (with the same subject line and same
message) to sales staff on a weekly (some times daily)
basis. Company does not want sales force using other
sales persons email addresses (they are contractors).
Try using a Distriburtion List, send one message, it goes to all of them, or
get the message ready, put your address in the TO: field, and put everyone
else in the BCC: field?? That way no one can see wher...Fulfillment type orders
We have orders at the initial status (just entered) and the options to allow
delete documents and void documents are enabled on the Sales Order Type.
However, we can't get a void or delete button unless we move the fulfillment
order through the confirm process to an "Invoice" to get a Delete?
What's up with this? Very annoying.
I know it is subtle and wish there was a better way to display it, but the
Void option only applies to Invoice type IDs and not Fulfillment Order type
IDs ("Void Invoice Documents" vs. "Delete Documents"). Since both t...Excel List Sorting Problem (Descending)
I'm having trouble sorting my list--my column contains *only* 4-digit
numbers but when I click on "descending order", only about the first half of
the rows are arranged this way, before it begins again to arrange the rest in
Has this problem happened for anybody else? I'd appreciate any help you can
Part of your list is text, although it looks like numbers.
Format an empty cell as number. Enter the number 1. Copy. Select your
"numbers". Edit>Paste Special, check Mul...Find tab in worksheet
I have a workbook with many tabs & many users and would like to create a 'Go
to / find' function that finds a particular tab when opening workbook, so
that user will enter tab in text box and will then go directly to tab
Try any one of these macros..
You can try out the below macro. If you are new to macros..
--Set the Security level to low/medium in (Tools|Macro|Security).
--From workbook launch VBE using short-key Alt+F11.
--From menu 'Insert' a module and paste the below code.
--Get back to Workbook.
--Run macro from Tools|Macro|Run <selected mac...How do I create upper/lower case letters in cells?
I have a large spreadsheet with names/addresses that are all capitalized. I
want to make them upper and lower case (SMITH = Smith). What's the formula?
You could create helper cells with this formula
> I have a large spreadsheet with names/addresses that are all capitalized. I
> want to make them upper and lower case (SMITH = Smith). What's the formula?