Hi,
Here is my typical senario:
Quote book is open and i run a macro that gets the cell content from the
following cells( C2, C4, C5,G1)
These are all passed to a variable.
I need to open another workbook( if not already open), search a range of
B5:B1000 and find a amtching number that is equal to C2 in first book.

example
( job number = C2(2256))
need to find 2256 in other workbook in range B5:B1000

Once this has been found, i need to insert the other cell contents into the
cells on the right of this first cell.

Example
B D E F ( columns)
(2256 £12,000 £3500 £4000 ( Cell contents )
C2 C4 C5 G1 ( Range in first workbook )

I am really struggling with a routine to open the book if it is not open or
switch to it if it is open ( yo prevent open read only ) search the range for
a matching value, and inserting the cell contents. This is going to ave me
hours if not days & weeks of work.

any help greatly appreciated.

Regards,

Nigel