advice

Hi guys, I recently just started using excel and this forum and wanted to know how to make a spreadsheet that has automated subtraction in it. So when I enter a number in the subtraction box, it will automatically take away from the whole number in another cell. Then disappear so I could then...

Hi, As I deal with lots of data with multiple identfiers in my cost models I generally use Sumproduct and have done for some time. I have an issue though which i think I have identified as one of the labels in the Sumproduct formula that returns the #value. Formula is...

Hi there,I'm trying to work out what the Hotkey is to switch between sheets in excel.For example there is Alt+Tab for switching between windows, Ctrl + Tab for switching between open internet tabs, surely there must be a way to switch between sheets in Excel too, right?Thanks in advance for any...

I am working with a number of (weekly) tabs within Excel and find myself going back through these tabs to look at information. So say I am looking at 'Bricks' (column B) which has a code of 025 (column A), is there a way of making all the tabs locate this cell without me have to scroll to the...

Office/Excel 2007 Would like to create a chart comparing: -average attendance as a # over 7 year period (which declined) -membership as a # over 7 year period (which increased significantly) -with % of members attending over same 7 year period (which declined significantly) Not sure what type...

So, I use to be a lot better with Excel, but it's been quite some time, and I'm in Dire need of help. Here's the issue: I have a spreadsheet with 12,000 contacts in it (name, email, phone number, country, industry, etc etc). The sheet is kind of messy, and I want to clean it up. One way thing...

i want to make collumns 1-14 And 16-32 To Automatically resize to fit in any additional text added (E.G. collumn 17 currently has 144 in most collumns, but am wanting to change one to 1475963 which will not all be shown in that cell, I want to cell to automatically enlarge to beable to show it...

I recently tried to create conditional formatting for the following If cell = CB turn Yellow Black text bold and itallic If cell = S/Lit turn Bright Green Black text bold and itallic If cell = NI turn Gray 40% Black text bold and itallic If cell = email turn Aqua Black text bold and itallic If...

Hi there, Im pretty new to using formats on databases so I hope you can give me some simple advice, if it gets too tricky though I have a techy I can speak to. Here's what I'm trying to do In column AC I have a date column And in AE I have a comments column And in each row I have a...