Hi, I have a spreadsheet that contains multiple sheets. I want to add a button that runs a macro, which only prints page 1 on the first sheet (called Scorekort). The "Scorekort" sheet contains 13 pages in total, but I only want to print the first page. Any ideas for this macro? Anders

Hi, I have an Excel 2003 workbook with 20 worksheets. Each worksheet contains one Pivot table.The Pivot tables all have a common structure and the same number of fields. Is there a way to consolidate the individual Pivot tables into one master Pivot table using VBA? Alternatively would it be possible to use VBA to cycle through all the underlying Pivot Caches and copy all the data to a new worksheet? Any help/guidance appreciated.

Thank you in advance, experts!!!!! I have an Excel file with a couple of pivot tables. Everything works perfectly, but I would like one more piece of functionality, if it's possible. My raw data includes 6 columns, which are Cust#, CustName, SalesRep, InvAmount, InvDate, and CustCategory. When I go to my pivot table, I have it setup like: Report Filters: Cust#, CustName, SalesRep, CustCategory Row Labels: InvDate Values: Sum of InvAmount When I apply a filter, such as I display all information regarding the SalesRep, the filter works perfectly, showing me only InvDates and InvAmount sums for that SalesRep. BUT, when I want to apply a second filter, the filter list itself still contains all Cust#, CustName, and CustCategory options for all sales reps. Is it possible to filter the list once a filter has been applied, so if I filter down to a single SalesRep, I only see his/her accounts listed in the other filter lists? Man, that was hard to word, and I still don't know if I got it right... PLEASE HELP if possible!!! Thanks guys!!!!!!!!

Hi folks. I have a formula that gives a person's age. I want to add on below it that says something like: "There are 42 days until Joe's next birthday..." Where the apostrophe after BirthName is added. Or you could say the number of the age ala "XX-tyeth" type format, so if Joe was 50 (1960 year), it would say: There are 42 days before Joe (BirthName) becomes 51 years old. I know it is a simple variant of my formula. =CONCATENATE(BirthName," is ",(DATEDIF(DOB,TODAY(),"y") & " years, " & DATEDIF(DOB,TODAY(),"ym") & " months, and "& DATEDIF(DOB,TODAY(),"md") & " days Can someone wanting to exercise his or her date coding prowess or learned skills bang this out for me. I am making one of those workbooks where folks hate me for making it easy for their friends to track birthdays and ages.

This formula works fine as long as there is a match in the "Customer Record" =IF(A3="","",INDEX('Customer Record'!B:B,MATCH(A3,'Customer Record'! A:A,0),1)) But... is there a way to modify it to allow me to enter my own value in Column B if there is no match. Thanks in advance!!

I'm at a loss to explain why this formula =ColorIndexOfOneCell(B3,FALSE,1) works in one workbook, but not another. I have this vague recollection that it has something to do with it being a "macro" or VBA and that I had to enter it differently than a regular formula. Can someone please help? Mike

hi I'm trying to customize the ribbon, in order to include my macros already joined in an addin-workbook. My problem is the following: how can I imitate the behaviour of the editbox of the fontformat found in the built-in Home tab. I mean the feature that the value in it updates when changing between worksheets. I'm familiar with the customUI basics (customUI.xml, onAction callback, etc.), I just haven't found a solution. Thank you in anticipation istvan

Hi (Excel 2010) In my pivottable I have a list of names. Now I want to show only the rows with names including "ete" or "eve". I can set up af filter for each, but how do I filter for both of them. Furthermore I would like to show the rows with "Johnsson" Is there a way to do it. Something like : Select * from names where (names like %ete% or names like %eve%) and names like %Johnsson% Example: NAMES John Adams (Not to to be shown) Peter Grandjean (To be shown) Eric Hansen (Not to be shown) Evelyn Bond (To be shown) Regards Peter

Suppose I have A B 3 3 2 4 3 6 4 I want Bn =Average(A1:Bn) for each n = 2, 3, ,,6. What function do I use in B2 so that I can just copy and paste to B3 to B6? Thanks.

Excel 2007: I have a large range of cells with formulas I want to copy to another workbook but it only copies values. I can't copy the sheet to the destination workbook, only to a new workbook. Anyone know how? Thanks

I have a workbook that has cells containing numbers and letters, as shown in the example below: V5H0R15J2W127R9 The 1st character is always a letter, the last is always a number. The letters always appear singularly, but the numbers can be 1, 2, or 3 digits. The can be anywhere from 5 letters in a cell to 12, each letter always followed by fomr 1 to 3 numbers. What i would like to do is to, in another cell, add the numbers, so the formula, based on the example above, would be: 5+0+15+2+127+9, and the result would be 158. Is there a formula that would accomplish this? Thanks, Tonso

