Functions
in [Excel]
|
how do i insert todays date in a spread sheet just prior to print wish to have excel automatically add date to same cell in spread sheet every time it is opened. ... 25 May 2010 14:40
Multiple sheet references in one function =SUM(--('Sheet1'!$B$2:$B$2000<=BB$3),--('Sheet1'!$B$2:$B$2000>=BB$2),--('Sheet1'!$D$2:$D$2000=$B7), --('Sheet2'!$B$2:$B$2000<=BB$3),--('Sheet2'!$B$2:$B$2000>=BB$2),--('Sheet2'!$D$2:$D$2000=$B7), --('Sheet3'!$B$2:$B$2000<=BB$3),--('Sheet3'!$B$2:$B$2000>=BB$2),--('Sheet3'!$D$2:$D$2000=$B7), --('Sheet4'!$B$2:$B$2000<=B... 25 May 2010 13:33
How to I combine excel worksheets? I have a large worksheet with about 200 sheets all with the same field layout. I want to combine into one worksheet and pull the sheet name into columnX so I keep the organization. Can this be done easily? ... 27 May 2010 17:04
Changing dates across multiple worksheets I have a workbook that contains 18 sheets. Is it possible to change the date on sheet 1 and have it change on the other 17 sheets, even though the sheets contains two different date formats, 5/25, and 5/25/10, and all of the sheets are different than sheet 1? I'm using Excel 2007. Thanks, Malcolm ... 25 May 2010 16:53
formula to look up ref in one sheet and offset in another Hi there I am trying to create a formula which will use a product code typed into a cell in the same sheet, look up this code in a separate file, and give me the sales figure which is offset from this code. I.e. (if this helps) This is the formula I have at the moment just using the other file: =OFFSET('[Bu... 25 May 2010 13:33
Combine rows to print on one label School Pupil ID LastName FirstName Grade Course/Grade Clear Creek 210310 Archer Heath 5 MUSIC S Clear Creek 210310 Archer Heath 5 SOC ST A Clear Creek 210310 Archer Heath 5 MATH B Clear Creek 210310 Archer Heath 5 RDG C Clear Creek 210310 Archer Heath 5 SC... 25 May 2010 12:26
Searching Multiple Timesheets for a project code and then.... I need some help on this one!! I am trying to scan multiple timesheets in excel for a project code and then capturing the hours worked for that project. I then need to have the hours worked summed on a different work sheet to track hours worked for multiple disciplines on one engineering project. (See below f... 26 May 2010 03:45
Group or ungroup in a shared excel workbook Hello, Could you please let me know if its possible to be able to group or ungroup (groupings already set up) while an excel workbook is protected and shared? If it is possible please let me kno how to set it up. Many thanks Tracey ... 25 May 2010 10:13
Search for a particular letter in the sentence and print excel has to search for a paticular letter in a row and print the preeciding word in the next cell ... 25 May 2010 08:02
How do I change the pge size to A4 in excel 2003 Hi I'm not too good at this, when I print the worksheet its not in A4 size. How can I change it to A4. Any help would be great thanks ... 25 May 2010 03:44 |