We help IT Professionals succeed at work.
Private
Troubleshooting Question

only pull rows with data entered

Tom M
Tom M asked
on
25 Views
Last Modified: 2020-10-23
In the sheet labeled "uploader" is there a way to tweak the formulas so it only pulls data from the rows that have entries in them on week day sheets (Saturday-Friday).  Essentially eliminating the rows in the uploader sheet that are shaded in grey.  Basically if the time is greater than 0 in the week sheets (column q) I need that rows data in the uploader sheet..Please note in this sheet I only pulled in data from one week day sheet Monday, but all 7 weekday sheets will end up pulling into the uploader sheet...  
Payroll.xlsx
Comment
Watch Question

Tom FarrarConsultant
CERTIFIED EXPERT

Commented:
So are you saying you only want Saturday, Monday, Wednesday and Friday?

Author

Commented:
Yes in the final solution I will need to include those other sheets as well
Mechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION