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!