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)
Bookmarks