I have a CSV formatted report, embedded in an HTML page that I'd like to automatically import into an excel 2007 spreadsheet. The page, requires that I log...

=VLOOKUP(MAX($A:$A),$A:$A,1) This function is meant to provide the value displayed in the lower- most/last active cell in column A. It is provided as a...

Hello all: I would like to know how to make this calculation. Below is a list of products and types and prices. I would like to know how can I make that...

Hi: I have a large spreadsheet that I track employee training on. The cells contain the DUE date of next training I would like to format it so that if a...

i have a single spreadsheet which will have various cells such a text, data. I want to create up to 50 copies as tabs client1, client2, client3, etc any...

I have a column of numbers, over 800 rows. Some numbers are 7 digits and some are 6 digits. I need a zero at the beginning of all the numbers with 6...

I have data in column B from B2 to B3295 now I want to copy (Transpose) the every 9 values in B column to one row, otherwords: b2: b10 change to c2 to k2...

can anyone help with a formula for conditional formatting? here's the scenario. I have a sheet that i'm using to track dues paid by members over a period of...

Hi, Is there a way or formula in the excel that could help to add the nearest month to get the figure for Column F. The month added up can be greater than or...

I am having difficulty getting my COUNTIFS formula to select data from a specific date range. I am looking for data based on a or date criteria. All my...

I have the below formula in "sheet2" of a workbook ("Schedule" being the only other sheet). =IF(OR(Schedule!$A$5="Totals", Schedule!$A$4="Totals"), "",...

Need to search for a text string anywhere in a column on another sheet, and return the cell reference of the first match found. Searched for text string...

I have two wooksheets. The first is the original sheet that has part numbers with pricing. This needs to be loaded into my database. Once done I need to...

I'm trying to use "IF" staements in Excel to pull values into fields as well as to change the field fill color based on certain parameters. Pulling the...

Hi Guys, I have a MASTER worksheet that I copy to create a new sheet before adding data for an individual. I have the MASTER sheet set up with all the...

Hi all, I've coded up a function in Excel that works in the Immediate Debug window, but not in Excel itself. The function looks up a cell range to see if a...

Hi! Is it possible to protect a macro to prohibit people to run it? -- Lois

I keep getting a #REF! error with the PRICE() fomula in my spreadsheet, even I copy and paste the expamle in the excel help. but if I paste the expamle in...

Hi, Is there a way to HLOOKUP a value from SheetB and display all the result of that value in SheetA? EG. SheetA: A1 Dust Desk