While working in an excel sheet I can do a "Find" ctrl F and enter the # I am looking for. I hit "Enter" and the cel is highlighted. Here is the problem. I...

I have a budget set up for the year. Each column represents one month and all budget categories are the same for the year (represented by rows). I want to...

I posted this on an Outlook ng by mistake. I was told to look up "VLST" on the web for scripting in Excel 2007, but there seems to be very little information...

I have several pages of a large workbook skipping columns A and B which creates a seperate page for A & B, then Columns C through H come out on a second page...

I have several pages of a large workbook skipping columns A and B which creates a seperate page for A & B, then Columns C through H come out on a second page...

I've been given a table with two columns and two rows: ColumnA ColumnB 5 3 100 1 Each number in column B is a percentage of...

Dear All, I need to check certain cell, if the format colour is Red, i want to put figure 1, Black = 2, Blue =3. Please help by using formula? Thank you...

I have a list of a bunch of people (employees) (column A) and in another column (B), their managers. Each employee has a single record, but a manager name...

Hi, I am trying to import seven worksheets (all from one EXCEL file) into seven OLE inserted objects (using the EXCEL driver in AutoCAD) into an AutoCAD 2005...

Hello again, I have a separate function that I need in order to tell how many workbooks are open besides the one I'm currently in. Basically, I want to know...

I've got a 2000 row worksheet where I want to count the number of occurences row where two row conditions are satisifed eg In the example below if I wanted...

Hi everyone, I am new to this, so bear with me. At work we are switching to using an enfold desktop type filesharing system, and I am housing a testing...

I am using a workbook that has many links to another file as below. Unfortunately the source file name changes each day, with the new source file name being...

Hi Im a VBA novice so please take it easy on me. I know of it and think I can get it to work but it isnt taken for granted that I can. I have lots of...

hi I wnt to do numbering in excel sheet . There should be a prefix like: ANA etc. for each row.

Hi! I ´want to use the worksheet function LARGE for three different cells. however the cells are not placed next to each other (and i cannot change that)...

I am setting up a physician call schedule.10 people 7days/week. Can I have excel count how many times each doc has taken call on each day .

I have a worksheet where I need to select a value based on which cell in a non-contiguous range has the MAXimum value. To be more specific, There are 4 cells...

I just want to use if function in excel to compare two cell and format or possibly copy some picture in the third cell using the result of comparision. e.g....

How to sort a column of text alphabetically so that the contents of the relative rows automatically sort with the column? The A-Z sort function seems only to...