Hi, I am working in accounts dept and have to prepare excel invoices daily. I have to write the total amount of invoice both in figures and words, right now i...

I am working with workbook with 30sheets for each day x each worksheet having same headers and colmuns x I want to copy selected rows to corresponding sheets...

Hi, I write in a macro ActiveSheet.Range("$B$5:$L$20000").AutoFilter Field:=2, Criteria1:=FirmCriteria then I should add also " or the firms which...

Morning, I am wanting to create several pivot charts from the same source but for different months. I have already tried to achieve this but if I create 1...

Hi, I have a macro that susscessfulling inserts any number of columns, however it is SUPPOSED to keep all the formulas and clear the contents of the...

Can some one please look at the following and tell me why i'm getting a mismatch error? Set EmailAddr = Application.InputBox("Select Email Addresses, Click...

Hi, I need a project completion sheet where .. the contents (TEXT) of the particular cell is to flash/blink upon some condition TRUE will any one respond...

I currently have an offset match formula that returns values from another workbook. The problem is the other workbook must be open or else the formula...

Is there a way to simplify the following...

Hi I need that when I click for print show a message remember me to do something else and just iniciate printage if I agree is it possible ?? many thanks

I have column A consists of employees names obviously in text format. Is it possible to say have cell B1 populated with the name that aears the most?

Dear Excel-lent users, Could you please help me with the following challenge ? In Row 2 (B2:AC2) I have the numbers of the week starting from 1 till 28 In...

I am looking for a hard copy manual for Excel 2007 in Farsi, Pashto, or Dari. I'm in Afghanistan trying to help some folks with Excel basics. A manual...

hi every one i tired to searching that security lavel in msoffice 2007 excel. can any one advise me to change the macro security leave such as very high...

Hi, There is a column date, When i refresh data in pivot table. then i want to be a maximum data should automatically updated on pivot table.

When I click on an excel document on my desktop, I get an error message saying: "windows cannot find . Please make sure you typed the name correctly, etc."...

I am using SUMPRODUCT formulas a lot in my spreadsheet (having recently graduated from COUNTIF thanks to reading through these forums!). However often my...

I highlighted many entire rows with color. Now my excel wants to print 115 pages. I can define a narrow print area, but I really want to delete the garbage...

ss containing 1000 rows ( one row per person) optimum way to produce table/chart (1 page per person) which can be distributed for checking. 3 columns...

I would like to crate a table - not using pivot tables Original table A B C Apple Green ...