Threads Replies Last Post 1369 Pages: 1  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  >>   Excel Macro to insert rows Hello, I have a work sheet in thich the parameters are arranged as per the temp. I have to find the word 'temp 'and insert a complete row before temp. Can I get some help tp write the excel macro for the same. ... 2 30.09.2006 01:27:02 how can I make tabs work only in the colums being used? Tabs move from colum to colum to the right. But, it keeps going to right colums. How can I make the tabs move right only until the last colum that I am using, then move to the next row? Thanks for your answer in advance.... 3 30.09.2006 00:45:20 Autofilter misses last line I have a 2075 row database that I autofilter by technical area (i.e. Data/Filter/Autofilter on technical area column header). The filter works fine, except no matter what technical area I select from autofilter pulldown, the last row always displays. I have double checked that there are no empty cells in the last row. I have also verified that there are no empty cells in the last row by ... 8 30.09.2006 00:37:03 Correct FORMULA NEEDED PLEASE Hi, I am using the following formula: =SUM(H5:H12,G5:G12,F5:F12)*200000/M5:M12 The formula is giving me the wrong answer. Is this the correct formula? What I am trying to achieve is continuos information for a rolling 12 months. When I add another month all the information will change to the most current with the formula used above. Please help. Thanks in advance... 6 30.09.2006 00:32:41 Conditional format question When I select and conditional format column A, and then when I conditional format column B using some of the same cells in column A the conditional formatting no longer works for the other column. Here's my formula for column A: =OR(LEFT($F$1,1)="5",$O$1=5000) Here's my formula for column B: =OR(LEFT($F$1,1)="10",$O$1=10000) If column A criteria is met, everything works fine If column ... 7 30.09.2006 00:19:22 Summing numbers I have a columns with numbers. I want to add numbers to these cells. Is there an easier way to add to that number without going to edit the cell and inputing a +/= in the begging of the cell? Thanks.... 2 30.09.2006 00:10:19 Summing cells defined as Time hh:mm I looked at a couple of similar questions but have not been able to achieve a good result. I have a few cells defined as Time HH:MM. I want to sum them up so I get hours and minutes. In the cell to hold the total, I used "=SUM(N43:N47)". I formatted the Total cell as custom with a format of [hh]:mm. The original values were 10:00, 3:00, 12:00. I was expecting to get 25:00. What I ... 5 29.09.2006 23:01:02 Command button missing on template I have a workbook and in the workbook on Sheet1 I have a command button whose on click executes code. I have saved the workbook as a template. When I go to File/New and open a new worksheet based on that template, the command button does not exist. Why and how can I correct the problem? Thank you... 1 29.09.2006 22:59:02 formula for scheduling in advance How do I set up a cell to add 12 months to the date in another cell? Example: 'Maint Date' cell has current date--'Next Maint Due' cell needs to have that date plus 12 months.... 3 29.09.2006 22:46:18 Excel Office 2003 When I open a new workbook in excel, I get a a workbook with 34.2MB size. Even after a small amount of data is entered and saved the file still is 34.2MB. This makes it too big an attachment to e-mail. Any ideas?... 4 29.09.2006 22:44:53 Start-up Problem Hello, Everyday when I first open Excel and when I type something in, it takes a few seconds to show up in cell. After the first time, I don't have any delay. Has anyone experienced it? Is there a setting in Excel that I need to change? Thanks.... 10 29.09.2006 22:44:15 Inability to start Excel after Refresh update Since installing the Refresh update this morning, Excel fails to start in either full or safe mode. Word and Powerpoint work OK. I've also installed the compatability update, to no avail. Is anyone else having this problem? I'm loathe to uninstall the original Excel 2003 at this point, but is this the only solution?... 2 29.09.2006 21:30:01 inserting page breaks for specific data groups I have a list of data with three columns--I want to automatically insert page breaks at the end of each group in a cloumn (for example: at change in curriculum code insert page break). Is this possible? If so , how? Ursula... 2 29.09.2006 20:45:42 Multiple Worksheet Protection I have a workbook that has multiple worksheets with the same format. Is there a way to protect cells on these multiple worksheets at the same time. The group feature does not work for this and having to do each worksheet separately is very timeconsuming... 2 29.09.2006 20:44:07 excel 2002 -how can you convert a file to a pdf read only file? I use Office Pro XP which includes Excel 2002. I want to convert a file to a read only .pdf file but cant see how........ 5 29.09.2006 20:36:51 AutoFilter Question I have an Excel file that contains 5000 records. When I do the AutoFilter of all records and when I click on the AutoFilter drop-down arrow of a column, I do not see all the information in the list. Therefore, I can not select the information that I want to filter. However, if I do the custom from the drop-down arrow and type in the criteria, I can then filter the info that I want. ... 3 29.09.2006 20:25:01 COUNTIF Accross Multiple Columns with AND I can't find the answer to this problem in any resource I have looked... I have two columns, E and K. Column E contains various place names, but only if they are within a certain city; when the place is outside that city, the cell in column E is blank. Column K contains the quarter that a particular event occured. I want to count all the events that occured within only that city during sec... 4 29.09.2006 20:17:41 Format & calculate time sheet template I'm building a time sheet template to calculate hours worked each day and pay period. My problem is setting up cell formatting to recognize a 3pm to 1:30AM shift, that will work in the calculations. ... 4 29.09.2006 19:44:09 combo/text box print issue I created a form with combo and text boxes on it. THe form is perfect except typed info in the boxes does not print. I am assuming there is something I need to add to the code or set from false to true, but not sure where to look, any help appreciated. -- Thanks,, Kim... 8 29.09.2006 19:21:02 Splitting Rows Is it possible to split a row over two pages, so you don't have one page with three rows and then a lot of blank space?... 1 29.09.2006 19:17:02 How can I count up values in a list that includes duplicates? I have a list of values, some of which are duplicated (around 600 rows). I would like to know how many unique values there are in the list, using a formula.... 3 29.09.2006 19:09:51 Headers and Footers How do I edit footer so I do not keep adding new ones to the list?... 2 29.09.2006 18:56:02 Print selected range in a worksheet hello community Is there a way for me to put 2 selected range of data to be printed out into a single page. When I used the "Print Selection", the two area that I selected appeared to be in different page. thanks community for the assistance :) -- oldLearner57... 3 29.09.2006 18:19:02 excel worksheet how do I go about putting a footer on several worksheets at once?... 2 29.09.2006 18:18:02 Importing to Excel from csv AND keep leading zeros I have a script that saves a csv file and mails it to people as a report. When people open the csv file using Excel the column of account numbers have leading zeros. Not all but most. How can I have them open or import to Excel and keep the leading zeros from that column?... 3 29.09.2006 18:15:02 1369 Pages: 1  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  >>