I have a workbook which contains six worksheets...nothing unusual there but when I go to print the whole work book out it see the first three worksheets as...

Hi, I have a spreadsheet with all the clients sales and one of the columns is the country of the client (which is empty). On another sheet I have all the...

I am pasting data into a cell but want to limit it to a specific length. Is there a function that will limit the text to the length required and carry the...

Hi - I have two columns as below: A B 01/03/07 B1234 01/04/07 B1235 01/05/07 ...

How to vlookup data. I have Data like MSCName Code 452016 Trade Link 452016 785401 V Trade 785401 If I type only Trade Link or 452016 it should lookup...

Hi all, I have a workbook with 31 sheets for each day of the month, I also have 5 sheets for weekly data. How do I for every month put a date on a menu sheet...

I have a macro that goes to a cell and sets a var to the cells value. This value is a time such as 6:00, 8:00, 20:00, etc. I then use the application goto...

I noticed a lot of you use different symbols in your functions, such as &, *, ^, etc. It there a glossary or a list of these commands somewhere that tells...

I would like to pull information into an excel sheet, possibly with a lookup function, from a query (Age Report) in ACCESS. Is there a way to do this?

HI, I've got a series of numbers in a row from which I need to know the IRR. Because the first number is positive the function is returning the #DIV0...

I am attempting to create a macro that will convert a date formula to a standard date which will not show the formula. Following is the formula. 1/1/2007 is...

What would you do if the resulting time is greater than 5 pm, you want it to add the hours to the following day starting at 8 am, and it skips weekend...

This formula will find a product name in F1 and match it to a product name in a range in column A, then it will return the data that is one column over and...

Hi All, I have two columns one: A1 value 100,A2 value 201,A3 value 33. I need to put in B1 the value of A3, B2- A2,B3-A1. Is there a way to acomplish that...

I defined a name that was equated to an array of values returned by a function. After typing the definition, I tried pressing ctrl-shift-enter. The...

I have in Excel few work sheets on one file. Each sheet content diffirent item with description and Part # . I need create sepatate shhet for summry . Coul...

I would consider myself an intermediate user... I created a workbook with each worksheet representing a month. My partner and I (wedding coordinators) share...

I am working with two databases. The first one is 6139 records that we have already mailed brochures out to. The second one is 5300 +. I want to compare...

Refering to the post in General Question A1 = B1 = A2 = 18-Jan-07 B2 = 1 A3 = B3 = A4 = 20-Jan-07 B4 = 1 A5 = 24-Jan-07 B5 = -1 A6 = B6 = A7 =...

Hi I've a button on an excel file and clicking on it will copy sheets from another excel file. The sheets are copied but what happens is that in the copied...