Hey All - stuck on this for a few hours and pulling my hair out
I have 2 sheets (thats the way data comes to me)
Basically on the first sheet I want it to pull how many sales username has had if it matches date/username/campaign which is on the headers on sheet 2 rather on rows like sheet1 ( hence the headache) -hopefully that makes somewhat sense .. staring at screens all day!
I have 2 sheets (thats the way data comes to me)
| Book1 | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Date | Username | Campaign | Sales | ||
| 2 | 13/07/2023 | john smith | test1 | ? | ||
| 3 | 14/07/2023 | john smith | test2 | ? | ||
| 4 | 15/07/2023 | john smith | test3 | ? | ||
Sheet1 | ||||||
| Book1 | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | Date | Username | test1 | test2 | test3 | ||
| 2 | ######## | john smith | 1 | 2 | 1 | ||
| 3 | ######## | john smith | 0 | 1 | 0 | ||
| 4 | ######## | john smith | 1 | 5 | 3 | ||
Sheet2 | |||||||
Basically on the first sheet I want it to pull how many sales username has had if it matches date/username/campaign which is on the headers on sheet 2 rather on rows like sheet1 ( hence the headache) -hopefully that makes somewhat sense .. staring at screens all day!