Using XL2003, I was entering numbers into cells using the numeric keypad. In one cell, I had meant to enter "3", then press "enter". I mistyped [no idea what keys i actually pressed], and the word "Zero" appeared in the cell. i am not sure what i typed, and have not been able to reproduce this effect. The cell is formatted Arial Narrow. i looked in Autocorrect and saw no "Zero". I am simply curious if anyone knows what caused this. Thanks, Tonso

veni.497@rediffmail.com

veni.497@rediffmail.com

Hi. I need some formula or macros that will sort in a complex way, the result should be sorted first alphabetic order than in numeric order, if it contains dash “-“after dashes in numeric order. Presently I am doing it manually and using great time using excel sort function 2003 but as you guess excel sorting is not the way I want, Many thanks to whoever shares this defy.

I need some help with an excel sheet and you guys may be the ones to help. I have a list of capital expenditures that I want to amortize over X months. Lets say office equipment is $10,000 and we are amortizing it over 12 months starting 1/1/11. That gives us a monthly cost of $833.33 Total capital expenditures by month 1/1/11 - $833.33 2/1/11 - $833.33 3/1/11 - $833.33 4/1/11 - $833.33 5/1/11 - $833.33 6/1/11 - $833.33 7/1/11 - $833.33 8/1/11 - $833.33 9/1/11 - $833.33 10/1/11 - $833.33 11/1/11 - $833.33 12/1/11 - $833.33 So that is just one expense. No lets say in June we buy more computers. Again they cost 10,000 and we are paying it off over 12 months. Now my matrix becomes this.... Total capital expenditures by month 1/1/11 - $833.33 2/1/11 - $833.33 3/1/11 - $833.33 4/1/11 - $833.33 5/1/11 - $833.33 6/1/11 - $833.33 + $833.33 7/1/11 - $833.33 + $833.33 8/1/11 - $833.33 + $833.33 9/1/11 - $833.33 + $833.33 10/1/11 - $833.33 + $833.33 11/1/11 - $833.33 + $833.33 12/1/11 - $833.33 + $833.33 1/1/12 - $833.33 + $833.33 2/1/12 - $833.33 + $833.33 3/1/12 - $833.33 + $833.33 4/1/12 - $833.33 + $833.33 5/1/12 - $833.33 + $833.33 This would continue for each item we add to the list of expenditures. I need to create an excel sheet that will accumulate totals for each month. What is the best way to accomplish this?

Hello, I recently upgraded to Excel 2010 and found that the lightest dotted grid lines that I created in Excel 2007...now won't printout in Excel 2010. If I created the lines in 2010 they print fine, but I have hundreds of spreadsheets. Any ideas? Thank you, Nico --- Posted via news://freenews.netfront.net/ - Complaints to news@netfront.net ---

I have a spreadsheet with two columns of numbers. I want to highlight the number in the second column if it is greater than the number in the first column. e.g. If c3 is greater than a3, highlight, and then if c4 is greater than a4 and so on. I was able to do this quite easily in XL 2003, but have been stymied in XL2007. I realize this is a rudimentary question, but I just can't seem to figure it out, and have searched many help sites. Thanks for any help.

Hi, I’m using Excel 2002 and I have a question about using a formula to determine if certain words are found within a cell. For example, I want to determine if several words are found in each cell in column A and, if so, I want to put the word “Yes” in the corresponding cell in column B. If the word isn’t found then I just want that cell in column B to remain blank. So, in the following example, I want to see if the following words: Oranges Apples Lemons are found in any of the cells in column A. The result would look like this: Column A Column B Apples, Oranges, Pears Yes Apples, Oranges Yes Apples Yes Limes, Pears Oranges Yes Pears Oranges, Lemons, Limes Yes Lemons, Limes Yes Limes Apples, Limes Yes I know I could use a formula like this: =IF(OR(COUNTIF(A1,"*Oranges*"),COUNTIF(A1,"*Apples*"),COUNTIF(A1,"*Lemons*")),"Yes","") to do this in this example, but the real spreadsheets I am working with sometimes have 50 or more words to look up in thousands of rows. Is there any way to do this using a combination of COUNTIF and VLOOKUP or MATCH or something like that? So far my attempts to do so have failed. Thanks in advance for any information.

I am trying make a second combo box on sheet1 that will read anything from a cell that matches sheet2. Example: college football on sheet2 a1:a500 = teams b1:b500 = players. on sheet1 combo box1 listfillrange=sheet2!$a$1:$a$500 linked cell is a3 on sheet1. Trying to make a second combo box that states whatever is placed sheet1 cell a3 that the 2nd box only reads the players that match the team name. can this be done like listfillrange=vlookup(($a$3, (sheet2!,$b$1:$b$500,2,false))