Hello Everyone,
Hope this message finds you well. I'm trying to collect data from one sheet that are located in a different locations and post them in another sheet as a list. Please find the attached file to work on it:
Registration Sheet - 2017 Q4
[login to view URL]
In this file we I would like to collect information from this sheet "Client Profile" and post them to this one "Client Profile List View"
I would like to collect from "Client Profile" this information:
1. Full Name, found in cell "i2, i24, i46, i68, i90, and so on..."
2. Email Address, found in cell "AR2, AR24, AR46, AR68, AR90, and so on..."
3. Mobile, found in cell "BW2, BW24, BW46, BW68, BW90, and so on..."
4. ID Number, found in cell "i3, i25, i47, i69, i91, and so on..."
5. Nationality, found in cell "AC3, AC25, AC47, AC69, AC91, and so on..."
6. Gender, found in cell "AO3, AO25, AO47, AO69, AO91, and so on..."
7. Medical Condition, found in cell "BD3, BD25, BD47, BD69, BD91, and so on..."
8. Blood, found in cell "BK3, BK25, BK47, BK69, BK91, and so on..."
9. T-Shirt Size, found in cell "BU3, BU25, BU47, BU69, BU91, and so on..."
10. DOA, found in cell "CA3, CA25, CA47, CA69, CA91, and so on..."
And post them to this sheet "Client Profile List View" under the following order:
1. Full Name, to be posted under "B9"
2. Email Address, to be posted under "D9"
3. Mobile, to be posted under "C9"
4. ID Number, to be posted under "E9"
5. Nationality, to be posted under "F9"
6. Gender, to be posted under "G9"
7. Medical Condition, to be posted under "H9"
8. Blood, to be posted under "i9"
9. T-Shirt Size, to be posted under "J9"
10. DOA, to be posted under "K9"
Please help me with this as I have tried many times but I'm not that expert in formula writing or script.
your support is highly appreciated