Threads Replies Last Post 326 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  >>   Changing Dates I am trying to figure out a way to auto-roll the dates on a spreadsheet forward. Basically, what I have is this: A1 B1 C1 D1 09/25 10/01 10/08 10/15 etc... And what I want is for those dates to all roll-forward as they are surpassed, so that on 09/26, the dates will increment one week and show: 10/01 10/08 10/15 10/22 etc, forever. I appreciate any help in sort... 3 25.09.2006 08:00:37 How do I reference a RANGE inside a Cell Formula? Help ... I need to condense the following formula that's in multiple cells. While this example is for illustrative purposes ... my true cell formulas have reached the max character limit for a formula. So I'm desperate to find an alternate way to calculate the total number of specific shifts on a specific day of the month. I'm hoping someone can show me how to rewrite the formula using a RA... 2 25.09.2006 02:36:28 Shortcut Key or Macro for (Insert -> Entire Row) Is there a shortcut key or macro I could do that would automatically insert a new row? I'm getting tired of Right Click -> Insert -> Entire Row... ... 7 25.09.2006 01:23:48 Worksheet setup How do I set up a new worksheet overall 180 x 240 mm with cells 37 x 30 mm? ... 3 25.09.2006 00:23:16 convert column to a row I have a spreadsheet that has only one column of data. I'd like to convert it from a column to a row. Is this possible? How? Thanks! ... 2 24.09.2006 23:25:59 chart or macro problem hi problem: Have around 300 student records want to produce a chart for each one, the chart contains 4 pieces of data for each student and is unique to each student, I want to produce a seperate excel template for each student e.g. i will end up with 300 seperate excel files prefably called the students name?? any help would be gratefully received cheers paddy ... 5 24.09.2006 19:21:09 Shortcut Ctrl-X not working on multiple cells In Excel 97, on some spreadsheets I can't use Ctrl-X to cut multiple cells at once. Other ways to cut work, but Ctrl-X is my preferred method. On other spreadsheets this does work. Has anyone ever seen this before? ... 3 24.09.2006 19:18:21 Excel 2000 Crashes I can open excel spreadsheets no problem. As soon as I try to change the font, or the font size, it crashes. Anyone have any ideas? Thanks ... 3 24.09.2006 19:03:27 exit from excel I have Microsoft Excel 2003 installed on my computer. I can go to File, exit to close out Excel. I prefer using the "x" in the corner but it is greyed out. Any ideas on how I can fix this problem? Thanks, Rebel ... 3 24.09.2006 17:49:06 editting pushbuttons Hi, I have this excel worksheet I use for years now... Ith has some pushbuutons to execute some code. Now I want to change the text on this pushbuttons, but I forgot how I can edit those buttons... I tried the combination of CTRL or Alt- enter key but... no way. Doesn anybody know how? Thanks JP... 5 24.09.2006 16:02:33 Overall total for column regardless if selected or not. I have a pivot that counts the rows matching DBO/OE or IDI. Then for those counts, I have it broken out by producer type. So in my pivot, I have DBO/OE and IDI in the column area and producer type in the row area and ofcourse the sum of DBO/OE and IDI as the data. Now there are many producer types, but the user may select just to view two. How can I show a percentage of the ones they a... 2 24.09.2006 12:51:40 increased file size Hello, I have a file in excel which was 919kb in size. I have processed a few changes (only basic changes - updating figures, nothing like adding in a pivot table or picture) and re save it. But the size now is 35mb and I really don’t know why. Has anybody got any ideas on how I could find out? -- Cheers ... 2 24.09.2006 12:45:48 Compare each value in a range to each value in another range I am looking for a macro that will return a comparison of each cell in a range to each cell in another range. example. the first range would have vales of 1,2,3 and the second range would have values of 5,6,7 Thus the macro should return 9 possible comparisons: 1 & 5, 1 & 6, 1 & 7, 2 & 5, 2 & 6, 2 & 7, 3 & 5, 3 & 6, 3 & 7, Can anybody help me with this?? ... 7 24.09.2006 12:14:01 Dynamic Worksheet Tab Naming I would like to have the name tab of a worksheet change to the entry in a cell. I have multiple sheets that all reference a master sheet. The master sheet is the place where the user sets up the information for the other sheets. There are cells in the master setup sheet, where the user enters the names of individual pieces of equipment. Each worksheet contains data pertaining to one piece o... 4 23.09.2006 17:20:10 search row I desire seach all row in a range that have 2 value set with imputbox and copy into an other sheet. Is it possible? ex 2 5 4 7 9 1 4 3 6 5 7 8 9 3 4 9 3 5 7 1 seach and copy 5 4 2 5 4 7 9 1 4 3 6 5 thx for help ... 2 23.09.2006 11:00:27 Hide sheets using vba Hi all I have a sheet initally hidden(Contact) and the rest visiable, what I am trying to do is when today() = 1-11-06 it automatically unhides the Contact sheet and hides all the rest. I am trying to do it with having a button assigned to a macro - Having no luck... Any help welcome. Thanks Paul tried... Sheets("Menu").Range ("A1") >= "01/11/2006" GoTo hide Sub hide() ... 4 23.09.2006 10:41:30 Tab Name How can I display the tab name on a sheet? I'm looking to have a template that pulls the name of the tab that I assign and displays it in the sheet. Something similar to "&TAB" used in the Header and Footer option. Thanks ... 3 23.09.2006 03:28:02 Public Function not running Hey, I have a public function that I call from a cell. The function is: Public Function QuitTime(strQuitTime As String) As Date Dim strHour, strMin As String Dim intHour, intMin As Integer Dim dtTime As Date strHour = Left(strQuitTime, 2) strMin = Right(strQuitTime, 2) dtTime = strHour & ":" & strMin dtTime = dtTime + Range("MainSheet!B2") ' this cell con... 1 22.09.2006 21:38:33 Replace Help Please I have a spreadsheet with all kinds of names in one column. The names are in rows. Each of the names are for example - moving san diego, del mar moving... I want to replace each of them so that there is a " at the start and a " at the end. I tried to find * and replace with "*" but that doesn't work. Any suggestions are appreciated. Thank you so much. Bryan... 5 22.09.2006 21:08:01 Detect cell colour I have spreadsheets where 5 cells have general titles and have different background colours. In other sheets, dozens of cells list topics and are also colour coded to show which general title they refer to. I need to tabulate information so that a row would contain three cells: the general title, a topic and data about it. Is there a command that returns the colour of the cell background... 2 22.09.2006 20:36:38 Keyboard Shortcut Key for Switching between Worksheets In a Workbook Ok, I'm pretty sure this feature existed (as I recalled using it in Excel several versions ago). Now that I need to work with lots of data in different worksheets in a workbook, I find myself severely wanting this keyboard shortcut key (being an old school user) again, instead of moving my mouse to the desired tab below and clicking it (which is wasting too much of my time. A searc... 6 22.09.2006 18:59:53 Help converting DATE with MACRO?! I have a column that contains dates in a format like this... 25-Mar-05 How would I write a Macro that would take this data and convert it to a format like this...? 03/25/2005 Thanks much! ... 4 22.09.2006 18:06:16 Copy macro to other row Hi all, I've created two macron that executes calculations on a certain row. Can I copy these macros so that they can execute the same calculations but on a another row i.e. only on one row at the time leaving the others unaffected. Regards Dan ... 4 22.09.2006 17:46:41 countif function I want Excel to only count cells with < 3 value. Here is what I used, but this is wrong. Can anyone tell me what I am doing wrong? =COUNTIF(('Monitor Tool'!N11:N26,'Monitor Tool'!N20:26)"<" &Data!C1) Renee... 8 22.09.2006 17:38:19 Slow Opening Excel Files I have a computer that is very slow when viewing files to open from excel(and word for that matter). The files can be accessed very quickly from My Computer or explorer but when doing an open in Excel the list takes forever to generate what files are in the network shares. This does not happen when logged in as administrator, only as a standard user. Any idea's on how to fix it? Its ... 1 22.09.2006 17:21:44 326 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  >>