General

Macro to Inserting Columns and then add column to horizontal total
Hi, I have a macro that susscessfulling inserts any number of columns, however it is SUPPOSED to keep all the formulas and clear the contents of the inserted columns, which it does do, so that is problem number 1. Now what i need is for the total column to be updated automatically with the number of column... 17 Feb 2010 06:40

Macro/ custom filter, criteria="abc" or blank
Hi, I write in a macro ActiveSheet.Range("$B$5:$L$20000").AutoFilter Field:=2, Criteria1:=FirmCriteria then I should add also " or the firms which have blank as value". I tried to do it manually and do "record macro". But I could not succeed even manually. In manual way, I I tried some... 17 Feb 2010 07:45

Hours per week per resource
Dear Excel-lent users, I want to know how many hours a resource is booked per week, knowing they have multiple tasks per week. I have two sheets in which I want to process the hours per task per week per resource (Sheet 1) and in Sheet 2 I want to know what the total hours per week are one resource has been b... 17 Feb 2010 05:35

SUMIFS and Dates
=SUMIFS(Detail!C:C,Detail!A:A,">=B6",Detail!A:A,"<=C6",Detail!B:B,"Installation") Detail Sheet Date Type Qty 2/8/2010 Sales 2.00 2/8/2010 Credits 1.00 2/10/2010 Sales 1.00 2/12/2010 Credits 3.50 2/12/2010 Sales 1.00 I am trying to summarize Week No. Start End Sales 1 2/1/2010 2... 16 Feb 2010 18:23

Concatenating Currency and Percent
I am trying to concatenate two cells which are in 2 different formats: Cell A1: $5,000,000 Cell B1: 16.90% So, in Cell C1, I am trying to say the following: $5,000,000 or 16.9% I am trying to do a concatenation..however the percentage is turning into decimals and I am losing the currency format as well ... 16 Feb 2010 18:23

vioce in excel
In class we learned that there is a feature in excel that speaks Audio actually tells you what is in the cell I would really like to know how to turn this feature on I am using office 2007 excel Please help ... 16 Feb 2010 18:23

Allow users to edit ranges problem 2007
I am protecting the formatting of Excel 2007 worksheets in the Review tab/Allow users to edit ranges/I select the editable range/Check (allow) select locked and unlocked cells and insert and delete rows: but after the protection is set with a password, Excel doesn't let you insert or delete rows even though it'... 16 Feb 2010 18:23

R1C1
Why won't this work? Sub b9vlookup() Dim theRange As Range Dim lastrow&, firstRow&, x& Set theRange = ActiveSheet.UsedRange lastrow = theRange.Cells(theRange.Cells.Count).Row firstRow = theRange.Cells(1).Row For x = lastrow To firstRow Step -1 If InStr(1, Cells(x, 1), "Total") > 0 Then Cells(x + 2).FormulaR1... 16 Feb 2010 18:23

How to Clear a Pivot Table Cache
I have a workbook with years of company data along with a Pivot Table using those data. I wanted to give this workbook as a "template" to a friend to use it in his work. I deleted most of the data so that he would enter his own but I wanted to leave the Pivot structure as it is. The thing is I cannot get the ... 16 Feb 2010 12:57

Excel 2003 help doesn't work. I got both Excel 2003 and 2007 insta
I have both Excel 2003 and Excel 2007 installed. The Excel 2003 help doesn't work, but the Excel 2007 help works fine. When trying to open help in Excel 2003, the help window open, but it's all grey. ... 16 Feb 2010 07:31