Hi guys, want to do a lot of copying from one tab to another.
First tab has a listing of countries (Row A to Z) and the 2nd tab has a listing by products (Column 1 to 5)
I'm trying to sum up all the products of each country and place it in the first tab. As you can see, simple copy and pasting after inserting one formula doesn't work because of the rows vs columns. Does anyone have any way for me to easy achieve this without changing all the formulas manually? I have quite a few of these to do and if I can figure this out it will save me a lot of time!
Thanks!
First tab has a listing of countries (Row A to Z) and the 2nd tab has a listing by products (Column 1 to 5)
I'm trying to sum up all the products of each country and place it in the first tab. As you can see, simple copy and pasting after inserting one formula doesn't work because of the rows vs columns. Does anyone have any way for me to easy achieve this without changing all the formulas manually? I have quite a few of these to do and if I can figure this out it will save me a lot of time!
Thanks!