Threads Replies Last Post 125 Pages: <<  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  >>   Payroll calculating With a rang of cells equaling 90,(a1,b1,c1 and so), how do you get the calculating to stop at 40. Useing Excel 2000... 2 05.08.2006 02:36:00 formula probles - so lost i posted this in general forum but i think its better suited here - i got a worksheet such as this: SequenceId Musician Initial YOB YOD Instrument 1 Micheal A. 1975 1999 Chello 2 Tom I. 1960 1989 Piano 3 Hans J. 1982 2000 Piano 4 Hans J. 1982 2000 Keyboard 5 Hans J. 1982 2000 Orchestra I want to be able to retrieve every information sequenceid,initial yob,yod just by matching the name ... 6 04.08.2006 23:48:01 Looping Question Hello, I have a workbook that has 50 sheets. I want to create a loop that will copy each individual sheet to its own workbook and save it with a name. This is what I have so far. Any help would be great. Sheets("1").Select Sheets("1").Copy ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\hola\Desktop\Legal Entity\Master LE Files\WCA Individual... 4 04.08.2006 15:23:09 slanted cell shading I am wishing to create the shading as shown on the 2nd image/chart on this page: http://office.microsoft.com/en-us/assistance/HA011097991033.ASPX I'm trying to get the diagonal shading. Everytime I try to shade an area, it shades the whole cell, and I'm only wishing to shade half. I have already changed the Orientation and have the text set at a 68º angle. Whenever I try to shade... 9 04.08.2006 07:42:42 Question Hey, I have a pretty complicated question, it's probably easy for well versed users, but I'm not sure what the cleanest way to do this is. Here's what I'm doing. I'm taking a column of numbers, then in the column next to it I want to do the following. =(B2/(AVERAGE(B2:B29))*75) I've figured it out to that point, but rather than adjusting each of the other cells when I use the format painter t... 7 04.08.2006 05:55:01 Date Calculation Hi Anyone know how I can calculate the amount of days between two dates not taking into account weekends and possible Bank holidays? TIA Steve ... 5 03.08.2006 17:15:51 HOW DO I DELETE BOOKS I CANNOT FIND? ... 4 03.08.2006 16:11:58 Calculating Sleep Hey So Im making a log to keep track of things, and I want to calculate my sleep, but I don't want to have to write the date each time, Went to Sleep: 23:00 Woke Up: , 09:00 So I just want to go down and write the times but if I do that the date for the second time is assumed as the same day not the next day. Then when I go to calculate my total with a simple =D15-C15 it calcu... 6 03.08.2006 12:40:45 How do I get this problem? 301.5/cos19.79=301.5/.94023=320.43 ? -- Lois Ann... 6 03.08.2006 07:40:00 coutif problem i have a list of names in one worksheet, i used a countif formula to count the number of names - but how do i replace the zero when a data is not found to somethin else such as 'error' or 'not found'?? hope someone can help -- hsb101 ------------------------------------------------------------------------ hsb101's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37049 Vie... 4 03.08.2006 07:08:19 How do I set up a worksheet w/gridlines on top only? I am setting up a spreadsheet w/ the top half using gridlines and the bottom half blank to type in information I need concerning the subject. I don't know how get rid of the gridlines after I'm done wi/the spreadsheet which is the top half of the page.... 5 03.08.2006 04:19:32 I think this would be an if problem How would I write this? G= degrees. If 0-90 degrees = G If 90-180 degrees =180-G If 180-270 degrees = 180+G IF 270-360 degrees = 360-G -- Lois Ann... 8 03.08.2006 01:12:01 How do I install when "file ZF561407.CAB can not be found" ... 1 03.08.2006 00:16:01 In excel In excel page setup , I want to transform inces in centimeters... 3 02.08.2006 23:07:08 need to know how to control length and height of lines Here's teh problem, I need to print the gridlines with the sheet I am making for work. I need some of the lines to start at a certian place and stop at a certian place. I need some cells to be larger without all of them being the same size. Help... 3 02.08.2006 23:04:08 Difficulty in transposing Hi, This is my first post and there will be many more to come I expect. My first Question is in relation to transposing. I cant seem to transpose linked cells, is it possible at all, I have tried everything. Thank you all, Richard. -- Richard J ------------------------------------------------------------------------ Richard J's Profile: http://www.excelforum.com/member.php?action=getinfo&... 7 02.08.2006 22:13:41 if cell is blank, color another cell? I have 2 fields A1 and B1 If B1 is blank I want the text in A1 to turn red. Otherwise it will remain black. Later if B1 is filled in then A1 will turn back to it's original state (black). How do I do this? ... 4 02.08.2006 20:20:36 help with updating spreadsheet hi all, I’m new to excel and learning as i go. i need help, I’m trying to make my work a bit easier. i want to keep a historical record of products and there locations at work (work in a warehouse by the way), I’ve managed to create a worksheet (see below, worksheet 1) that uses vlookup (=VLOOKUP(Sheet1!A:A,Sheet2!A:B,2, FALSE)) to get a list of about 4000 products and there locations from wor... 3 02.08.2006 16:39:30 Most efficient formula/combining multiple data cell ranges/seperat I have 2 wksts', same wkbook.. wkst#1=Summary. Open wkst#2=Holds Open. Current On w#2 I have 10 columns: 5= Current Reasons ; 5= Current Owner All rows for all columns have an existing formula,i.e. =+IF($K2,"Resolution Pending",1,0) for the Current Reasons columns & =+IF($N2,"Nick Mileti",1,0) for the Current Owners columns. Now, on w#1, I have the 5 names listed vertically, in 1 colum... 2 02.08.2006 15:56:02 Help about image transfer to excel spread sheet Hi there, can any one tell me how to use csaned image in to excel, particularly am concerned about reconciliations, have many paper account statements and will be of great help if i can scan these documents and get it into Excel sheets. -- Ali.... 2 02.08.2006 15:45:02 Change formulae easily? I have to change a great amout of formulae from a simple =A3/A4 to either =ROUND(A3/A4,0) or =IF(A4=0,"",A3/A4) The cells are spread all over the sheet, sometimes in one row or line, sometimes grouped together or sometimes individually placed anywhere on the sheet. Is there an easy way to change these formulae faster then individually change each cell? Even changing each c... 2 02.08.2006 15:14:11 Excel hidden notes in spreadsheet I'm rather new to Excel and a colleague who is no longer with us created a workbook. In one of the columns of the workbook there is the same instruction note in each cell. This is not a comment as there is no red marker and when I try to delete comment it's still there. The same note shows in each cell of the column. How do I get rid of it? Can you help? -- Lynne Mawson Manchester... 4 02.08.2006 14:55:34 I dont need the Restriction when viewing my documents, yet it is I cannot view my Excel documents because it says Restricted Access. I dont need restricted access on my own document. I therefore cannot format my document. How do I remove this? I have even signed up ... 2 02.08.2006 14:01:54 How to use VBA to name sheet ? I have a file that i do not know how many sheet are there in before i need to copy contain of C4 to name of sheets Thank for your help. -- vumian ------------------------------------------------------------------------ vumian's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36494 View this thread: http://www.excelforum.com/showthread.php?threadid=564347 ... 12 02.08.2006 13:57:07 More Excel Tutorials/Tips Required Good afternoon/morning/evening. Many thanks to all of you who have requested and suggested tutorials to be posted on my blog http://teachr.blogspot.com over the past couple of days. I'm currently working on more new content for the blog and really appreciate your input. If you have any more ideas please please keep them coming, as I want as many tutorials, tips and hints for excel as I ... 1 02.08.2006 13:35:27 125 Pages: <<  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  >>