My current cell contains: =VLOOKUP(D12,$AA$1:$AM$37,2)*F12 D12 and F12 have yet to be entered (and may not). Since F12 is not entered (and therefore is...

Hi Group, When I insert new rows into a spreadsheet who's columns contain formulas, is there a way to have the formulas of that specific column automatically...

Hi all I have created a workbook in Excel 2000 which consists of several worksheets. I wish to email, using Send, one of the sheets as an attachment without...

Is there any way to create an "universal" macro? I have to download info from a customers website. it saves an excel csv file. I then just copy paste into...

I have to do some SD calculations, however Excel will only allow for 30 groups to be evaluated, I have 120 groups to evaluate, any ideas? Thanks Dean

Hi everyone, I would like to use Get external data in the Data tab to query data from mulitple workbooks. By doing so, i supposed, there is no need to open...

A while back, I created a simple macro in an excel workbook that I regularly used. After a few days of use, I realized that it was a stupid macro, and deleted...

Hi - When I finish editing a formula containing a countif calculation, it changes from a formula to a regular cell, despite the '=' and I get a message that my...

Hi - I'm trying to display data based on the last complete workweek, i.e. today, the data displayed should be for the week ending Oct. 8. Monday, I want to...

I have a column of calculated results. I have applied conditional formatting to alternate colours per line, then to change the font colour for values between...

Hi - I'm trying to retain or obtain formats when performing a lookup function. Essentially I have a list of Accounts and Accout Reps. Each Rep has a...

I make multiple worksheets for different days of the month. I end up copying and then renaming. Is there a way to AUTO-FILL the consecutive dates so I...

I'm trying to use a Logical Formula. IF('Sheet 1'!B170,'Sheet 1'!B2*'Sheet 2!B3+'Sheet 1'!B3*Sheet 3!B3...ect., 0). But in the TRUE logical it will only...

On a few of my worksheets I save and use again I am unable to select a border without having to change “color� from “automatic� to “black�. How...

I have Excel 2003 and I want to print data entered into a spread sheet with page breaks onto 3" by 5" cards. There is not a 3" by 5" paper option in Excel......

Help! My boss told me to convert all these spreadsheets listing dollar amounts to Euro. I can't figure out how to do it.

I want a Macro to run only if a cell listed in column B says "Red" to create a seperate spreadsheet. I currently have 86 line items in this sheet which could...

I have a spreadsheet to keep a running balance. I have a formula =sum(c2,-a3,+b3). It is copied thru the speadsheet. It works fine except the last balance is...

Hi :) Ok the way i am doing this currently is, to be blunt, rubbish. Thus i am hoping someone could help me out here. Basically i click on a button that...