VBA Autofill question (changing row)

Hey guys (and girls),

Just a question from my side, I hope some of you will know it because I am breaking my head over this stuff for a long time.

I am creating an excel database which uploads data from one sheet to another for reporting purposes.

The following code I have created till (partially done by recording a macro).

Please Login or Register  to view this content.

Now the thing I want to do is the following.:

When creating the formula "vlookup", that specific cell is selected. From this cell I want to do an autofill till the end (in this case from column C till AE included), the thing is, is that the row number is changing and not constantly the same.

I was looking through different forms and tested several things, but nothing has worked till now. Maybe you will be able to help me out here.

Thanks already!

Swen

Hi RoyUK,

Thanks for your quick reply.

The problem is, and sorry I didn't mention this earlier when posting my thread, is that multiple people are using this workbook. In other words the workbook is set on shared. The other thing is, is that some of my co-workers are working from home.

When placing in every cell a vlookup code it will slow down the opening of the workbook. I could use a specific cell reference, but the problem is, is that the virgin data is placed as random.

Hopefully this will clear out some things.

Cheers!

Swen