Hello everyone,

Purpose: To extract data from certain columns in worksheet "BOLETA" and copy it to specifc columns in worksheet "Customer". There is also one condition to take into consideration - I only want to copy data from the rows where Column C is empty (meaning has no customer code).

I want to create a code that will do following things in this order:
1. Remove data existing data from worhsheet "Customer"

I believe this should work fine for that: Range("A5:AJ" & Rows.Count).ClearContents

2. Then for all rows where Column C is empty,
- copy values from column J, K, O of worksheet "BOLETA" and copy it to Columns B, D, F respectively of the worksheet "Customer" (starting from row 5)

3. Then for column J of the worksheet "Customer" insert text "Project 1" also starting from row 5 until the end of data

4. Then for column Z of the worksheet "Customer" insert formula vlookup(AA;´Post Code´!B:E;4;false)


any help will be much appreciated (i think 3 and 4 I can figure out somehow myself but the point 2 drives me crazy)