Help to move value into first empty cell and adjacent cell please

Hi,

Hoping someone can help me with this. I've got a basic knowledge of macros and vba code, and this is a little beyond my knowledge.

I have a chart with columns B-P, and rows 2-300 on worksheet 1. There are values in cells A1 & A2 on worksheet 2. I want a macro code to do the following:

1. Scan column B, rows 2-300 on the chart on worksheet 1, and find the first empty cell;

2. Input the value from cell A1 from worksheet 2 into the cell adjacent to the first empty cell in column B on worksheet 1 (eg. if first empty cell is B10, excel to input value from cell A1 into column C10 on worksheet 1); and

3. Input the value from cell A2 from worksheet 2 into a corresponding cell in column P (eg. if it entered the value in A1 into cell C10, excel would put the value from cell A2 into cell P10).

Would someone be able to help with the excel vba code?

Thanks & Happy New Year,

Sus

Can you attach a sample?

thanks

Happy New Year to you too!!

change the primary and other values to match your worksheets

Please Login or Register  to view this content.

my code

Please Login or Register  to view this content.

Happy New Year!!!

Thanks everyone - much appreciated. I'll give them a shot!

The code works great. Thank you all so much - really appreciate it!!

Sus