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