General

Paste Formula
How can I put a "Paste Formula" command on to the toolbar similar to the "Paste Formatting" and "Paste Values" Having to go to Past Special and select it every time is a pain. ... 18 Feb 2010 19:38

Inserting a picture XL2003
If cell A1 contains a ref EG "C:\ Photos\Pic1.jpg ( this could be up to Pic200).Is it possible to insert so that Pic1 appears in cell "f1" ? I have downloaded some code which will work but it means keeping all images in the same worksheet. Ideally I would like to leave them all as ".jpgs" in a separate folder... 18 Feb 2010 15:08

if/and array in MS Excel 2003
What I am trying to do: I have a list of 35 clients (column B), a row of 7 available catalogs (row 1: catalogs 1-7 in columns C-I). We have approximately 50 mailings per calendar year so I have columns O-U (O(orange)=catalog 1, P(purple)=catalog 2, Q(green)=catalog 3, etc) set up with color coded columns to t... 18 Feb 2010 15:08

IF/AND ARRAY in MS Excel 2003
What I am trying to do: I have a list of 35 clients (column B), a row of 7 available catalogs (row 1: catalogs 1-7 in columns C-I). We have approximately 50 mailings per calendar year so I have columns O-U (O(orange)=catalog 1, P(purple)=catalog 2, Q(green)=catalog 3, etc) set up with color coded columns to t... 18 Feb 2010 15:08

word to excel data transfer help
I have a word document that i need to export to excel. The data is addresses and a when i paste it into excel it fills up more than one row. Is there any way of controlling the data such that i can fill up the data in each row. please help. Eg: Certificate has no expiry date listed. Have to check with SGS at ... 18 Feb 2010 13:59

paste link not working
Hi, can any one help me please, I have two workbooks that are linked using special paste and then paste link, but for some reason just lately the links have stopped working and I need to reload them, each time I open them both up. Any Ideas?. Thanks in advance , Sam. ... 18 Feb 2010 16:15

EXCEL MACRO ISSUE - PLEASE HELP
I need a button so that when pressed it exports the data from the cell range sheet 1: A21:S81, it also exports the info from the same range A21:S81 on sheet 2 to an external excel workbook. I need it to export all the data onto sheet 1 of the external workbook, and each time the button is pressed it needs to f... 18 Feb 2010 12:51

Which criteria was matched?
On one sheet I've got a large dataset containing products with many fields. On another sheet, I've got a list of criteria that the products cannot violate. Both the list of criteria and the product list is quite long, so I've set up a DCOUNT formula in a field on the products list to evaluate each line to see... 18 Feb 2010 11:43

custom formats
How can I format 31,840,000 to appear as 31.84M, and or 35,000,000 as 35M? Thanks -- Allan ... 18 Feb 2010 12:51

minutes
I have a spreadsheet that I would like to add up my minutes. So I have one column that has 4:20 and the next column that has 4:40, how do I get the next column to add up the minutes (15 minutes)? Thank you -- mlenno ... 18 Feb 2010 11:43