General

How did I populate other cells based on infor from one cell?
Hi, Ive got a spreadsheet with staff information such as network username, first name, surname, department, job title, ethnicity, age etc... How do I (if possible), automatically populate the first name, surname, department, job title, ethnicity, age etc... by just typing in the network username? Any hel... 21 Apr 2010 08:26

using Sumproduct with named ranges
Hi, Hope someone can help. I have named ranges in tab 1, Column E=B is for Branch, Column F=G is for Game, & Column G=P is for points. Named ranges are all from row 6 - row 501. Data is input into tab 1, summary in tab 2. In Tab 2 I have the branches from A3:A9, Games from C2:L2 In C3 I am wanting t... 21 Apr 2010 07:24

Simple Yes/No drop down box
Hi, I am looking to create a simple drop down box which has yes or no as the options. For the life of me i can't remember how to do it. Thanks ... 21 Apr 2010 05:20

Conditional formatting of date-cell - 2007
I would like to conditional format cells - in colors - containing a date if date in cell is before or after TODAY(). This is not - strangely - an option in the general Highlight date occurring... CF of Excel2007. How do I do this, then? I have tried greater/less than but it did not work. Additional question: I ... 21 Apr 2010 08:26

bahttext
THE BAHTTEXT FUNCTION RETURNS THE VALUE OF A NO. IN BAHT TEXT. IN THE HELP OF THAT PARTICULAR FUNCTION, IT SAYS THAT THIS FOIRMAT CAN BE CHANGED TO OTHER FORMATS BY MAKING CHANGES IN THE REGIONAL SETTINGS OF THE CONTROL PANEL. I TRIED, BUT COULD NOT DO SO. CAN ANY BODY PASS ME DETAILES STEPS ON HOW IT CAN BE D... 21 Apr 2010 10:31

alternate row shading kept with autofilter
Dear experts, I have a range which can be autofiltered by users and it's in alternate row shading (conditional formatting, =mod(row(),2)). However, when users select their autofilter criteria, the alternate shading is broken so it is not really usfeul any longer. Is there a way I can keep it? Many thanks i... 21 Apr 2010 19:51

How do I insert a file into Excel 2007 spreadsheet ?
The old Excel command Insert-Object does not exist anymore, instead only these Insert {Tables | Illustrations | Charts | Links | Text } I want to insert a general application file, I pretended it is a .Jpg file by renaming it and attempting Insert - Illustration -From File, but of course this was rejected. ... 21 Apr 2010 09:28

Unusual Date Format
I am writing an Excel 2002 template. I am importing two columns of dates (date from and date to) from an external source. The date format is 'cyymmdd' so today would be '1100421'. The cells are formatted as text. I need to calculate the difference between the two dates, shown as a number of weeks rounded down ... 21 Apr 2010 04:18

Unusual Date Format
I am writing an Excel 2002 template. Two columns of dates (date from and date to) are both imported from an external source. The date format is 'cyymmdd' so today would be '1100421'. The cells are formatted as text. I need to calculate the difference between the dates shown as a number of weeks, rounded down t... 21 Apr 2010 04:18

Seperate data
I need help please. How do I go about to seperate data in one cell ex: A1 1-------2-b0-40810 A2 2-----------1-03-0060 I typically want to seperate cell A1, 1------from 2-b0-40810 and cell A2, 2------from 1-03-0060. Tx ... 21 Apr 2010 05:20