EXCEL SHEET SHARING

New Contributor

I AM STILL A BEGINNER/INTERMEDIATE EXCEL USER AND AM ATTEMPTING TO CREATE A "MASTER TRACKING SHEET" OF JOBS FROM MULTIPLE SHEETS(SALES PEOPLE). ALL 4 SHEETS ARE THE SAME WITH THE EXCEPTION OF THE SALES PERSON WHO SOLD THE JOB. EACH SALES PERSON WILL UPDATE THEIR OWN SHEET WITH INFORMATION, AND I WOULD LIKE SHEET 1 TO CAPTURE THAT INFORMATION WHEN SOMETHING IS CHANGED IN SHEET 2, 3, OR 4. 

 

BELOW ARE THE 4 SHEETS USED, AND SHEET 1 IS THE MASTER SHEET FOR ALL THE OTHER 3 SHEETS. IM ATTEMPTING TO ADD INFORMATION FROM EACH SHEET INTO THE MASTER SHEET TO FOLLOW ALL JOBS ON THE MASTER SHEET 1.

 

SHEET 1 [MASTER JT]

SHEET 2 [JS JT]

SHEET 3 [DN JT]

SHEET 4 [KL JT]

 

IS THERE A FORMULA OR AUTOFILL THAT I CAN USE SO WHEN I FILL IN SHEET 2 [JS JT], SO IT WILL AUTO FILL SHEET 1 [MASTER JT]?

 

I HONESTLY DON'T EVEN KNOW HOW TO ASK THE QUESTION CORRECTLY, WHICH IS WHY I CANT SEEM TO FIND THE ANSWER IN OTHER THREADS. 

 

THANK YOU FOR YOUR HELP. 

DANNY

 

 

1 Reply

@TATTOODANATL 

 

SEE ATTACHED EXCEL SPREADSHEET.