Dear friends, I have the list of names that changed with the time. I need to compare them and find out the differences. Anyone can help me with this issue?...

Hi................ I have created a macro and want to run that macro in all the excel files. But to that I have to open the file that contain the macro every...

Hey guys... I have a weekly check sheet and the days of the week auto-fill from the "week starting date" that I fill in in another cell. That works fine. ...

I have a large workbook that I enter data into each month. On one worksheet I need to copy only certain pieces of the current month's data. I know I need a...

hi all, im looking to have a tolerance for a value in column D depending on the entry in coloumn A (product size). if over or under this tolerance then the...

I'm trying to understand the Regression function- would someone be able to explain the steps to calculate Regression and the info the formula generates?...

I'm attempting to forecast the amount of money spent on the purchase of company cars for the remaining of the fiscal year. (Column 1: Costs of cars and...

When I type info on sheet1 - it also displays the same info on the following sheets. My file name as at the end of it. Have I some how grouped/linked my...

We have a workbook containing several sheets. Each sheet will eventually have many named cells. When we name a cell and then hit GO TO these named cells...

I need a formula that will display a date as the day of the week, the month and the date (example: Wednesday, January 26). I've researched all the...

I am not an excel expert so I'm hoping someone reading this might be. I am attempting to create a "Scoring" sheet with pre-set values for criteria. What I...

I have Excel 2007 and am attempting to use the data validation tool. I have created several lists in a separate worksheet and named them (In the name box). ...

Im tring to put a list of names in ABC order the simple way

I would like to know if there is a way to do the following: File #1 Product Key Count Red/12 1000 Red/24 2000 Green/36 3000 File#2

Hello all, Please note that I have ben asked to create a spreadsheet that will generate a report for staff working in a call centre. The basic form is as...

Dear all, I use ADO to connect to excel file to read each row and input to my access table. the problem is access module alway understand text field, ex:...

Dear all, How can my formulas return collum heading of specific current cell Thanks for help Bac

want to highlight the NAMES OF THE STUDENTS who have got more marks in the TEST than PRE-TEST ? Eg: Student name Pre-test ...

When using the paste all with the paste link function for an entire worksheet between a source workbook in Excel and a destination workbook in Excel, the...

I've named the list of options in a new sheet in the same workbook. When I try to add a new option to the existing list, it will not let me rename the new...