General

Showing Outline Symbols
I am using Excel 2007 SP2. After using Data-Subtotals, the outline symbols never appear. I always need to go to Excel Options-Advanced-Show outline symbols if an outline is applied. When I close Excel and use subtotals again, I need to go through this process again. How can I make the outline symbols ... 6 Apr 2010 17:36

vba autosave
Hi, how do I get this to save the file to specific location, it just keeps going to my documents. Public Sub SaveAsE5() ThisFile = Range("E5").Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub ... 6 Apr 2010 17:36

How to records that the date field = todays date in VBA
DATE CODE DESCRIPTION OLD NEW UOM ------------- ------- ---------------------------------------- ----- ------ ------ 3/26/2010 *1438 ETHYL-2-METHYL BUTYRATE(E) 8.14 9.15 KG 4/6/2010 *0068 BENZYL BENZOATE(E)(I43) 5.00 ... 6 Apr 2010 19:53

If statements
I have a workbook and I want info from sheet 1 to be transferred to sheet 2 on todays date. Is this possible? ... 6 Apr 2010 23:11

I cant select rows or columns
I cant select and unhide rows or columns on a worksheet, I have tried different protection methods... can someone show me how to unhide/unprotect a worksheet to select whole rows or columns. ... 6 Apr 2010 15:21

IF or SUMIF to bring back text?
I am trying to match departments which have two different titles. For example, there are 50 departments that are futher classified into 150 sub-departments. I do have the data showing departments and their corresponding sub-departments in two columns. On another sheet there are only sub-departments and I nee... 6 Apr 2010 16:29

Excel Pivot table - getting back to the skeleton template
Hi Roger - unfortunately Cleartable is for Excel 2007 - I'm using Excel 2003 - I did try it, but got a debug error. I need to be able to do the equivalent of ClearTable in 2003. Thanks anyway. George Roger Govier wrote: Hi GeorgeTryActiveSheet.PivotTables("PivotTable1"). 01-Apr-10 Hi George Try Act... 6 Apr 2010 19:53

Total percentages
I want to work out the total percentage of 2 sums, For example Matthew worked 5 hours stacking shelfs, in this time he stacked 40 shelves, his target was to stack 10 shelves per hour so his current percentage would be 80%. Matthew then works 3 hours cleaning shelves, in this time he cleaned 45 shelves, his t... 6 Apr 2010 15:21

Sumifs
Hi, I tried to do a sumifs for my simple spreadsheet but could make it works. I have a table with EmpID column, Plan elem, and the weighted avg %, I want to sum the weighted avg % for all the plan elem = 1 per empID. Note that one emp have multiple plan elems. Please help...Thanks, MyLan EmpID Plan Elem ... 6 Apr 2010 16:29

Need Macro- Insert rows based on dates and copy info from that row
I need a macro that will insert a number of blank rows based on the number of months between a start and end date and then copy the information in the reference row to the new blank rows. repeat for each start and end date sequence. The records are over 8,350.. so ill also need some idea how to get it to st... 6 Apr 2010 15:21