Special Pasting a work book with many sheets and formulas
I have a workbook with many sheets that all have formulas and links to other
data. I want to save the workbook as another name with all the worksheets
keeping the values only (no links or formulas). Is there a quick way to do
this for everysheet without having to special paste every sheet in the
workbook. So can I save everysheets data values at workbook level.
See this page for a code example
Regards Ron de Bruin
"lex63" <firstname.lastname@example.org> wrote in message news:ED708...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...Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA)
Hello Excel Problem Gurus,
First of all, let me thank you in advance. I find it exemplary that
you all can devote time to helping others who are having issues with
their work. Hopefully one day I can be at a mentor level, and help
Hope you can help! I have an issue where I don't know how to write the
formula that I need without going over on the nesting. The current
formula that I have is as follows:
Data",IF(V7="Yes",&qu...How do I set up a daily average of unit sales formula
More info required.
(remove nothere from the email address if mailing direct)
"jim m" <jim email@example.com> wrote in message
...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:
&...multiple email identities
HELP! My husband and I share the same computer and we
have our email come to our inbox through Microsoft
Outlook. However it is merging our accounts- how do we
seperate into 2 identities so we each get our own mail! It
is so frustrating! Please help!
Outlook does not use Identities - it uses profiles.
See this page for more information:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual account will be deleted w/out
After s...Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching
forever and havn't found a hint yet.
I have multiple domains setup on my exchange server. Lets say abc.com,
def.com, and hij.com. We only send email with @abc.com but can receive
from any domain name. Recently we merged with another company and we
brought back their email to our server, lets say xyz.com. Now I
configured a new recipient on Exchange 2003, so I now have two
policies. The first policy has the three original domains in it with
@abc.com as the primary domain. In the second policy I have configured
xyz.com t...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 ...How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the
current form field. This bit of code is attached to the GotFocus
event of all fields and the Enter event of all subforms:
gxCurrentField = Me.ActiveControl.Name
However it doesn't work properly when changing records in a subform.
My parent form contains two subforms in a many-to-many relationship.
The above variable usually ends up containing the name of the first
field in the second subform when switching records in the first
How to correctly code this? Or is there some native variable I'm not
aware of? I...Format for credit card numbers
I've tried a custom format for entering credit card numbers (four groups
of four digits, separated by dashes: xxxx-xxxx-xxxx-xxxx.
I have tried to use ####-####-####-#### and 0000-0000-0000-0000 but
each of these causes the last digit to change to zero. So if I enter
5415779800902512 I get 5415-7798-0090-2510.
Anybody already solved this problem?
Schmacker's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28041
View this thread: http://www.excelforum.com/showthread.php?th...Accommodating for empty cells in this formula?
I have a formula in cell H21, for example, reads like this:
is there a way to adjust the formula so that an empty cell in G21 doesn't
give the #VALUE! in subsequent cells in column H?
Just to give a similar example, this formula =SUMIF(A1:A9,"<>0") adjusts for
any and all empty cells in A2 to A9. It no longer matters if any of the
cells are empty, the formula correctly gives the correct addition of A1
plust a sum of everything between A2 to A10 without any #VALUE! results.
Was hoping to have the formula above als...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...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?
...Help With Margin Formula
I need help with a margin forumla (calculated from retail). Say I have a
cost of $10.00, and I need the formula to calculate a 40% margin from
retail. So the retail should end up at $16.67. Not sure how to get from
$10.00 to $16.66, I just know the cost and the margin I need to make.
"JR" <firstname.lastname@example.org> wrote in message
> I need help with a margin forumla (calculated from retail). Say I have a
> cost of $10.00, and I need the formul...limit the number of outgoing messages
who can I limit the number of concurrent outgoing messages?
for example: if I have a queue of 1000 messages, how can I force
exchange to send only 50 messages at a time?
...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...Removing random extra spaces
I have a column for comments
there are 900 rows (A1:A900)
this data is being imported from another source and some users have
extra spaces that I want to remove and place in (B1:B900)...I also want
to format it so that it is converted from all caps to all lowercase.
A1 reads "INT IN A FREE QUOTE ON 50000 CASH FOR DEBT
B2 reads "int in a free quote on 50000 cash for debt consolidation"
jermsalerms's Profile: http://www.excelforum.com/mem...Opening Multiple Web Links in a Column
I am very new to using web links in excel. A task I do very often is
open a list of different websites that are in various columns in an
excel spreadsheet. I am quite sure I am doing it the slowest way
possible, so I need some help please. Basically I have been clicking
on one link at a time. When I do this, the first website opens and
excel automatically minimizes, then I have to go re maximize excel and
then click the next web link and the same thing happens, etc... very
time consuming. I am wondering if there is a way, either through Excel
or whatever means necessary, to open all...Removing spaces from text #4
I'm in excel and i have a bunch of text data that has an extra space at
the end of the text on the right hand side for each cell. Is there any
easy way to remove this space?
Use the TRIM() function.
"lj" <email@example.com> wrote in message news:firstname.lastname@example.org...
> I'm in excel and i have a bunch of text data that has an extra space at
> the end of the text on the right hand side for each cell. Is there any
> easy way to remove this space?
I tried using that function but the results st...Remove headers in Outlook 2003?
I have the weirdest problem,
From certain people that send me e-maols, the entire header is shown, all
the technical gobbleygook that I really don't need to see and it causes the
message to be 1) long ans 2) hard to read through all the techno-stuff.
Most people that send me e-mail, I just get the message, am wondering what I
need to do? Am I missing a setting in Outlook "03?
(For some backround info-actually have Office '07 but had to remove it and
install Office '03 for a few weeks due to a technical issue on my part)
Any help is appreciated,
"Jeff"...multiple iterations of same query
Running Access 2003 on Vista.
I have a query that chooses 15 records at random. This works fine.
What I want to do is run the same query for approx 110 different users, each
with their own randomly selected 15 records. Obviously, I want to avoid
manually running the same query that many times. How can I get around this?
Post your query SQL.
Build a little, test a little.
> Running Access 2003 on Vista.
> I have a query that chooses 15 records at random. This works fine.
> What I want to do is run the same query fo...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.
...Numbering in Book Files
I am creating a tech manual where each chapter is its own file. I have
created an outline numbered list and saved the list in a template that I then
use to create the new chapters. However, I am finding that when I go into a
new chapter that the outline numbering does not pick up on the chapter
(Heading 1) number. For example:
Chapter 1: Heading 1 style
1.1: Heading 2 style
1.1.1: Heading 3 style, etc.
But when I start my next chapter, when I update the chapter number to start
at 2, I get this:
Chapter 2: Heading 1 style
1.1: Heading 2 style
1.1.1: Heading 3 style, etc.
...Formula to count the number of different values in a range
I'm looking for a formula that will give me the number of different values
in a range.
Example: Column A may have five cells that are "4", five cells that are
"7", five cells that are "9". Of the fifteen cells that contain data, there
are only 3 different values. I'd like to use a formula that will count the
number of different values in column A, in this case the result is "3".