• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Quick Excel question

D

DaveCSparty

Senior member
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!
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top