MSGROUPS.NET | Post Question | About | Groups | Contact | Register | Login



microsoft public excel misc (9093)

microsoft public outlook general (7339)

microsoft public excel programming (6569)

microsoft public word docmanagement (5607)

microsoft public excel worksheet functions (5040)

microsoft public access (4768)

microsoft public windowsxp general (3908)

microsoft public windows vista mail (2978)

microsoft public windows vista general (2805)

microsoft public windows live mail desktop (2724)

microsoft public office misc (2268)

microsoft public access queries (2122)

microsoft public powerpoint (2030)

microsoft public greatplains (2009)

microsoft public windows server sbs (1984)

microsoft public dotnet languages csharp (1964)

microsoft public access formscoding (1932)

microsoft public sqlserver programming (1878)

microsoft public mac office entourage (1868)

microsoft public access forms (1798)

microsoft public internetexplorer general (1706)

microsoft public mac office word (1699)

microsoft public access modulesdaovba (1691)

microsoft public outlook calendaring (1436)

microsoft public dotnet framework aspnet (1381)

microsoft public project server (1356)

microsoft public windowsupdate (1353)

microsoft public sqlserver server (1339)

microsoft public project (1285)

microsoft public excel (1277)

microsoft public access reports (1249)

microsoft public windowsxp help and support (1204)

microsoft public exchange admin (1185)

microsoft public windowsmedia player (1165)

microsoft public mac office excel (1160)

microsoft public windows server general (1100)

microsoft public dataprotectionmanager (1096)

microsoft public outlook (1035)

microsoft public word vba general (1029)

microsoft public vb general discussion (1012)

microsoft public outlook contacts (953)

microsoft public windows server active directory (930)

microsoft public development device drivers (923)

microsoft public dotnet languages vb (843)

microsoft public outlook installation (820)

microsoft public word newusers (808)

microsoft public word pagelayout (783)

microsoft public windowsce platbuilder (757)

microsoft public excel charting (733)

microsoft public publisher (728)

microsoft public excel newusers (711)

microsoft public windows powershell (697)

microsoft public pos (660)

microsoft public vc mfc (651)

microsoft public access gettingstarted (630)

microsoft public word application errors (629)

microsoft public sharepoint general (604)

microsoft public office setup (584)

microsoft public onenote (556)

microsoft public sqlserver reportingsvcs (550)

microsoft public outlookexpress general (539)

microsoft public scripting vbscript (533)

microsoft public frontpage client (532)

microsoft public access tablesdbdesign (529)

microsoft public windows 64bit general (516)

microsoft public outlook program vba (502)

microsoft public windows live messenger (434)

microsoft public windowsxp hardware (416)

microsoft public money (397)

microsoft public windowsxp basics (367)

microsoft public dotnet general (316)

microsoft public windows mediacenter (300)

microsoft public windows inetexplorer ie6 outlookexpress (276)

microsoft public mac office (272)

microsoft public win98 gen discussion (243)

microsoft public sharepoint setup and administration (225)

microsoft public windows vista hardware devices (183)

microsoft public windows vista music pictures video (178)

microsoft public nntp test (164)

microsoft public windows vista performance maintenance (148)

microsoft public dotnet framework (148)

microsoft public visio (128)

microsoft public access 3rdpartyusrgrp (68)

microsoft public access conversion (64)

microsoft public dotnet xml (58)

microsoft public pt windowsxp (38)

microsoft public access developers toolkitode (34)

microsoft public windows live photogallery (32)

microsoft public dotnet faqs (19)

microsoft public dotnet framework aspnet datagridcontrol (16)


microsoft.public.excel.misc Post New
Items(9066) /182 Next >> Last >|
Subject Posted Replies From
Changing default font in Excel 2003

I'm using Excel 2003 on XP Pro. I want to change the default font so that all new text will be in the specified default. I went to Tools > Options > General > Standard Font and set the desired font. I closed Excel and reopened it, but new text does not use the new default. What am I missing?

6/6/2010 5:28:12 PM 0 info...@mindspring.com
Can anyone provide me the fomula ?

