microsoft.public.excel.misc Google Group

Runtime Error 1004

jbba...@discussions.microsoft.com (JB Bates) — Thu, 24 Dec 2009 17:46:01 UT

I have a workbook that contains 100 worksheets. On each work sheet I have
the following code (see below) that runs and when a particular person is
selected from a drop down list a jpg of their signature displays at the top
of each sheet.
This was working fine but I am now getting the following error after I

2003 Excel Pivot table data selection

bhud...@discussions.microsoft.com (bhudson) — Thu, 24 Dec 2009 17:41:02 UT

I am currently trying to create a PT but my source data is more than the 65k
row limit. Can you create a PT using source data from 2 worksheets and if
so, How?

2007 version of Excel

ni...@discussions.microsoft.com (Nikki) — Thu, 24 Dec 2009 17:34:03 UT

How do I create a password so that the password is required upon opening the
workbook?

help with adding names

c...@discussions.microsoft.com (CHAD) — Thu, 24 Dec 2009 17:14:01 UT

can i add a word before a sum from a different sheet.
ie: i have a total on sheet 1, and on sheet 2 in a cell i place =then i
click on the cell that i want from shhet 1. but what i want to see on sheet 2
is the word TOTAL in front of the number that comes from the sheet 1 cell.
if anyone could help that would be great.

Rename Worksheet Tab as File Name Using a Macro

c...@discussions.microsoft.com (Cue) — Thu, 24 Dec 2009 16:45:02 UT

Hello,
I am trying to rename a worksheet tab using the name of the workbook. Each
code I've tried does not work. Does anybody have a simple macro to accomplish
this?
Thanks.

Excel 2003 printing problem--printing 1 document on 2 pages

b...@discussions.microsoft.com (Bons) — Thu, 24 Dec 2009 16:15:01 UT

Hi All!! I looked through the printing probs section and didn't see anything
like this....but I KNOW someone will be able to help with this. We have a
legal size spreadsheet with .7 left/right margins----it prints fine for most
of us....but I just emailed it to one of our branches and it prints on 2

Copying only subtotals

conniemar...@discussions.microsoft.com (Connie Martin) — Thu, 24 Dec 2009 15:43:01 UT

In doing Data>Subtotals and then clicking on the 2 to show only subtotals,
how do I copy and paste only those subtotals into another spreadsheet without
it pasting in all the data in between? Thank you. Connie

Creating formula in Excel

j...@discussions.microsoft.com (Josh) — Thu, 24 Dec 2009 15:36:02 UT

Hello everyone. I am trying to create a formula in Excel and need a little
help. I have created a workbook with my inventory in it. when the inventory
goes to a certail level I would like a cell to go from green to red. Red it
will say yes order and green will say no dont order. I know I need to use a

Top 3 scores

gi...@discussions.microsoft.com (Gilbo) — Thu, 24 Dec 2009 14:11:03 UT

I have a spreadsheet with columns A - Teams, B - HomeScore, C - AwayScore. I
want find how do i find the top three scores in homescore and also pick the
relivent info from column A & column C. I can find the top 3 scores with
LARGE(B4:B93,1),LARGE(B4:B93,2 ),LARGE(B4:B93,3),

Unhide a column among columns.

mow...@discussions.microsoft.com (Mowrya) — Thu, 24 Dec 2009 13:33:01 UT

Hi,
There are 10 columns which are hidden between two columns(A and X). I want
to unhide only 1 or 2 columns without enabling(unhiding) remaing How can i do
it.
Thanks and regards
mowrya.K.B.P.

Give blank in cell

b...@discussions.microsoft.com (bbc1) — Thu, 24 Dec 2009 13:13:01 UT

I have 10 cells in column A
A1
A2
A3
A4
A5
etc
What I require is if cell A1 is blank then blank in all cells, if A1 is one
then add one to each cell
ie if A1 =1 A2 =2

Automate copy / paste

u56...@uwe (PAULGOR via OfficeKB.com) — Thu, 24 Dec 2009 12:59:36 UT

Good day ,
I am asking for help with the following matter please.
I need to copy a single row on an XL database worksheet, and paste to another
workbook/worksheet.
In the 2nd workbook/worksheet ,I would like the 1st pasting to be entered in
a certain row , and each following pasting to be 1 row higher than the

Hyperlink via indirect cell reference

bab...@discussions.microsoft.com (BabyMc) — Thu, 24 Dec 2009 12:19:01 UT

Hi
I have workbook that contains a number of sheets. On a separate sheet I
would like to be able to insert a hyperlink so that I can jump to a specific
sheet.
However, rather than inserting all of the hyperlinks manually (I will have
to replicate this over many workbooks) I wondered if there was a formula to

Link Cell to cell in different file

