is there a code to allow vba to tell excel to recognize and save my first input value so the code below will be complete

what i am trying to do is have 2 cells, one tells the crew number(b3), the other is the average crew production(b4), they both will change per job, so for instance i have b3 set at 1 and the average for this job is 2000 if i set more crews lets say 3 crews then cell b4 shows 6000, however if i show the crews back to 1 crew the original inputted 2000 will come right back.

this works so far just need to recognize the original input value
Please Login or Register  to view this content.