I have a long list of people extracted from a database. Some of the names are in the format of "John Smith" or "Jane Smith" on different lines, but some of...

Hi, I am given a whole list of Customers from different Countries who stayed in my Hotel for different months in a financial year beginning with October. My...

Hi I have 4 columns as follows Call1, Call2, Call3, Call4 and then % Complete. So if Call1 has a date in it then the Complete Column should show 25%, if...

Is it possible to set a format to a cell so that if I enter a value it returns with adding 15% to it. For example if in A1 I enter 100 it should return 115...

Hi I have a spreadsheet for a mailshot we have just conducted, we dont have the luxury of a CRM tool so wondered if it was possible to link say A B C Comapany...

I have two separate spreadsheets created.... pg 1-50, and pgs 50+.. how do i merge the "pg 50+" into the "pg1-50" as just a second sheet, instead of 2...

How can I easily delete empty rows on a huge worksheet (other than sorting)? (Excel 2007) Felix

I want to do a continuous +1 in A1 thru A17 - ex. A1 = H03860, A2 = H03861, A3 = H03862 ------ yes I feel very stupid asking this!

i am trying to create a progress monitoring type of assessment for students using a 5 point scale (0 does not perform; 1 performs minimally; 2 moderate...

I have a ribbon on a worksheet that only functions to hide and unhide hidden columns. I do not know how this ribbon was inserted and I cannot find out how...

Hi I'm building a reporting template in a workbook on one tab "Backend" I hold all the DV List values Customer, Sector, Region, Month etc The next tab "IT...

quiero Obtener el atraso en dÃ*as a partir de la fecha actual, gracias

I am a newbie to anything above basic level in Excel. I know how to create and use Command Buttons, but I need to create a "Warning! Are You Sure" message...

I am using Microsoft's site to read the posts in NG. (http://www.microsoft.com/office/community). There is a minor problem which wastes time. After reading a...

One of the sheets in my ledger workbook is for annual cash receipts. Column D is for the amount (formatted to number-accounting)and Column E is for who it's...

I need to set up a worksheet to keep track of different savings accts. so I can put in the interest earned (20 cents, you know) each quarter. I used to keep...

Hi new to this. in cell B13 I have a drop down box with 3 options Post Courier Air freight and I need function that will allow me to have a different answer...

As for your specific request, go to T1 enter"=" and click "A1". This way upon entering a data into A1, it will be automatically entered to T1 as well. If you...

1 ; 45 ; 0 I want to change the color of each of the above numbers to bold green, 1, then bold black 45 and finally bold blue 0. Each number in the one cell...

I am trying to apply 10%tax when tax needs to be applied (i.e. when next to the item I have placed a y. If there is no tax to be added, (i.e. displayed by an...