General

Lookup / Match function
Hi, I am looking for any kind of function that will enable the following:- Sheet 1 Col A Col B Col C Col D Col E Col F Name Inv No Date Value Job No Payment due Date XYZ 1234 1/2/08 £1500 1000 4/7/08 Sheet 2 Col A Col B ... 4 Jul 2008 10:00

Restricted Access with Macros
Good Day All, When one restricts access to the Excel Document via Restricted access and the file contains macros and works within the document before closing it all is ok. When you close the document and then reopen, the doc reports restricted access, but doesn't report macros as being disabled until you at... 4 Jul 2008 05:55

Working with dates
I have 2 worksheets, one containing a summary to countdown while the other contains 2 columns of the following (up to week 40): Week Date 1 7-Jul 2 14-Jul 3 21-Jul 4 24-Jul 5 31-Jul Is there a formula that i could use on a cell within the summary w'sheet where it does a countdown to the planned dates a... 8 Jul 2008 06:56

if helf
i have a list of customers in col A and one customer attracts a rate o £10 all other customers attracy a rate of £15 in column c i have hours per job. i want to multiply the hours by a rate applicaple per the customer? ... 4 Jul 2008 04:54

Comments
Hi I've created some comments on an excel worksheet, and selected the option to show the comments. When I go to print the page I cannot see them. Is there anyway I can print showing all comments??? Thank you ... 4 Jul 2008 04:54

how to email a single worksheet fro m Office 2007
I have got the QAT to have "send now" but it's not giving me the option to send the worksheet via email. please assist ... 4 Jul 2008 13:05

how to change this format?
Hi,all how to change 30.012,00 format to 30,012.00?not in format----cell pls. any suggestions? -- THX! ... 4 Jul 2008 04:54

Macro-enabled workbooks
I have an Excel '03 workbook which contains large amounts of macros and VBA. If an Excel '07 user opens the workbook, and saves it as a "Excel Macro enabled workbook", then the VBA functionality continues to work for them. However, often times they forget to save it in this fashion, and save it only as an "Excel... 4 Jul 2008 14:07

closed workbook macro
Hi, i need a macro to import from 4 closed workbook. I need to import just one name with the other cells next to it. And make a list with all the data the macro can find in closed workbook. Thank you in advance. ... 4 Jul 2008 18:12

Make Paste values default...
Hi Is there a way, when a user selects 'paste', to make Paste text (i.e. no formatting) as the default for a worksheet? I've got a problem when the users are copying/pasting data from MS Wrod and taking the formatting with them, messing up my pretty work. Boo-hoo. ... 4 Jul 2008 02:51