wildw...@discussions.microsoft.com (WildWill) — Thu, 24 Dec 2009 12:01:01 UT

I have 2 x files, i.e. "1.xls" & "2.xls". I want cell C3 in the file 1.xls to
reflect the data that I have entered in cell C3 of the file 2.xls. How do I
do this?

Discontinous values in a column

f...@discussions.microsoft.com (FA) — Thu, 24 Dec 2009 06:49:01 UT

How can I fill in the empty cells in a column like the following :
4525980367
4525980560
4525988472
4526001271
4526005001
4526026221
4526051700
4526082664
4526131807
4526155800
4526174165
4526288621
4526336940
4526383124
4526384755
4526412139
4526454480
4526461206
4526463275

Counting no of days of a specific range of days from a list

manikan...@discussions.microsoft.com (Manikandan) — Thu, 24 Dec 2009 05:35:01 UT

I have a date range from month first to end of month. I want to count no of
entries from that list which range from 10th to 15th. For eg. a list starting
from 01.11.2009 to 30.11.2009. I want to count no of entries of date range
from 15.11.2009 to 20.11.2009.
Please help me....

Pivot Table Hide Selected Field 2007

mmasa...@discussions.microsoft.com (M Masalha) — Thu, 24 Dec 2009 05:13:02 UT

Dear Excel experts.
I have a Pivot Table (Excel 2007). The table reports monthly expenses,
monthly budget numbers and full year approved budget by product (example,
pens, books, computers, etc.). There is a calculated total field to add all
numbers (monthly expenses, monthly budget and full year approved budget) for

Macro or formula to compare columns and give a result of the odd o

rhe...@discussions.microsoft.com (Rhett C) — Thu, 24 Dec 2009 01:53:01 UT

User State Plate User State Plate User State Plate
jmolini OK 2MO980 mboulette OK 2MD980 jbradley OK 2MO980 1
jmolini TX 30VVF8 dfoose TX 60VVF8 awright TX 30VVF8 1
jmolini TX 4D0U558 dherrera CA 4DOU558 awright CA 4DOU558 1
I need to compare entry from three different users. The user names are in

blink a cell

v-d-o.5787...@excelbanter.com (V-D-O) — Wed, 23 Dec 2009 22:26:42 UT

how do I mak a cell blink
Tar very much

Chart Area Expansion

no...@cork.roadrunner.com (Tony P.) — Wed, 23 Dec 2009 23:57:28 UT

Hello All,
I am attempting to expand the viewable area of a standalone chart sheet
produced from a table on sheet 1.
When you look at the Chart Area there is a grey border around it but I have
seen examples where the Chart Area has been increased (resized) so that the
whole of the screen looks white with the background of the chart cleared to

=SF_Load!A2

j...@discussions.microsoft.com (Jim) — Wed, 23 Dec 2009 22:39:01 UT

Hello,
how would I change this formula (=SF_Load!A2) so it shows a nothing if the
cell it's refeerencing is blank. It currently shows 0.
Thanks

Excel 2007 Charts, Format data point.

bligg...@discussions.microsoft.com (B. Liggett) — Wed, 23 Dec 2009 22:23:01 UT

I have several column charts displayed on a tab sheet (worksheet) of an Excel
2007 workbook. Some charts have a single series of data, others have more
than one series per category. I want to visually differentiate some of the
columns/bars in a series as representing older (vs. current) data. I can do

Combining Print Jobs Together

d...@discussions.microsoft.com (db) — Wed, 23 Dec 2009 22:00:01 UT

I have a financial statement workbook. I have a dropdown that lists our 3
locations and "all" for a combined Income Statement. I select all,
print,select loc 1, print, select loc 2, print.... Then i print a blalnce
sheet form a seperate sheet in the same workbook. I take all of this to our
copy machine and make 10 stapled copies of the full "report". If i have a

Standard Toolbar

k...@discussions.microsoft.com (ksal) — Wed, 23 Dec 2009 21:50:01 UT

On my standard toolbar the options (file, edit, insert, etc) appear several
times. Is there a way to change this.

When dividing by 0 can i show a result of 0 instead of #DIV/0

davi...@discussions.microsoft.com (daviddm) — Wed, 23 Dec 2009 21:10:05 UT

I have a formula that divides the quantity in one cell by the quantity in
another cell to give me a result in a third cell. It's designed to give me
labor rates. The problem is if I have a particular item I don't need the rate
for it I type in 0. That give's me a#DIV/0 result. Is there a condition I can

help with autosort

thegr812k.43o...@thecodecage.com (thegr812k) — Wed, 23 Dec 2009 21:01:05 UT

Hi i wonder if anyone can help this might be really basic but i cant get
my head around... what im trying to do is autosort a list of names which
have a cell next to them with a value ie:
column a column b
bill 32
bob 27
john 98
dave 99999
chris 26
now each name has a corresponding number, i want to beable to sort by

