macro/vba using address function paste values

[reggie1000]

hello,

being new to vba/macro's i need your help, i have a worksheet that i have vlookups in, these look at a master sheet and return the results, the macro i need takes the formulas and returns the values of the cells (this creates a permanent record) then copy the formulas into the blank cells below so it can start again.

i have attached an example of what i need, hopefully someone can help, if you need anymore info, please let me know.

many thanks reg

[Leith Ross]

Hello reggie1000,

I added the macro below to the attached workbook. This copies the information from the Order Form (2) worksheet over to the Record Sheet starting at the next empty row on the sheet. The record is then formatted.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[reggie1000]

Many many thanks Leith,

works just how i wanted it to.

many thanks again, reg

[reggie1000]

hello leith,

thanks for the code for my problem, but i have another problem with the sheet, this is of my own doing, in column B on the order sheet, the driver name was the same for each line, however, i would like to add different drivers names as well, on the record sheet only cell B11 is names in the record sheet, i have tried to edit the code but with no success.

many thanks
reg