Hi, I need the fomula for below scenario, A4 = start date (exp.= 01.03.2007) B4 = end date (exp. = 31.05.2012) D1 = 01.04.2007 D2= 31.03.2008 E1= 01.04.2008 E2= 31.03.2012 F1 = >31.03.2012 at D4 = fomula to get the answer of days which fall between A4 & B4? (365days) D4 = fomula to get the answer ? (1460days) G4 - total period which date fall>D1 (answer shown in month and days. Ans = 5 yrs & 2 mths. Any solution ? Thanks. Thanks.

6/6/2010 4:10:55 PM 1 =?Utf-8?B?VFE=?= <...@discussions.microsoft.com>
Formula

I'm in need of a formula in C1 that gives me the value of A1 divided into 60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60. THANKS.

6/6/2010 3:36:31 PM 4 =?Utf-8?B?VHJhaW5lZQ==?= <Trai...@discussions.microsoft.com>
Excel 2010

I have installed Excell 2010 and now when I open the program, it opening all the excels files. It also is trying to open the other files like .doc in that same directory. How can I stop this from happening.

6/6/2010 3:04:38 PM 1 =?Utf-8?B?Q29tcHV0ZXJMYWR5MTQz?= <ComputerLady...@discussions.microsoft.com>
Pivot Table Formulas

I need to create a variance formula for the data selected in a pivot table. My problem is that the data is coming in from one column and I don't know how to distinquish the data by year in the formula. I have put a small selection of my data below. I would like to show the variance between 2009 and 2010 for all months selected in the pivot table. WDS# EA UOM PRICE EXTENDED Month Year 0623864 6 EA 9.73 58.38 Jan 2010 4286879 2 EA 2.784 5.568 Jan 2010 0623864 9 EA 9.73 87.57 Feb 2010 4286879 1 EA 2.784 2.784 Feb 2010 3514738 1 EA 13.72 13.72 Feb 2010 0623864 5 EA 7.85 39.25 J

6/6/2010 2:17:48 PM 0 =?Utf-8?B?QUo=?= <ihavequesti...@microsoft.com>
blank cells having no value

Hi, though this is Steve's account it is his wife Val writing with my problem. Back in the old days of DOS there was a function which allowed you to set all blank cells as blank - that is = not having a value of Zero. I am working on Excel 2003 at home and 2007 at work so am at the moment somewhat confused and cannot find that facility on either system. What I am trying to do is: I have two cells one E6 representing "goals For" and another F6 representing "goals against" I have the following simple formula. =IF(e6>F6,3,IF(e6=F6,1,0)) this works fine when the figures are in an

6/6/2010 12:46:34 PM 2 Steve Hayes <hayes...@telkomsa.net>
Help! how to cross - data with excel??

Hi, I'm required to present some info at my work, using two excel files. This is the task: File 1, has ID numbers in column A, and column B is blank. File 2, has ID numbers in column C and column D has the date the person joined the company File 1 es a select grop of people (about 2500), whereas File 2 is the general database (about 30thou) They're asking me to match the data, in order to end up with the coresponding date they joined the company in column B on File 1 (obtained from column D on file 2), how to do it? taking in account that File 1 is outdated and some peo

6/6/2010 8:13:07 AM 3 =?Utf-8?B?Z2xvcmlhbWFy?= <gloria...@discussions.microsoft.com>
How to determine the value?

Does anyone have any suggestions on how to determine the value within lists? For example, [1] There is a given date in cell A1, 06-Jun without concerning year, I would like to determine the value within column C, it should return 6 in cell A2, because 06-Jun is equal to or larger than 05-Jun and less than 21-Jun. [2] There is a given date in cell A1, 05-Jun without concerning year, I would like to determine the value within column C, it should return 6 in cell A2, because 05-Jun is equal to or larger than 05-Jun and less than 21-Jun. [3] There is a given date in cell A1, 07-Mar

6/6/2010 5:17:38 AM 2 =?Utf-8?B?RXJpYw==?= <E...@discussions.microsoft.com>
Find certain "Text" in a specific coloum, add corres. values

Hi, I have two coloums. One has text and the other has Values. I need excel to search through a whole coloum, and summerize the results. My coloums look like as follows A 2 B 5 A 2 The results should look like A 4 B 2 How can I achieve this? Thanks

6/6/2010 3:58:29 AM 2 =?Utf-8?B?QXJ1bSBLaGFu?= <Arum K...@discussions.microsoft.com>
Converting XLS file to QIF or to OFX

How do I safely and securely convert an excel file (xls) to a QIF or OFX file?

6/6/2010 3:18:20 AM 1 =?Utf-8?B?ZHJlYW1jaGFzZXI=?= <dreamcha...@discussions.microsoft.com>
Copying rows of data into new worksheet but placing data into colu

I have a spreadsheet which contains 3375 records (Excel 2007). My quandry is the following: I need to reformat the rows into columns for each Dealer (starting a new row for the next Dealer). CURRENT SPREADSHEET: DEALER LOCATION VOLUME AMOUNT 123 Anytown, USA 155 $24,100 123 Hometown USA 145 $25,000 123 Thistown USA 455 $56,000 123 Our town USA 687 $68,000 123 Their Town USA 767 $989,000 245 Anytown, USA 155 $24,100 245 Hometown USA 145 $25,000 245 Thistown USA 455 $56,000 245 Our town USA 687 $68,000 245 Their Town USA 767 $989,000 818 Anyt

6/6/2010 3:01:24 AM 1 =?Utf-8?B?VGhhbGFyY3Rvcw==?= <Thalarc...@discussions.microsoft.com>
how do we get 2003 .xlb toolbars and custom macros to show in 07

I have custom macros that are saved in an .xls file under the XLStart/ folder in Excel 2003. These macros are referenced by an Excel11.xlb file that holds the toolbars. All of these automatically open because they are under the XLStart/ folder. How do I get them into Excel 2007 so they will open automatically and how can I get the custom toolbar file to show up.

6/5/2010 11:23:04 PM 1 =?Utf-8?B?YmlnZGVhbA==?= <bigd...@discussions.microsoft.com>
Nested AND OR expressions

HI I need to express something in VBA , and am having trouble with it. I need to say this : IF E1 CONTAINS "1bx" OR "2bx" OR "3bx" AND J1 =11 THEN PUT 1 , OTHERWISE PUT J1 Can someone assist with some code to make this happen , please? Grateful for any help. Best Wishes

6/5/2010 6:44:24 PM 7 Colin Hayes <Co...@chayes.demon.co.uk>
formula for moving information from one sheet to another sheet

I have information in column A of a task sheet. The information goes from row 1 thru 35. Column B is where I place a "x" to say the task need to be completed. Is there a formula that can check each row in column B to see if the "x" exist, until it reaches the end. If the "x" exist in any of the rows, then move the information into a blank sheet called assignment. Example B1,B3,B4,B20 all have a "x" in the field, now I need to move the information in A1, A3, A4, A20 to row1 thru 4 of a blank work sheet. Is this possible.

6/5/2010 5:59:22 PM 4 =?Utf-8?B?UHV6emxlZA==?= <Puzz...@discussions.microsoft.com>
can't "undo" to original document

I accidentally hit Ctrl S and saved a document. Unfortunately, I meant to do a Save As, instead. Is there anyway to recover my original document? I haven't closed the file, yet. I know in Word you can "undo" multiple actions. Is it possible to do that in Excel, also?

6/5/2010 2:40:06 PM 2 =?Utf-8?B?bG92ZXRvc2hvcDExMjg=?= <lovetoshop1...@discussions.microsoft.com>
Formula Questions

Having trouble with formulas. I have two work sheets. Work sheet1 is a work order. Work sheet2 is what needs to be done by a certain date. What I need to do is type in a date in work sheet 1. At that point the date has to find the date on work sheet2. Once the date is found the formula needs to check if anything is in b2 in work sheet2, and if it is, move what is in a2 into work sheet 1. Highly confused. I have never attempted this before. Any help would be highly appreciated.

6/5/2010 2:40:05 PM 6 =?Utf-8?B?UHV6emxlZA==?= <Puzz...@discussions.microsoft.com>
Re: Sorting a list of numbers

Option Explicit Sub SASLineEmUP() Dim lr As Long Dim i As Long Dim lc As Long Application.ScreenUpdating = False Columns(1).Clear lr = Cells.Find("*", Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Row For i = 2 To lr lr = Cells(Rows.Count, 1).End(xlUp).Row + 1 lc = Cells(i, Columns.Count).End(xlToLeft).Column Cells(i, 2).Resize(, lc).Copy 'Cells(lr, 1) Cells(lr, 1).PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=True Next i Columns(1).Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _ OrderCusto

6/5/2010 2:05:16 PM 0 "Don Guillett" <dguille...@gmail.com>
Re: Consolidating data

Sent OP this Option Explicit Sub SAS_MakeTable() Dim lr As Long Dim c As Range Dim mm As Double Dim mr As Long Dim mc As Double Application.ScreenUpdating = False lr = Cells(Rows.Count, "b").End(xlUp).Row Range("f3:r" & lr).ClearContents Range("B2:B" & lr).AdvancedFilter Action:=xlFilterCopy, _ CopyToRange:=Range("F2"), Unique:=True For Each c In Range("b4:b" & lr) mm = Month(c.Offset(, 1)) mr = Columns(6).Find(What:=c, LookIn:=xlValues, LookAt:=xlWhole, _ SearchOrder:=xlByRows, SearchDirection:=xlNext).Row 'MsgBox mr mc = Rows(2).Find(What:=mm, LookIn:=xlValues, Lo

6/5/2010 2:01:35 PM 0 "Don Guillett" <dguille...@gmail.com>
How many cells can a correlation function cover?

What is the Maximum number of cells that correlation function in Excel can calculate?

6/5/2010 1:37:55 PM 0 =?Utf-8?B?Q29ycmVs?= <Cor...@discussions.microsoft.com>
Excel chart - great variation in values

I am trying to create a column or line chart where a value for 9 variables are given for each month of the year. My problem is that the values are mostly between 0 and 40. I have one value though that is 280 and this makes the chart not really legible. Is there any way to have the scale on the y-axis showing 5 as major unit up until 50 and after that 50 or 100?

6/5/2010 10:58:02 AM 1 =?Utf-8?B?QW5u?= <...@discussions.microsoft.com>
Where is the number lock key on my HP Pavilion zv 6000???????????

See subject question........

6/5/2010 7:14:32 AM 2 =?Utf-8?B?ZGVhY29uZ2FyeQ==?= <deacong...@discussions.microsoft.com>
Copy parts of a number

If I have a cell with a digit 123,4567 - how can I copy the content of the cell to another cell with only two digits after the comma. In other words - I only want 123,45 to appear in the new cell. Is there any way to use a "round off" functionality?

6/5/2010 7:14:26 AM 2 =?Utf-8?B?R2VuaUU=?= <Ge...@discussions.microsoft.com>
No formulas Work

For some reason none of hte formula in a spreadsheet are working. The spreadsheet is on a netowrk and when others open it, the formulas work. When I open the spreadsheet on a simple addition formula I get the #value appearing in the cell. Is there a setting in excel that I need to change.

6/5/2010 4:04:36 AM 3 =?Utf-8?B?QkcgTWFyaw==?= <BGM...@discussions.microsoft.com>
Free Ebay consignment spreadsheet?

Does anyone have a free Ebay consignment tracking spreadsheet I could have?

6/5/2010 2:38:27 AM 1 =?Utf-8?B?U3RldmU=?= <St...@discussions.microsoft.com>
Multiple Conditions with Gradients

Hi, I'm having some trouble with conditional formatting. I'm hoping someone will know, is it possible to have multiple conditions for the same set of cells that use the gradient function? Basically, what I want to do is set up a gradient for cells with values 10 to 30, a separate gradient for cells with values 4 to 10, one for -4 to 4, one for -10 to -4, and one -30 to -10. I don't want one continuous gradient, but 5 separate gradient with different colors. This seems like it should be possible, but neither excel 2007 or excel 2010 beta seem to be able to do it. It tries to m

6/5/2010 2:34:32 AM 0 =?Utf-8?B?S3VydA==?= <K...@discussions.microsoft.com>
How to determine the values?

Does anyone have any suggestions on how to determine the value? For example, Under following columns: [A] [B] [C] [D] 1 174 198 222 7 180 204 228 9 182 206 230 A given number is 204 in cell E1, I would like to determine the value under column A, which should return 7, because 204 is under the same row. A given number is 174 in cell E1, I would like to determine the value under column A, which should return 1, because 174 is under the same row. Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric

6/5/2010 2:01:27 AM 1 =?Utf-8?B?RXJpYw==?= <E...@discussions.microsoft.com>
Navigation buttons in Excel 2007

The navigation buttons in Excel 2007 do not seem to work the way they did in Excel 2003. I have tried them on multiple computers. I know about right-clicking to get a list of worksheets, but I want to left click on a navigation button and have it move to the appropriate sheet (forward, backward, first, last). Has this changed? Thanks for your assistance. -- I Teach

6/4/2010 11:46:51 PM 1 =?Utf-8?B?SSBUZWFjaA==?= <Ite...@discussions.microsoft.com>
Command Button - Shrinking Font

I have a new 200" landscape monitor that replaced my traditional 17". The resolution automaticallyl resized on connection and looks fine. However, when I click a command button, the font size shrinks. It stays at that level until I click a different button and then return to the original button, when it shrinks again. It will eventually become invisible to the naked eye. Internet research seems to indicate this is a bug. A standard Excel button accessed from View>Toolbars>Forms (not a VBA command button accessed from Control Toolbox) seems to maintain its font size, but I

6/4/2010 10:53:41 PM 2 =?Utf-8?B?b3BpZWFuZHk=?= <opiea...@discussions.microsoft.com>
Set row height, but allow wrap text

I want to set the row height of me spreadsheet to allow a little "buffer" between rows. But I have a couple rows in which there is a greater amount of data (text) than the column width allows. I want to allow that row to grow and wrap the text. It seems like I have to do one or the other: (1) set the row height, which then means the wrapped text doesn't fit in the height of the row, or (2) do autofit and have the wrapped text look good, but not have the "buffer" I want in the row spacing in general. How can I do this? I looked for a way to set cell margins that would add the buf

6/4/2010 10:01:38 PM 0 =?Utf-8?B?S01N?= <...@discussions.microsoft.com>
formula question

Hello, I am trying to write a formula that first looksup a number and then runs a calculation from that number. Here is a look at what I have so far: First Part: =IF(ISNA(VLOOKUP($A5,'907100'!$G:$K,5,FALSE)),"",(VLOOKUP($A5,'907100'!$G:$K,5,FALSE))) Second Part: IF(ISERROR(B5/T$2),"",(B5/T$2)) B5 is where I am writing the formula... I am not sure how to combine them into one formula. Thank you,

6/4/2010 9:46:14 PM 2 =?Utf-8?B?dG9t?= <...@discussions.microsoft.com>
Consolidating data

Hi, I need to consolidate some lines of data in a 19K line spreadsheet and then change its basic format. I have 3 columns of data: ID# | date | volume My problem is that while the data is mostly monthly, there are some months with two entries and I need to consolidate them into a single monthly value. I don't care which of the dates is used as long as the month and year are correct. That's the 'consolidate' part. Then I need to convert the 19,000 row spreadsheet to a big grid with the meters listed in the left row and the month/year at the top of each column with

6/4/2010 9:13:18 PM 1 =?Utf-8?B?QkRU?= <...@discussions.microsoft.com>
Printing in Color

Ever since my printer has been networked by the cells in my excel if filled with color do not print in color. The print preview displays the various colors but the print is black, grey and other shades of grey. However, if there is a picture displayed on the sheet. The picture prints in all the colors. Please help! this is frustrating!

6/4/2010 9:03:01 PM 0 =?Utf-8?B?RmlsbCBDb2xvdXIgZm9yIERpZmZlcmVudCBkYXRh?= <FillColourforDifferentd...@discussions.microso
Separate AM/PM from time.

In column B I have 1000 time entries with the following format. 9:30AM, 10:30PM. I would like to move the AM or Pm into a new column. I've tried "fixed width", also tried changing the format to put a space between the time and the AM/PM, but nothing has worked. Any suggestions? Don

6/4/2010 8:18:22 PM 2 =?Utf-8?B?Y3VhcnRldHRv?= <cuarte...@discussions.microsoft.com>
Move rows into columns

I have an Excel sheet that has 8000+ rows that include contact information. I'd like to move them from all of those rows into 6 columns. Currently it lookzs like: name title company address city/state/zip phone .... .... .... And I'd like to create a formula to move it to 6 columns that look like this: name title company address city/state/zip phone I'm still an Excel novice but would appreciate any suggestions you might have. Thanks!

6/4/2010 7:34:38 PM 3 =?Utf-8?B?VFI1Mw==?= <T...@discussions.microsoft.com>
Macro/VB coding question

I want a macro to work for a worksheet name which will always be the same directory and file name but the data inside worksheet will periodically change - increase in rows/decrease in rows. # of Columns/Column names will not change. I'm trying to filter for a non-changing set of info, then delete the results. Here's what I get if I record my current run: Workbooks.Open Filename:= _ "***Directory of location and file name here***" Rows("1:1").Select Selection.AutoFilter ActiveSheet.Range("$A$1:$S$746").AutoFilter Field:=5, Criteria1:=Array("10" _

6/4/2010 7:32:59 PM 3 =?Utf-8?B?bWVsRXhjZWwyMDA3?= <melExcel2...@discussions.microsoft.com>
Conditonal Format based on two different criteria

Hi all. In column A I have a list of a bunch of different test names. In column D we have times associate with each test. I would like to make a conditional format that will check column A for a specific test name and then check to see if the time in column D meets a certain requirement. This is what I have tried but can't seem to get it to work. =AND($A$4="CBC",D$4$>.0416) Anyone got any ideas?

6/4/2010 7:26:22 PM 1 =?Utf-8?B?Q2hhZF9PZ2xlc2JheQ==?= <Chad_Ogles...@discussions.microsoft.com>
Find Function

I would like to find the second occurence of a specific alphanumeric character in a cell. For example, if cell A1 contains "BOBBY" what would be the formula for finding the second occurence of the letter "B". Thank you advance for your assistance. Greatly appreciated

6/4/2010 6:58:50 PM 5 =?Utf-8?B?U0pU?= <...@discussions.microsoft.com>
How do I look at two worksheets in one Excel workbook at same time

I know how to arrange windows to look at multiple workbooks. But I want to have two worksheets displayed at the same time from the same workbook. Is there a way to do that?

6/4/2010 6:48:03 PM 2 =?Utf-8?B?UGVvcmlhSmVhbg==?= <PeoriaJ...@discussions.microsoft.com>
Macro to affect all sheets

I want to select all sheets in a workbook, insert a column, and put a formula in that column. It works fine when doing it manually, but if I try to have a macro do this, it only affects one sheet. Is there any way to do this?

6/4/2010 6:33:09 PM 3 =?Utf-8?B?UkVNQg==?= <R...@discussions.microsoft.com>
Underline? Bottom border? or any suggestions?

Hello! We have a form that we use quite often and I am attempting to put it on Excel so that someone can just tab through it and type in their responses. This is a type of service report and there is a large section for the technician to describe the work they performed on a specific day. This section should allow the text that is typed in to be "underlined". Is there a way to set this up so that the tech is able to type one complete paragraph (instead of typing line by line), have the text print "underlined" AND if the amount of text typed in does not fill the entire area

6/4/2010 6:16:31 PM 1 =?Utf-8?B?U2NobmFrYS1wYWth?= <Schnaka-p...@discussions.microsoft.com>
Text Parsing with uneven lengths

I have cells that contain data such as: General Motors 22779 United States of America 1449 Carlsbad 712 Under 21 Children 12 I would like to parse the numbers at the end of each cell. Each number can be different lengths and the text preceding the number can be different lengths, too. Any ideas?

6/4/2010 6:16:30 PM 2 =?Utf-8?B?ZGtzMzQ1?= <dks...@discussions.microsoft.com>
permanent format pivot chart

How can I apply a format permanently in a Pivot Chart? For example, adding values to my data graphs and not losing this format upon changing a field to display more information.

6/4/2010 5:57:02 PM 0 =?Utf-8?B?YW16?= <...@discussions.microsoft.com>
excel 2007 saving issues

I have a file created in excel 2003 that has thousands of VLookup functions. I recently installed excel 2007. When I open this file and try to save it, it will take close to 20 minutes to save. Do you have any ideas on what is slowing this down? Thanks

6/4/2010 5:52:28 PM 0 =?Utf-8?B?Q1hI?= <...@discussions.microsoft.com>
Is there a way to insert a copied row into all aother tabbed table

I have a file with about 100 tabs along the bottom for other tables. I have a row that I need to copy and insert into each one of those (at the top, first row). I can copy and insert row into each tab individually but is there a way to have this insert into all of them at once in the same place?

6/4/2010 5:23:30 PM 1 =?Utf-8?B?R3JlZw==?= <G...@discussions.microsoft.com>
Pivot Table

I have a pivot table based on an excel worksheet with five columns - Date, Call From (Names), To, Time, and Type. In the pivot table, i am using From for the rows. I also use From in the values area as i want to count the number of times the data in From appears - as there can be repeats. Next, I want to use Time as it relates to Call From. Time ranges from 0 to > 0. I want to specifically count how many 0s and greater than 0s. i thought i could filter for the data after adding the Time field to the data area - it allows a filter but the results do not change. I am using Ex

6/4/2010 4:47:07 PM 1 =?Utf-8?B?S1RS?= <...@discussions.microsoft.com>
nested formulas in excel using iserror and if

Please help! I am trying to get the formula below to return a value to the cell ONLY if the answer to ((c30-$30)/g$30) is greater or less than 20%. I am using the below formula. =IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)>ABS(20),((C30-$G30)/$G30)," ")) Thanks

6/4/2010 4:34:47 PM 2 =?Utf-8?B?Vmlja2k=?= <Vi...@discussions.microsoft.com>
How to merge 2 + contiguous cells without lossing data?

I need to merge two or more contiguous cells without lossing the data. Also I have cells that I copied & pasted into cells and I am unable to add data to these cells.

6/4/2010 4:14:06 PM 2 =?Utf-8?B?UGF0dGk=?= <Pa...@discussions.microsoft.com>
Pull value from another sheet

I have multiple sheets in my workbook. On the first sheet, I am pulling data from all the other sheets for a comparison. I need to pull in a commission level for specific group numbers. Here is what I need: Sheet 1 K3 is where my formula is. I need to match the value from sheet 1 B3 to sheet 2 I4. Then, if they match, I want the value from sheet 2 N4 to show up in sheet 1 K3. Another issue may be that on sheet two there may be multiple group numbers that are the same, however all commission levels for a group number are the same. So I guess I could go average or median if tha

6/4/2010 4:11:33 PM 2 =?Utf-8?B?bGF1Z2hsaW5s?= <laughl...@discussions.microsoft.com>
Sorting a list of numbers

I have inherited an excel file with numbers across 100 columns and over 300 rows with several blank cells (likely 15%). I would like to format these numbers across 10 columns and however many rows are necessary, but without any blank cells, in ascending order down each column. Can someone help me how to do this? Thank you.

6/4/2010 3:24:19 PM 3 =?Utf-8?B?QlJC?= <...@discussions.microsoft.com>
Sumproduct;3 criteria

Hello, I need a formula that will sum the dollar value of a column if the entries meet 3 seperate criteria. The current formula I have (that returns a #NUM error) is: =SUMPRODUCT(('May YTD Data'!$K:$K="New Customer"),('May YTD Data'!$AB:$AB=B6),('May YTD Data'!$D:$D>4/30/2010),('May YTD Data'!$D:$D<6/1/2010),'May YTD Data'!$Q:$Q) Idea is to sum the sales volume (dollar amount) for "New Customer" per sales reps (B6) for the month of May. Thanks in advance for any advice you provide

6/4/2010 3:17:02 PM 5 =?Utf-8?B?R3JlZ0w=?= <Gr...@discussions.microsoft.com>

Pages: 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182









Newest Articles

Window Live Mail Auto Forwarding
46 min. 2 sec. ago

Win32.Gael.3666 got past Windows Defender
3 hour 49 mins ago

ANN: IT COULD GO DOWN INTO THE 40's TONIGHT HERE IN THE WINDY CITY SUBURBS!
4 hour 18 mins ago

ANN: THE PRICE OF SPEEDING TICKETS IS GOING UP HERE IN ILLINOIS!
4 hour 21 mins ago

ANN: OBAMA WANTS 2 SPEND ANOTHER 50 BILLION!
4 hour 34 mins ago