Moving range?

wx4...@gmail.com (wx4usa) — Wed, 23 Dec 2009 20:59:57 UT

I have Months in B1:M1.
Dollars in B2:M2
I need a formula to return the sum dollars of a range of consecutive
months that is variable such as.....start month is in cell a1 and end
month is in a2. a1=March a2=October
Thank you so much for your help!!

Copying conditional formating

homerono...@discussions.microsoft.com (Homero Noboa) — Wed, 23 Dec 2009 20:40:02 UT

Question:
I want every cell in row 2 to have red background if its value is different
than the corresponding cell in row 1.
I can do this to cell A2 if in the conditional formatting field I say
=A2<>A1 but when I copy the formatting (using the brush), the condition
continues to be A2<>A1 and not B2<>B1 for cell B and so forth.

complex count formulas using multiple criteria in different ranges

nutmeg...@discussions.microsoft.com (Nutmeg007) — Wed, 23 Dec 2009 20:06:01 UT

I am trying to calculate a count, if a range of cells meets multiple
criteria. This formula is in an existing worksheet that I inherited and it
works as it currently exists to give me the count of items that meet the
criteria of being both (1) account type # in cell range $U= "50000" and the
value in Cell range $X is a value (ie is not blank or negative). See formula

Conditional Formatting

lightb...@discussions.microsoft.com (lightbulb) — Wed, 23 Dec 2009 19:43:01 UT

I'm trying to conditionally format a cell so that if it contains what cell
$K$5 says, then it will be colored a certain color, if it contains what cell
$L$5 says, it will be colored another color...but to be colored it can
contain more than what is in K5 and L5, as long as K5 and L5 are in it
somewhere.

2 rows of information, need to move to 1 row

s...@discussions.microsoft.com (Sue D) — Wed, 23 Dec 2009 19:41:01 UT

I have a spreadsheet that gives me a row of information for each dependant
that an employee has on file.
Ex
SSN FName LName Dep FName Dep Last Name
111-11-1234 John Doe Debbie Doe
111-11-1234 John Doe Donna Doe
111-11-1234 John Doe James Doe
I want to move the dep in so I have 1 row per SSN. SO the deps in row 2 & 3

Excel count with 2 conditions

ja...@discussions.microsoft.com (janet) — Wed, 23 Dec 2009 19:34:01 UT

I'm sure this is an easy one for you but I just can't get it to work
correctly. I have a spreadsheet that I want to count certain criteria.
Example:
A B C
Name Gender Score
Calvin M 3
William M 4
Jessica F 1
Sarah F 3

Conditional Formats

l...@discussions.microsoft.com (lau) — Wed, 23 Dec 2009 19:33:01 UT

I want to set a set of criteria for a row, within a give date range, in a way
that as the 'due' date approaches, the cells change color from green to
yellow to red. how can i set this up?

Text to Column

ajyour...@discussions.microsoft.com (ajyourpal) — Wed, 23 Dec 2009 18:21:01 UT

Is there any way to separate Dollar amount to another column (last five
digits)?
Not all figuers have a $ sign in front of the amount.
Thank you
USPS 0545019576 LOS ANGELES CA 9.60
USPS 0545019576 LOS ANGELES CA 9.40
USPS 0545019577 LOS ANGELES CA 4.70
SHELL OIL 57442712808 UPLAND CA 16.20
VONS FUEL 10026813 UPLAND CA 26.50

Type a symbol useing shortcut keys rather the insert a symbol

r...@discussions.microsoft.com (RJD) — Wed, 23 Dec 2009 18:15:01 UT

I have a couple of symbols I use a lot. Is there a way I can type those
symbols using some type of keystroke shortcut rather than going through all
the steps of inserting a symbol?
In Word, it allows me to assign shortcuts, but I don't see that option in
Excel. I tried creating a Macro, but when it runs, it jumps to the same cell

Columns following the Row in an Imported Table

jwgoldfi...@discussions.microsoft.com (JWGoldfinch) — Wed, 23 Dec 2009 18:13:01 UT

I have imported some data into Excel using MS-Query and an ODBC connection to
an AS/400 and then added a column to the table that allows the entry of text,
Example Column "A" is Customer # (From Database), Column "B" is Customer Name
(From Data Base), Column "C" is a column I added to the table to allow the

RE: Word Art

c...@discussions.microsoft.com (cm) — Wed, 23 Dec 2009 16:59:01 UT

do the desired wordart in Word and the copy the picture, paste in excel - i
just tried and it worked

Sandwich existing formulas with "If iserror(formula),0,formula)"

orlandovazq...@discussions.microsoft.com (ORLANDO VAZQUEZ) — Wed, 23 Dec 2009 16:36:01 UT

