lulul
03-09-2016, 04:42 PM
Hi everyone,
I am (very) unfamiliar with VBA, so please be patient :)
I have three tabs (one per region) with information on Client Name, Contract Amount, and Manager (see workbook attached). I would like to automatically populate a master list (in MASTER tab) pulling information from my other three tabs. You will notice that the list in each Region tab goes up to 15. This is because that's the maximum number of entries we would have in a month per region. I'd like the master list to automatically populate as we enter information in the other tabs, but ignore any empty spaces. For example, if we only have five entries in the North America tab, I'd like the master list to show the first entry in the Europe tab right after the last North America entry.
Also, because we have the regions split in different tabs, we do not manually track region per row entry. In the master list, I'd like to add each entry to each specific region. Please see the workbook attached with a sample of what I'd like the master list to look like.
Many thanks in advance for your help!
Lulul
I am (very) unfamiliar with VBA, so please be patient :)
I have three tabs (one per region) with information on Client Name, Contract Amount, and Manager (see workbook attached). I would like to automatically populate a master list (in MASTER tab) pulling information from my other three tabs. You will notice that the list in each Region tab goes up to 15. This is because that's the maximum number of entries we would have in a month per region. I'd like the master list to automatically populate as we enter information in the other tabs, but ignore any empty spaces. For example, if we only have five entries in the North America tab, I'd like the master list to show the first entry in the Europe tab right after the last North America entry.
Also, because we have the regions split in different tabs, we do not manually track region per row entry. In the master list, I'd like to add each entry to each specific region. Please see the workbook attached with a sample of what I'd like the master list to look like.
Many thanks in advance for your help!
Lulul