Hello everyone. I've got two separate worksheets "eric's jobs" and "john's jobs" that have identical columns "date awarded", "invoice number", "date work started" etc... New data is added to rows as work proceeds, and new rows are added at the bottom of each of these worksheets as new jobs are obtained. I want to have both of these worksheets combined into a master "all jobs" sheet as new stuff is added. I don't want to have to run a new combine command, but rather want stuff to automatically update.
I've looked into it a bit and found older examples that might work, but not sure whether they are still valid.
It looks like the second link above is more in line with what i need, but it's over 10 years old. Before i put a bunch of effort in adding this to my workbook, will it still work?
Thanks for your help.