VBA Find values, copy and paste to next sheet.

I am new to VBA and need VBA code to do the following :

Find values, copy and paste to next sheet.
I have three sheets
Quotes
Costing
Accounts

I need to Find a value in "Quotes" in Range G24.
Copy the Value in "Quotes" in Range G24 and Find the cell containing that value in Row 8 of "Costing"
Once the Cell is identified,
Copy a block of cells below the identified Cell,
Find the next blank Cell on Row 3 (starting at C3),
Paste the Values.
This process will be repeated for the next value in "Quotes" G26
And the for G28 etc
I have attached a sample file.
Regards,
Trompie
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories