Hello and Happy New Year! I am working on a special project that requires me to match file names on two different directories. Some of the file names are in...

I would like a macro to stop at certain point to allow for input of variable information, then continue on with the rest of the macro. Is this possible or...

How do I print a one page spreadsheet multiple time, each with its own page number

I need an amortization schedule that allows changing the monthly payment amount. I have a house that I have sold to someone with a contract for deed. I...

I'm trying to create an IF statement. whe =IF(B3=GCVW-00001,"D3=X,"D3=O") I keep getting an error with my formula - now when i take out the GCVW portion...

I am an elderly new user of Excel and wish to use the numeric keypad. I can use it in other places but seems to switch off in Excel. Please help me in...

Hi TWIMC OK, I have the following test data in an Excel workbook and I want to be able in a pivot table to count the number of clients for each employee. A ...

I have a multiplication table that I wrote for my daughter in excel. I want to be able to create a formula or macro function so that when she wants to know...

Here's a step-by-step: 1. Copy code below: Sub CommentDateTimeAdd() Dim strDate As String Dim cmt As Comment strDate = "ddd, mm-dd-yy h:mm AM/PM" Set cmt =...

I have an extensive worksheet that has many conditions. I am using Excel 2003. I did not see this article as it relates to my issue, but, I am wondering if...

I have two working formulas and i need to put them both together in one string. Can anyone please help. i want to display the name of the top seller. The...

I need to be able to insert a picture into an unprotected cell in Excel while the worksheet is otherwise protected. This is a form that employees must fill...

Here's something like the data I have. Start Date End Date Flow rate 1/1/08 1/10/08 10 12/13/08 12/30/08 -15 5/15/09 ...

Have an excel with a list of persons. I have their levels in the hierarchy with the following structure : Top Node-Node0 Node1-node11, node12, node13,...

Please help. I have two spreadhseets with file numbers in column A, but a bunch of additional data in the other columns. I need to know if the files on sheet...

When I initially protect the worksheet it will not allow the users to edit objects or scenarios - this works great, but once I click on the button to add...

I want to format the text in cell F5 as BOLD if the text in cell F1 is BOLD. How can I do this in Excel 2007?

Cell A1 contains the name (Book) of the source workbook. Cell A2 contains the name (Sheet) of the worksheet in Book containing the desired info. What do I...

Can not seem to put together a formula that accomplishes the following: Column J contains contributions by individuals for 2010 Column I contains...

Hello, I have two workbooks, #1 I am not allowed to modify, information is sorted by equipment number and date of entry. I need the sum to show on another...