Exporting data depending

[kennywt]

Hi all

sorry still working my way around here.

Each week I have to do a report on trading stores and I am wanting to pull data in different ways.

The first questions

Is there a formula to copy data from one sheet to another based on a value?

For example on week one, i put this in my sheet called week 1

Name	Revenue	Profit	Sales
Mr Blue	110	5	2
Mr Green	234	34	6
Mr Brown	223	66	7
Mr Yellow	111	33	3

<tbody>
</tbody>

On week 2 i get these results

Name	Revenue	Profit	Sales
Mr Blue	130	10	5
Mr Red	234	44	7
Mr Brown	455	66	7
Mr Black	111	34	7

<tbody>
</tbody>

I would like sheet 3 to be a sum up sheet. I want to sum all revenue from the different Mr but as you can see, from one week to another the position of the Mr changes as it depends if they worked that week.

I know i can Auto sum to move data from one sheet to another BUT can i do it based on the Name rather than what row the data is on?


Would love some help if someone knows

 

[DataMike]

You could do some lookup/matching in Excel, but if you have to do this type of work every week, take a look at Parabola (https://parabola.io/). You could set this up in a couple minutes and then have it automated going forward. Basically you would import your two sheets and connect them with a "Join", based on the "Name" column of each table, which combines all the rows together based on the name. Then you could use the Formula Applier to add up the revenue columns in each row. And then export the result.