General

Windows Scheduled Tasks
I have drawn a blank on where to find and set up Windows Scheduled Tasks Cheers!! ... 30 Apr 2010 01:52

auto email worksheet PT2
One problem... we use Lotus Notes can I just replace LotusNotes where it says Outlook? "Gary Brown" wrote: Use Windows Scheduled Tasks to run your macro at specific times/days. The basics of the macro would be something like this.... '/========================================/ ' Sub Purpose: ... 29 Apr 2010 20:22

Pivot Table with multiple dependent excel spreadsheets
Hey all, Is it possible to create one pivot table that checks in with multiple excel spreadsheets to update itself? FErd -- Frildo Andersen CARE Hawaii, Inc. 606 Coral St. 2nd floor Honolulu, HI 96813 phone: 808-791-6159 fax: 808-791-6198 ... 29 Apr 2010 18:05

Excel Properties
I use a spreadsheet every day and save it about 10 times per day. I have noticed that my KB's are climbing over awhile(900,000 to 4,000,000).I haven't added any thing that could make this happen. Can someone help, it's slowing down my spreadsheet? Also can you see how much KB's are in a tab on a spreadsheet? ... 29 Apr 2010 21:29

Insert extra lines
I have a worksheet sent to me with over 700 names on it. I need to put 4 extra lines under each name. Is there a way to do this without having to individually insert those lines as this will take a long time. Thanks. ... 29 Apr 2010 18:05

Highlight the cell/row if particular name comes..
Hi, This is what I would like to achieve, There will be sheet full of address details and in that I want to highlight the cells with some colour if the particular list(i.e.list of 10 particular area names like Area1,Area2....Area10) of area names present along with the door # and Street name. The challenge ... 30 Apr 2010 10:36

modifying name format within a cell
I currently have a list of names all in one column of cells that are formatted last name, first name (with a space after the comma). I need to change to first name last name. There are several names with no space after the comma in case that matters. Is there an easy way to make this change? Thanks, MYK... 29 Apr 2010 16:57

Excel macro deployment
Hi I have been deploying Excel macro to workstations using an MSI. The MSI creates a folder under program folders and drops the xla files in the folder. The installer also sets a registry value. When the user opens Excel, the macros begin. This works fine for Excel 2003. What do I need to do to properly ... 29 Apr 2010 15:49

Need to add semi colon in time numbers
I need a formula for taking a time number like 1435 and making it 14:35. I know there is a simple way to do it but I can't figure it out. Any help would be greatly appreciated. -- RustyB ... 29 Apr 2010 20:22

VLOOKUP with multiple look-up values
I have a vlookup which looks up the value of an expense code for a particular branch, set up as a named range (BRANCH A) & chosen from a drop-down list in cell C3. It works fine for one expense code 4001 thus: =VLOOKUP(4001,INDIRECT(C3),2,FALSE) My problem comes when in some instances I need to add together t... 29 Apr 2010 22:35