I have an excel sheet that has external references to other sheets. Is there an easy way to automate the external references to be added to my consolidated...

I have a subform that is a continuous form(PK ProjectID). The record source is a query that limits the field called KeyMilestonesSubID to a choice of 15 or...

I have a subform that is a continuous form(PK ProjectID). The record source is a query that limits the field called KeyMilestonesSubID to a choice of 15 or...

I have a workbook that has about 2 worksheets in it. I need to pull all the data from each column, one column at a time, into a "master" worksheet. I...

I have a spreasheet with Columns H-AB, BD-BF, and BJ-CD grouped. Therefore I have 1 level of column grouping. What is the VBA code to collapse and expand...

My column heading is filled w/color. Want to make column below same color only more transparent. In other words, lighter shade of same color as...

here is the problem, using vlookup ,,, the information is being transported from pages as requested by formulas,, however if the cells are empty there...

I setup a hyperlink for a cell in excel. It links to another folder on my PC. Whenever I click to open it I get "MS Office Excel Security Notice"...

I thought I understood the basic principles of SUMPRODUCT but when I add too many criteria I completely lose track of the syntax - any help is...

Hi, If I type a value into the cell which is the reference for the Vlookup i get the error "#N/A" yet if i copy and paste the same number from the lookup...

Hi, I am evaluating financial data based on payments received for services or written off. The values in column I is the charged amount the values in j-l...

I need to put the date into a cell which corresponds to the sheet tab which is date Jan 09, Feb 09?

I would like to set my Excell to open new from a certain drive or folder. I could do this in Excell 2003, but can not find in 07. Can someone help?

I need to formulate an email address for hundreds of employees. The email address is the first 7 letters of the name and first letter of first name followed...

Does anyone have any suggestions on how to import external data into excel? http://www.hkex.com.hk/markdata/quot/d091103e.htm#short_selling When I try to...

we just got the updated version of Excel and when I press the tab button it jumps me to the next page instead of the next cell - how do I fix this? thanks

My problem is that when printing a multi-page worksheet (all text) the print is cut-off about mid-page. I have set the margin edge-to-edge of the page and...

Can someone help me out with a formula? I'm trying to get a running total of impressions from data in two columns with a variable. If column g=letter than...

I have a very intricate excel spreadsheet. Many worksheets with many formulas. When I open it (using Excel 2003 and Excel 2007) it takes about a minute to...

I have several hyperlinks in a worksheet to images/pdfs. When I save the spreadsheet, the hyperlinks fail, with an error that says "the address of this site...