Hi all, Is there any way to change system variable for author name so everytime I do excel, the author name will always be my name. Thanks in advance. --...

I've set up a template in Excel that I send out to customers to fill in. It looks nice but the people who fill it in don't necessarily know how to use...

Hi there, In cells R18 to R20 different text can be entered by users. I need to count the number of cells with text (sometimes cells are blank so are not...

Hi I have a database that is to contain columns such as: A B C Cost Centre Code Amount 100000 100 ...

Hi, I assign in the area in calculating claims recoveries. On the monhtly benefit that we paid , we have to recover an amount to reinsurer based on the table...

I need a script really bad, here is what i need : In Column D I have week numbers ranging from 532 to 543, and then in column F, i have sales for an item. In...

Hi, i have applied a conditional formatting for the cell to highlight if the date past 3 months, however it does not work if the months is either on the 10th...

I have a table as shown in the example below. Can you help me with a formula that pulls out the the project code with maximum hours for an employee? This table...

I need a formula to compare the pound production of the current month, by workdays, with the previous month. I have turned sumif and countif every way I can...

When standing on a cell with formula you can see which cells it uses by clicking the command line. Is it also possible the other way around. Can I track if...

I have two years data in one excel spread sheet, I need to pull rollover average for 365 days (from today until 1 year earlier exp 27-Apr-09 through...

Im looking for a code that will do the Edit LinkUpdate source and change the sheet names of the external files to the correct names in my formulas?

Hi all, I am suspecting a corrupted Excel program file on an installation at our office, so I want to uninstall and install Excel (which is OK, I can do...

Data in Column B2 is gathered from another Spreadsheet A B C D E ... Item 1 334 Item 2 336 Item 3 338 Item...

I have a large database in Excel (40,000+ rows). When using the drop down filter button, it appears that only the top 1000 selections appear in the selection...

I’m using an active x control box with a map image to display text boxes of locations of systems we have in our office. This has always worked great until...

I built a range reference called REND. I placed it in cell W9 to see how it worked. i.e. W9 is =REND. Result is S9:S$50. Tried to use it in another formula...

Okay, so it's not as simple as the subject but here it goes. I have multiple worksheets that each contain three sets of bidding data. So on each worksheet...

How do I delete a ‘select box’? I copied a group of data from my stockbroker’s web page and pasted it onto my Excel 2007 worksheet (Vista operating...

If "RDO (Regular Day Off) is entered into C9 (Time In), the result in E10 (Total Hours worked) and F10 (Pay Hours) reflects #####, ##### rather than either...