Hello People :)

When u might think when all below has been read .. D*mn he's a newbie
:) Your correct. :)

So now on for my question.

I have 2 sheets.

In sheet 1 i have

sheet x witch has the folowing info on it
Kolom A : names ( A1 to x )
Kolom B : job discription
Kolom C : Cost price p/hour

In sheet 2 i want this info from above without opening sheet 1 ( + some
other stuff from other sheets but that not rellevant now )

I can make a hard "copy" like

Formule = "='G:\Excelhelp\[Sheet 1]Week 1" + "'!D$75"
Range("C7").Select
ActiveCell.Value = Formule

But offcource i dont want this.
When i add a new name i dont want to make another hard copy in my macro
for that.

So what i need but i cant make yet is :

A1 to x ( read untill you find the first empty cell )
+ the same info on that row for cell B & C
copied to sheet 2 .


Can anyone help me figure out howto do this ?

I think you all dont really understand what i mean so if you have any
questions please ask :)

Thanks in advance !!!!!!!

Greetinx Avatar



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/