SOLVED

Extracting Data from Main Page

Copper Contributor

Hi All,  

 

What i would like to do is pull information from Car 7 page to Lifts page and Driver A page
 
I have color coded the info to make it a bit easier as to where the info is to go.
 
Muchly Appreciated

 

Worksheet test File 

3 Replies
best response confirmed by forbesy71 (Copper Contributor)
Solution

@forbesy71 I would use SUMIFS as demonstrated in the attached file. By the way, better to get rid of merged cells in the header of LIFTS and note that the CAR7 sheet had December dates where the other two were for November. I changed the first one to November.

@Riny_van_Eekelen  Thank you Riny, worked a treat. Greatly Appreicated. 

@forbesy71 My pleasure!

1 best response

Accepted Solutions
best response confirmed by forbesy71 (Copper Contributor)
Solution

@forbesy71 I would use SUMIFS as demonstrated in the attached file. By the way, better to get rid of merged cells in the header of LIFTS and note that the CAR7 sheet had December dates where the other two were for November. I changed the first one to November.

View solution in original post