I created a payroll table with drop down lists and numerical data. I would like to extract data with a certain variable (by the jobsite column) and place the entire row of data into another excel sheet which will just be a totals page for that particular job.

How can I do this?
If need be i can send my table to you so you can see the layout or provide a picture.


thank you in advance! I have been stuck on this for the past few hours.