Happy new year to all! I recorded this macro some time ago, the cell A5 is selected at the end of the macro, ready for the user to insert today's date. How do...

I have a workbook with multiple sheets. On one sheet, for cell a22 (which is a thru g 22, merged), a value is entered, say 'single story system'. I want...

I have the following macro which I want executed for all worksheets within a book. I have tried it out and it only runs in the sheet that is selected, if I...

I am working on a new spreedsheet and wanted to multiply the total of 22 columns by a constant. No mater what constant I put into the formula =SUM(E53* )...

I have been using Excel 2007 to import comma delimited text (csv) files stored on my local hard disk into my personal finance spreadsheet. The DataGet...

Hi I am trying to calculate depreciation in my Excel spreadsheet. The depreciation is over 60 months, so for a $6,000 item, the formula is =$6,000/60 =...

I have several cells with an "x" in them. I am trying to get a total of the "x"s by row and column. I am new at this and need a step by step instruction....

I'm creating a spreadsheet for a client and I'm not sure what formula/function I need to do this: I created a table with over 500 available values. I then...

I have a column that shows employees working on a given day. The bottom cell of that column "total"s the number of employees working. I would like to have...

How can I import Access data that exceeds 65 rows? I understand that Excel can now handle 1 million rows - but I cannot figure out how.

I am searching for a way to change background colour by click in a cell and back to normal colour by clicking it again. Is this possible? And if how is it...

hello again, i'm trying to get this to work:- A1 = date ( changeable ) A2 = £ ( changeable ) B1 to B100 ( if B1 has £ in it move to next cell down without...

I have two sets of data (2 worksheets) one set contains a column with 14000 different numbers and a second column with corresponding values to these...

Hi, This is my first post and there will be many more to come I expect. My first Question is in relation to transposing. I cant seem to transpose linked...

I have several columns with several dozens of hyperlinked entries in each column. I'd like to unlink them all. I highlighted all entries in a column and...

Hello, I am new to Excel. I just downloaded an Inventory Template and have a question. I was inputing data in the fields, they are Gray and then white....

Hello! Text = "Receipts from:" Date = 10/5/06. (This date will in a different cell and will change every month) The decription I desire will be: "Receipts...

Is there a way to imbed the value in a cell in a text field? Something like: "Cost at / hour.", where "" gets replaced by the value in cell...

I would like to be able to delete a row with a name in it based on a cell with that name from another cell in a different worksheet. Any ideas? Thanks, Bernie

I have an excel file with two worksheets. is there a way to programatically compare the two worksheets to find matches and highlight those matches on each...