General

retrive data
Hi, I have a folder for each month with diferent workbooks. I want to create a workbook with 15-20 sheets. I need a vb formula to search a name in all closed workbooks and dispay in sheet 1 everything it found. In sheet 2, to display what it found but for another name....etc. But i need the formula to display th... 3 Jul 2008 04:18

looking for job card templates
looking to set up a job card for each job we do at work ... 3 Jul 2008 04:18

Scheduling Employees
I have approximately 20 employees and need to find an easy template that will allow me to enter the employees names down the left column and the days of the week across the top. I want to be able to note their scheduled lunch breaks and also be able to calculate their total hours and the total ammount of hours... 3 Jul 2008 09:25

TOOLBAR FOR A MACRO
I need to make a button on a new TOOLBAR for starting a specific macro. How to do the same? All help shall be appreciated. Thanx in advance. -- Best Regards, FARAZ A. QURESHI ... 3 Jul 2008 07:22

Finding a string of unknown length in a string of unknown length, Help!
On Wed, 2 Jul 2008 16:00:35 -0700, "RagDyeR" <ragdyer(a)cutoutmsn.com> wrote: Depending on how accurate your examples were, these might or might not work for you. These are longer then what you tried because I added the possibility that the data might have varying lengths. With data starting in A1 an... 3 Jul 2008 14:34

UPDATING LINKS ON OPENING?
When I open a workbook I am informed that the file contains external links and whether I want to update or not? I have tried many times to: 1. Open the file without updating; 2. Break links by Edit > Links > Selecting the link and breaking the same; The problem is that neither the link breaks/removes nor does su... 3 Jul 2008 08:23

check for value between 101 & 110 same value can't be repeated in
:. if a1 equals number between 101 - 110 then a2 can not equal same value - value is determined by "RANDBETWEEN" ... 3 Jul 2008 04:18

can I copy a number of cells in a column to a single cell ina row
I have between 6 and 10 pieces of data which I wish to copy from the column they are in, into a single cell (which has been merged to make it larger and more visible to see) The data which is just a series of numbers or letters (or a combination of both) do not need to be re-used from this merged cell Can you he... 3 Jul 2008 07:22

> 6 CONDITIONAL FORMATS
Hi Pete Saw your reply on this one which is great - have downloaded but cannot locate button/area/icon to enable me to action the options - did you have any problems?? -- Thanks Lise (Aussie) "Pete_UK" wrote: Bob Phillips has an add-in you can download from here: http://www.xldynamic.com/s... 3 Jul 2008 20:44

how do I enter cell value automatically to textbox?
I have an embedded map into my excel and had inserted a textbox but now I want to link the textbox to a cell in the other worksheet. How can I do that ? I want the textbox to show the value of that cell automatically. Thanks in advance. Have a nice :) day. Fadzil ... 3 Jul 2008 00:14