Hi,
I have several hundred different formulas on one spreadsheet like this one.
=VLOOKUP($C$1,'P:\Rate Sheets\client name\[file name.xls]manager
name'!$BV$67:$CL$131,3,FALSE)
The results sometimes return #DIV/0!, or other error messages which ruin my
attempts at summing the results as well as the visual appeal.

Open to Blank Pivot Table Data (Excel 2007)

hu...@discussions.microsoft.com (Hutch) — Wed, 23 Dec 2009 16:28:01 UT

I am wanting a user to open a file to a blank pivot table that has all of the
columns and rows defined, but they have to refresh the table for data to
appear. In PivotTable options I have:
* unchecked to save source data w/ the file
* set the number of records to retain per field as none
However, when someone opens the file I send them it is still showing data.

Select a range of cells

wx4...@gmail.com (wx4usa) — Wed, 23 Dec 2009 16:19:29 UT

I have a sales budget. Row 2 across is Budgeted sales for each month
January - December.
I need to know how to return a sum of budgeted sales to date. For
example, if I am looking at a budget report, I need a formula return
just columns Jan-Aug budgeted sales if I am reporting budgeted YTD
sales thru August based on a cell containing the August date.

modify linked cells without breaking link

(JK) — Wed, 23 Dec 2009 16:11:02 UT

I have a workbook with a number of worksheets (2003.) The 2nd and 3rd
worksheets have cells that are linked to the 1st worksheet. This workbook
will be used to schedule production. The 1st worksheet has a list of products
that we produce.
The 1st worksheet has a column for the min # of cases we need to keep in

View filename - Excel 2007

eri...@discussions.microsoft.com (Eric_NY) — Wed, 23 Dec 2009 15:57:02 UT

I've just upgraded to Excel 2007.
Excel 2003 used to have an option to display the name of the saved worksheet
file at the top of the screen. I'm sure Excel 2007 has this option, but I
can't figure out how to turn it on.
Can anyone help?
Thanks.

Hyperlink Function to Tab

mlthorn...@gmail.com (Matt) — Wed, 23 Dec 2009 15:56:54 UT

I'm trying to create a hyperlink using the hyperlink function that
will go to a separate tab within the same worksheet. What I'm using
is: =HYPERLINK("'Tab1'!A1","Cell1" ) , but it is telling me it
cannot open the specified file. Can anyone help?

'Trick' to restore original sort order after data modified?

lwel...@discussions.microsoft.com (L Welker) — Wed, 23 Dec 2009 15:47:01 UT

Had large excel file. Sorted to combine like type part #. Updated pricing,
would like to restore back to original list order? Normally insert a new
column and sequentially number. Use this filled sequential field to go back
to original order. Any tool in new excel that replaces the need to do this?

World Cup 2010 Spreadsheet

originalg...@discussions.microsoft.com (Originalgoth) — Wed, 23 Dec 2009 15:22:02 UT

Hi All & Happy Christmas & New Year,
I'm working on a World Cup spreadshhet. (Excel 2003)
In one section of it I've got the Group table
A B C D E F G H I
P W D L F A Pts GD
S. Africa
Below each table I've got the fixtures & these are what feed the above table.

Calculation slowdown

t...@discussions.microsoft.com (thom) — Wed, 23 Dec 2009 15:09:01 UT

I am calculating three spreadsheet that have many formulaes in each. There
are multiple files I need to perform this calculation. As I go thru the 2nd
-3rd and 4th spreadsheet, the caculation time increases until it just locks
up. Any help on how I can solve this problem?

Excel File Question

maur...@discussions.microsoft.com (Maurice) — Wed, 23 Dec 2009 15:03:02 UT

Rarely use Excel and would ask what is the difference between an excel
spreadsheet and a workbook. Much thanks for an informed response.

Email addresses in a comma-delimited (CSV) file

Wed, 23 Dec 2009 14:59:01 UT

I am trying to create a csv from another application to be imported into
Excel. One of the columns will contain email addresses. Is there a way that I
can format the data in the column to have the addresses be 'links' when
brought into Excel.

scale to page error in Excel 2007

tho...@discussions.microsoft.com (Thomas) — Wed, 23 Dec 2009 14:51:02 UT

somehow something has changed in my Excel 2007 setup where my "fit to scale"
does not work appropriately. When I choose print preview, the preview screen
changes to a very small preview and my document is a few thousand pages.
This document used to print fine on one page. Even on my other computer it

Macro (password)

m...@discussions.microsoft.com (Mike) — Wed, 23 Dec 2009 14:47:01 UT

I have this macro now i would like to set this cell with a password is this
possible
Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Target As Range)
If Intersect(Target, Range("C300")) Is Nothing Then Exit Sub
ActiveSheet.Tab.ColorIndex = 15
End Sub

