Good morning please help can i create an index sheet for all my excels files (XLS) regrads

Hi, I'm just preparing a summery sheet for an work book that contains more then 60sheets (date wise) In Column B7 - Sheet Name(i.e. 26th April In Column C7...

Hi, I had alot of help yesterday from Jacob with the following macro, but am getting a 'run time error 13' when trying to run the macro, and i cannot see...

I'm trying to code a program that allows flexible sorting based on certain criteria. I'm having trouble using a variable for sort order. Here is the code. ...

I have a spreadsheet which shows staff sickness each month. I would like to classify whether each absence is 'short term' or 'long term' in column F. Any...

Is it possible to have the formula in a column automatically be placed in a cell when you add a new row into an excel table (not a data table). Seems I saw...

Hi all, I knew it once, but I didn't program for a long time: What is the best code to get the column number (number!) of the last non blank cell in a...

In excel when we highlighted some of the cells with color. Finally those unique colored cells want to filter in single step.

Hello, This hopefully should be easy :) :) I want to reference a value in a different sheet, but I want the sheet to be choosen by the contents of another...

I have a column of data with records may duplicate, how can i create a separate list in other area of the worksheet for unique records only, is it possible...

Hi Experts, How can I get the results of vlookup where there are two corrsponding data in other sheet. One is blank and the other is non blank. I want to get...

Hi, i'm doing some MPG calculations at the moment and using a formula from a seperate worksheet which then displays on the first worksheet (="You average...

Is it possible to create an appointment within Outlook using Excel? The sheet will have a date when passwords expire, and this will be changed each month. Is...

hi all i need your help i have a table with two column first one date second rate for 365 days A B 07/03/2006 0.913 i need...

worksheet 2 contains A1-H130. I need to pull data from column F11:F130 into sheet 1. The cells in column f either contains "posted" or "not posted". I...

How do I trace only linked cell those are liked with another sheet or file to break unnecessary link regards

if anyone has used a list of names in an excel spreadsheet does anyone know how to alphabetise the names in the spreadsheet?

Thanks Gord. Can you please lead me with baby steps to create the macro then save it? I also like to make the footer a default for all new sheets/books. How...

Without going into VB, is there a way to display the chosen autofilter value? Column D1 is where I want to filter is located and it has 200 rows. Thanks.