Hi All, I am a first timer. So bare with me. I would like to get the workbook name and place it in a cell in the worksheet. This is what I do. I copy a...

I need to take this list and pick a color by means of priority. In this example, I put a priority of 1 for the color of orange in the cell next to the color,...

Hi, I have a workbook with a lot of worksheets. I need to write a macro that: a) takes an input of date in (dd.mm.yyyy) format. b) takes an input of some...

hi! I am preparing a basic calculator for myself for some funds and I got into a trouble... there is a excel file U can...

A1 will have a 4 digit number and letter (ex: 1332s) B1 will have a number between 1 & 999 I am trying to get C1 to concatenate the two, taking the B1 value...

How would I have a cell return a value based on the intersection of two other cells. I have A1 with a Validated List running vertically (the percentages) I...

I minimize Excel and size it so it uses 1/2 of my monitor window. I open another window in the other half so I can copy data from this to Excel. On...

I minimize Excel and size it so it uses 1/2 of my monitor window. I open another window in the other half so I can copy data from this to Excel. On...

Hi all - I'm not sure if it's an IF statement I need - but if it is then I would like to know how to ignore cells with zero as the number. Let me explain...

I am using Excel 2000. I have a spreadsheet that has some calculations that are simple totaling of columns. Rather than rekey that total on another...

I am creating a form and certain fields are required. Can I force the user to input some value before they can save? Thanks! ~C

I would like an Excel cell to automaticlly populate a cell with the computer user's name. Is this possible? Thanks! ~C

I have a spreadsheet and I need to use a VLookup that then sums the returned values that repeat. Below is an example, where Ashish shows up 3 times in...

I have four feilds, First, Middle, Last and Email. I want to use a concatenation function in Email to combine First middle and last and automatically add the...

A client emails me a worksheet with to indicate which duplicate records need to be deleted. The client has multiple locations, so each location fills marks...

I have a spreadsheet. When I enter in a date in the "Date Reply Sent" column, the issue is now closed. I would like that row to line out. Is there a way to...

I have a cell that equals the remaining number of hours of vacation pay. I would like to have a cell next to that that would indicate how many work days are...

If I have a starting cell equal to say: 8/1/2004 I would like each cell under that one to show the 1st of the next month. If I change the starting cell, the...

I want to calculate the monthly mortgage payment in my spreadsheet. The interest rate is fixed Cell values: A4 = principle A5 = interest rate A6 = years of...

I'm working with a spreadsheet that has automatic calculation disabled because a large number of UDF database lookups refer to one cell and recalculating the...