Excel Newsgroup: not receiving e-mail notification nowadays

mr...@discussions.microsoft.com (Mr. Low) — Wed, 23 Dec 2009 14:15:01 UT

Hi,
I have to change my e-mail address recently due to relocation.
I have registered for a new MS Passport ID then.
However I noticed that whenever my post is replied nowadays, I am not
receiving any e-mail notification.
May I know the URL that I need to highlight this problem to MS for
rectification ?

CTRL+SHIFT+) is not working in Excel 2007

nagenderra...@discussions.microsoft.com (Nagender Rathi) — Wed, 23 Dec 2009 13:35:01 UT

Hi,
I am using Office 2007 on Vista machine.
When i am using CTRL+0, the excel columns are getting hide. But when i am
using CTRL+SHIFT+), my hided columns are not showing up.
If there is any workaround, please let em know

Trying Again (Burt)

helpwithcellfunct...@discussions.microsoft.com (Help with cell function) — Wed, 23 Dec 2009 13:02:01 UT

Sorry if this offends anyone, but I need an answer and I already submitted
this question yesterday.
the below formula was close, but not quite.
I only want a C to show up in L6 if a N is going to be the answer, if a Y is
the answer then I need to keep the Y. If X6 is not an x then the answer needs

Denormalized data in Excel

mingte...@bliznospamhosting.com (Jabez Gan [MVP]) — Wed, 23 Dec 2009 12:42:59 UT

Hi,
I'm not an expert in Excel, but I opened an XML file in Excel, and modified
and now I'm trying to export it out. However it is telling me that:
____ is not exportable because it contains the following:
Denormalized data
I do not understand what the above is telling me.
A sample XML file can be found in the below link:

Strange Icon - Working with Pivot tables

h...@discussions.microsoft.com (HW) — Wed, 23 Dec 2009 12:42:01 UT

I have noticed a strange picture/icon (Can't paste it here) A small icon
with a Blue J and a yellow background. I can identify it or it's purpose.
Anyone know what it is? What it does?
Thank and Seasons Greeting!

copy & paste worksheet with print settings into new worksheet

larryo...@discussions.microsoft.com (Larry Ohio) — Wed, 23 Dec 2009 12:17:02 UT

How do I copy the current month's report into a new worksheet and keep the
print settinds of the original worksheet in the new worksheet?

why I can not see all my previous posts?

dr...@discussions.microsoft.com (Dream) — Wed, 23 Dec 2009 12:15:01 UT

Hi,
I posted some questions a few months ago. Now, I can only see 3 of them.
When I click on my profile, I can see that I posted 17 times, but why can I
only see 3 of them?
I tried searching by the subject of my posts, but no luck?
please help. thanks in advance

The reference in the formula has changed to eg =R[-1]C/R[-237]C

ka...@discussions.microsoft.com (Kajsa) — Wed, 23 Dec 2009 12:09:02 UT

I don´t know how it has happened, but I want to read the formula as eg
=sum(A2/Z18)
Old documents are shown like this and my new ones come out like this too.
Help, anyone out there?!
Merry X-mas from Sweden :-)

Excel 2007 & Outlook 2003

des...@discussions.microsoft.com (Desrus) — Wed, 23 Dec 2009 12:10:01 UT

I cannot find a way of transferring data from old computer to new one (old
one has Win XP & new one has Win 7)
Any suggestions?

Blank dates showing as 00 january 1900 - help

jos...@discussions.microsoft.com (Josuha) — Wed, 23 Dec 2009 11:58:01 UT

I'm using the below forumla to import data from a seperate workbook which
contains dates.It does work for cells that have dates in them but not every
cell has a date yet and i want this to remain blank but it shows as 00
january 1900
=VLOOKUP(B8,'Summary '!B2:$K$100,10,FALSE)
Any ideas please?

text to columns

li...@discussions.microsoft.com (linto) — Wed, 23 Dec 2009 11:13:02 UT

hi
I created a code to apply text to columns functionality and i assigned a
button to it . It works perfectly. but when i created another button in a
differnt sheet and assigned the same macro to it, it is not working.
please help to debug the code.
Sheets("Temp").Range("A1:A2"). Select
Selection.Copy

Added details only if it is within a certain month of the year

j...@discussions.microsoft.com (Jim) — Wed, 23 Dec 2009 10:51:01 UT

Hello, I am struggling with a formula that i wondered if anyone could asssit
me with?
I am trying to get a calulation that only adds up all the figures in coloumn
J (column only contains numbers) for the 10th month of 2009 (date is in
column D). I have tried a few times but haven't had any joy.
I would appreciate any assistance and guidance on this.

macro help

puiului...@discussions.microsoft.com (puiuluipui) — Wed, 23 Dec 2009 10:32:01 UT

