Dec 06 2021 12:55 PM
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
Dec 06 2021 12:59 PM