I'm very new to VBA coding, so don't understand all the options yet, but I can read the code if someone can please help with VBA code for a macro to do the following:
Workbook 1 can have different options for regions, example: Workbook("1").Sheet("1").Cell(A2), can be "Inland" or "WC", etc.
Whichever region it reads should recall the list in Workbook("2").Sheet("List") and the corresponding data for that region which looks like the following:
A B C D E F G H I J K
1 INLAND KZN EC WC
2 GC57 Lenasia KF05 Family Pietermaritzburg EC06 George WC55 Local Kenridge
3 GC20 Gallo Manor KF01 Family Kirstens EO08 Express Fiveways WC10 Sea Point
Example: If WB1 reads "Inland", copy whole list from WB2 "Inland" cells (A2: B[end]) and paste in Workbook("1").Sheet("List").Cell(A2).
I hope it makes sense and that someone can help, I believe it's fairly easy to code this request.
Thank you
Bookmarks