Hi, i need a macro to look in column B for a date ( 12/01 ) and then to add
the date to column A till last filled cell in A.
EX: (this is now)
A B
12/01
1 07:53:20
2 07:53:21
3 07:53:22
4 08:01:21
5 08:01:31
6 08:01:32
12/02
8 08:01:36
9 08:01:38
10 08:14:04
11 08:14:09
Ex: (after macro)

how to create a new sheet when adding values in column if it not e

ma...@discussions.microsoft.com (Mahdi) — Wed, 23 Dec 2009 09:22:01 UT

What i want to do , is to make excel to create a new sheet, with the name of
the content of the cells in a defined column.
so that when i edit a new cell in that column, excel will create a new sheet
with the name of the sheet being equal to the content i entered in the cell.
that is the main question.

How to transpose in excel file

vilf...@discussions.microsoft.com (vilfood) — Wed, 23 Dec 2009 08:04:01 UT

Hi I would like to make a transpose like this?
From
House Defect How much
and Transpose into
House Broken Sinks Bad Paint Bad Lighting

Difference of empty cell and zero value when formatting

a...@discussions.microsoft.com (Al) — Wed, 23 Dec 2009 07:55:01 UT

I'd like to conditionally format a cell if the value zero is entered into it,
however to leave the cell without formatting if the cell if empty. My
attempts at doing so using something like formula is =q54=0 format the cell
regardless of whether the cell has a zero or is empty!
Appreciate any help...thanks!

Vlookup with a specific item

kat...@discussions.microsoft.com (kattay) — Wed, 23 Dec 2009 07:13:02 UT

Hi, I would like to vlookup on employees' degree start date, eg.:
A B C
emp. no. Start date Edu
1 01/01/90 Dip
1 01/01/95 Deg
2 01/01/82 Cert
2 01/01/86 Dip
2 01/01/90 Deg
How do I vlookup on the emp. no and deg start date?

Count until condition is met and then retain final count

f...@discussions.microsoft.com (Fats) — Wed, 23 Dec 2009 05:39:01 UT

Appreciate if some sharp individual can assist me with the following issue.
In cell A1 I have a date.
In cell B1 I have a number between 1 and 100.
I need a formula in C1 to count the number of days between today and the
date in A1 until the number in A2 = 100.
However, Once A2 = 100 I need the formula in C1 to retain the final number

I Need an answer for this Formula

m...@discussions.microsoft.com (Mike) — Wed, 23 Dec 2009 05:15:01 UT

I am using excell 2007 & this formula works
{=IFERROR(AVERAGE(IF(MOD(COLUM N(G5:HC5)-COLUMN(G5),4)=0,IF(G 5:HC5>0,G5:HC5))),0)}
When i upload this workbook to a 2003 version this formula does not work I get
{=_xinfl.IFERROR(AVERAGE(IF(MO D(COLUMN(G5:HC5)-COLUMN(G5),4) =0,IF(G5:HC5>0,G5:HC5))),0)} or somthing close to this

How to choose data from list using key board short cuts

har...@discussions.microsoft.com (Haroon) — Wed, 23 Dec 2009 03:55:01 UT

Formula involving different sheets

p...@discussions.microsoft.com (PL) — Wed, 23 Dec 2009 03:41:01 UT

Hi
Using Excel 2003.
In sheet 1, cell A1: =200/1200
In sheet 2, cell B2: =300/1200
In sheet 3 in a cell, I want to do =200/1200 + 300/1200 by cell reference.
How do I do so?
Thanks.

trouble adding addins

j...@discussions.microsoft.com (jc) — Wed, 23 Dec 2009 00:13:01 UT

Re: Mystified

tcl...@hotmail.com (Tom) — Wed, 23 Dec 2009 00:14:03 UT

Does anyone know what program is used that allows one to hide those codes?
news:Q%cYm.64084$ze1.2387@news-server.bigpond.net.au...

Excel 2000 so slow in vista

woo...@discussions.microsoft.com (woodis) — Wed, 23 Dec 2009 00:12:01 UT

Hello All,
Im running pentium duo core, Vista home, excel 2000, 4GB ram, Toshiba
laptop. I have relatively small spreadsheet 1,000 lines, 25 columns. I
could do anything I wanted really quick on a P4 1Ghz desktop XP, no waiting
on anything. Now,
20 seconds to wait to draw a box around a cell
Format a font - 15 seconds waiting on the circle thing

Macro on a Pivot Table

luc...@discussions.microsoft.com (Lucas B) — Wed, 23 Dec 2009 00:11:01 UT

I need to write a macro that takes the results of a pivot and creates detail
tabs for all results that are greater than or equal to 20. I was able to
record a macro that created the detail tabs for cells that I specifically
double clicked on, but the data will change monthly and I need this to select

how look up this way?

ianelli...@discussions.microsoft.com (Ian Elliott) — Wed, 23 Dec 2009 00:01:01 UT

Thanks for any help.
I would like to look up an array like this:
A1-D1:Def Per x yrs,2008,2009,2010
A2-A5:0<x<=5,5<x<=10,10<x<=20, 20<x<=120 (these could just be labels, with
numbers like 5, 10, 20 & 120 to a column to the right for the lookup, if
necessary, but if the formula could use these for lookups, that's fine too)

Sumproduct question

do...@dell (Donna @ Dell) — Tue, 22 Dec 2009 23:33:01 UT

Hello -
I need a formula that will count the number of lines that are greater than 0
in one column but also need to subtract the number of lines that are greater
than 0 in another column.
There are 16 lines that are greater than 0, within that subset there is 1
line item that is greater than 0 in the other column. I've tried sum(if....,

Format spreadsheet so that it only has a few rows and columns

oger...@discussions.microsoft.com (ogerriz) — Tue, 22 Dec 2009 23:32:01 UT

I have seen an EXCEL 2007 spreadsheet that only has rows 2 - 6 and columns A
- F.
If you use the arrows it doesn't go anywhere at all except within those
boundaries. The other parts of the screen past these boundaries are in the
default MS window colour of blue and there are no gridlines.
How can I duplicate this effect?

Copy same formula to all worksheets in a workbook

jaba...@discussions.microsoft.com (JABAgdl) — Tue, 22 Dec 2009 23:32:01 UT

Hello guys!
I have a table with some formulas saved in workbook "A". Once a month, I
receive workbook "B" and it has several worksheets in it (sometimes almost a
thousand). I need to copy the table with formulas from workbook "A" and paste
it into every-single-worksheet in workbook "B". In the same cell address (C25

how do I unhide the formula bar

we...@discussions.microsoft.com (Welby) — Tue, 22 Dec 2009 23:13:01 UT

I can't see my formula bar - how do I unhide it. I'm using Excel 2007
Thankyou

Index or Offset at specific intervals???

bericdondarr...@discussions.microsoft.com (Beric Dondarrion) — Tue, 22 Dec 2009 22:16:01 UT

Hi, I'm struggling here.
Here is my Layout:
Period 1 Period 2
Period 3 ...
Cost Unit Hours Cost Unit Hours Cost
Unit Hours
Worker 1
Worker 2
Worker 3
...
On a cover sheet, I have a VBA combo box that lists all the Period #'s I've

Formatting for credit card number input

smart...@discussions.microsoft.com (smartgal) — Tue, 22 Dec 2009 20:35:01 UT

I have a cell in which the user will input a credit card number and I want it
to display a format based on the type of card. So Visa / MC should be "####
- #### - #### - ####" but Amex should be "####-######-#####" - the user will
choose the type of card in another cell so what's the most effective way to

Formating

redwood_spa...@earthlink.net (bluebird) — Tue, 22 Dec 2009 20:23:01 UT

I am making up some time lines. I want the whole worksheet to be Minion Pro
11 pt. I select the each sheet and make that font selection. One worksheet
comes out one size font and the other sheet comes out a bigger font. I've
tried the format brush over the whole sheet. I've tried selecting the text in

MIN ingnoring zero sum in an range of cells

michael.gul...@snet.net (Gulicio) — Tue, 22 Dec 2009 20:18:38 UT

I have a spread sheet where I need to use =min(a1:a10,b1:b10) but
ignoring any cells with a zero in the range. Please hel. I have been
searching the groups for hours. Tks in advance

First Parameter in INDIRECT command changes if I add new column

delaware...@discussions.microsoft.com (Delaware Mac) — Tue, 22 Dec 2009 19:47:01 UT

When I use the INDIRECT command, as in the following example,
PERCENTILE(INDIRECT("$FM"&$Y14 0):$FM140, FN$1)
it works fine until I insert a new column anywhere before the column
containing the IDIRECT command. If I do that, the first parameter in the
command changes,
PERCENTILE(INDIRECT("$FL"&$Y14 0):$FM140, FN$1)

Zip codes in mail merge - first digit doesn't display in merge

che...@discussions.microsoft.com (Cheryl) — Tue, 22 Dec 2009 19:32:03 UT

Office 2007 - used spreadsheet to create an address list; zip codes appear
correctly in spreadsheet but when using spreadsheet as a mail merge document,
the first digit disappears in the zip code field, i.e., 05401 becomes 5401.

conditional formating

j...@discussions.microsoft.com (Jim) — Tue, 22 Dec 2009 18:44:01 UT

Excel Users,
Thanks for the help. I would like to apply a conditional format to A1 if A2
meets a criteria.
For example if A2 is 100%, I would like A1 to become bold. I can't seem to
figure out this formula. Can you help?
Thanks
Jim

referencing a cell in another worksheet

shan...@discussions.microsoft.com (Shannan) — Tue, 22 Dec 2009 18:31:02 UT

Hi,
I want cell F55 in worksheet "January" to display what is typed in cell B6
of worksheet "Sheet 1". These two worksheets are in the same workbook. I've
typed "=Sheet1!B6" in cell F55, but instead of displaying "Jan. 4" which is
what is typed into cell B6 it is showing me the forumla that i typed. What am

Find Average using Sumproduct

kart...@discussions.microsoft.com (Karthik) — Tue, 22 Dec 2009 18:25:02 UT

Is there a way to find average based on multiple conditions.
I've been using Sumproduct formula to Sum all the cells but not sure how to
use it find average.
=SUMPRODUCT(--($B$4:$AT$4=$C$1 13),--($B$5:$AT$5=$C$115),$B7: $AT7)
Thanks for your help in advance...

Coordinates

t...@discussions.microsoft.com (Todd) — Tue, 22 Dec 2009 18:16:15 UT

Is it possible to display coordinates in degrees minutes and seconds in excel?

cpu at 50%

locochon2...@discussions.microsoft.com (locochon2010) — Tue, 22 Dec 2009 18:04:01 UT

I have a spreadsheet with 130,000 rows, and vba macro running several loops
torugh it. The odd thing that I noticed is:
The CPU usage stops at 50%. I am running windows XP, with office 2003 AND
Excel 2007.
How can I make it use all 100%?

Maintain hyperlink when moving excel files

dies...@discussions.microsoft.com (diestro) — Tue, 22 Dec 2009 17:31:01 UT

I am using Office 2003. I have a folder with a large number of Excel files
that all have hyperlinks to unique Word documents saved in another area of
the shared drive. I would like to move the entire folder but am afraid that
the hyperlinks won't work correctly when the folder is moved. I tested a few

I need AT&T in a footer without the &T turning into &[Time]

r...@discussions.microsoft.com (RLJP) — Tue, 22 Dec 2009 17:27:01 UT

What do I need to do so that the &T in the company name AT&T doesn't turn
into AT&[Time] ???

Unable to Unprotect a 2003 .xls file

r25rami...@discussions.microsoft.com (r25ramirez) — Tue, 22 Dec 2009 17:04:02 UT

My company recently upgraded to 2007. I had a file that was protected and
only certain cells could be modified, for data entry. I now need to
manipulate the file but I am unable to unprotect the file. The “unprotect
sheet” button is not available. How do I unlock the protection?

Skip a Macro

v...@discussions.microsoft.com (Vick) — Tue, 22 Dec 2009 16:51:01 UT

I have a worksheet_selection change macro, that I would like to skip if
another Macro is running, is that possible? Is it possible to tell if a macro
is commanding the change or the user?
Thanks

Still not working

jer...@discussions.microsoft.com (Jerry R) — Tue, 22 Dec 2009 16:33:01 UT

I am trying to tally the life time hours of a piece of equipment taht the
hour meter has quiy working on. I know the hours on it when new meter was
installed. What I want is to have the total hours displayed in the same cell
for referance. The problem is everyday the formula needs to change. Example

Drag and drop data only??

cha...@discussions.microsoft.com (Chanda) — Tue, 22 Dec 2009 16:28:01 UT

Hello,
I am working on a very large spreadsheet and need to drag and drop large
amounts of data. The problem is that when I do this is drags and drops my
borders also, leaving the empty cells with no borders. Is there anyway that
I can drag and drop my data only?

Merging from Excel to Word

barb...@discussions.microsoft.com (Barbara) — Tue, 22 Dec 2009 16:11:03 UT

When I merge dollar amounts from Excel to Word they come up with numbers like
$4,000.99999999999999999999. I would like them to come up with just places.
How do you do that?

how to manually copy text from one cell to end of other text cell

phili...@discussions.microsoft.com (philippe) — Tue, 22 Dec 2009 15:29:02 UT

probably stupid question, but anyways...
I want to manually copy the content of 1 text cell to the end of another
text cell, on the same sheet.
For that, I copy the content of the source cell (ctrl-C), I move the cursor
to the target cell and I hit "F2" to position the cursor at the end of the
text of the target cell.

Spreadsheet Help

jer...@discussions.microsoft.com (Jerry R) — Tue, 22 Dec 2009 15:19:01 UT

I have built a set of spreadsheets that track our plant operation.
It consists of one sheet we call the input sheet that we put our daily
readings in ( power, water,motor hour meter, etc.) and twelve sheets
(January - December) that have the formulas to draw the information to the
appropriate equipment.