Search results

Hi, Is there a quick and easy way of having text change colour when the pointer is over it, in excel? Cheers

Hi, I want format some cells based on the contents of another cell. For Example if A1 is True then I want cells A2:A10 to be coloured orange. I can't seem to work it out using the standard Conditional Formatting option - is it me?! Cheers

Cheers for that. The final formula was SUM(A1:INDEX(A1:X1,,C5)), where A1:X1 was the total range that I wanted to look at and C5 had the variable column number where I wanted to SUM to.

Hi, I want to be able to have a formula that sums a range of cells where by the starting point is known but the end point is variable number of columns to the left of the starting point. The variable number is a function of the number of days between today and the start of the month. This...

Hi, does anyone know if it's possible to link an excel workbook to a visio file so that any numbers changing within excel with update in visio? Got a presentation that keeps changing and I'm having to manually update a load of numbers! Cheers

hi, I have lines of data that is made up of a reference number (7 digits) and names. I want to be able to extract just the reference number from the string. The reference number is sometimes at the front, in the middle or at the end - which I have no control over. Does anyone know of a way...

Sure. We have 5 warehouses in our company and I store stock figures for each month in a table. I then append these to a master table where all of the data is for each warehouse. I then translate the currency into GBP and run some further queries. Right now I can't actaully think of a good...

Hi, I have a set of tables for different locations (5 in total) and 1 for each month. They are all called location.month, I want to be able to run a query that takes the month as the parameter and then runs a simple select and group query on the table matching that month. Can anyone help...

Just answered my own question. Using REPLACE (field.name, ASC(#),'new text').

Hi, I have some address data in a field that contains carriage return and line feed characters. I want to be able to replace these with comma's so I can export to excel and delimit via comma to seperate the address lines. Can anyone help? Cheers

Hi, I have a table that has, amongst others, a list of order numbers. Each order number may be duplicated many times and I want to be able to use a function like countif, in excel, to update another field with the number of times that order nubmer occurs. Does anyone know of a quick way of...

Hi, I get emailed some sales data on a daily basis, in CSV format, which I then drop into an access db and run some queries to produce a report. Is there a way I can have a script that will run on a scheduled basis to either pick up the files and move them to a server, for access to pick...

That works fine. Cheers

Hi, I want to be able to have a spreadsheet that has multiple worksheets on, and then have a summary sheet that has tick boxes relating to the names of the worksheets. I then want to be able to have a macro that will print out the relevant worksheets that have the tick box as true - is this...

That works a treat. Thanks for you help.

would you be able to give me an example? The INDIRECT function is unfamiliar to me and I'm not having much luck. The online help isn't doing much for me either! Cheers

Hi, I want to do a vlookup that will look in a worksheet depending on the value of a cell. eg cell A1 is zone number, say 3. i have 8 worksheets in the file called Zone 1, zone 2 etc. So I would want the lookup to refer to sheet Zone 3 based on the value in cell A1. Is this possible...

Worked a treat. Thanks for your help.

Thanks for that. I'm not running the query through a piece of code though - anyway I can just run it on it's own?

Hi, I'm trying to run a very simple update query on a table that has around 200,000 rows. It is only updating one field with the month based on a date using the Month() function. It keeps saying File sharinglock count exceeded. Increase MaxLocksPerFile registry. Any idea's on how to do this...