Opv
03-02-2010, 02:47 PM
I am in the process of constructing a rather large database of time and payment information for five individuals who work from time to time for my brother on his small farm. My preference would be to keep the time, hourly rate, pay, etc., for all five men within the same spreadsheet (as opposed to maintaining five separate spreadsheets) and then to be able to have a separate sheet within which I can easily extract information for one at a time and view, edit, print, etc., as needed, as well as generate reports for combined total hours worked, wages paid by time period.
My interest at this point is not in how to design the data sheet but, rather, in a way to extract one man's data into the separate sheet without including a bunch of blank rows. I've tried IF with VLOOKUP and I can bring the relevant rows of data in, but it also leaves tons of blank rows representing the rows of data applicable to the other men. Is there a function that would accommodate extracting only the rows of data for one individual from within the larger database without including blank rows.
I've attached a sample spreadsheet for test purposes.
Thanks,
Opv
My interest at this point is not in how to design the data sheet but, rather, in a way to extract one man's data into the separate sheet without including a bunch of blank rows. I've tried IF with VLOOKUP and I can bring the relevant rows of data in, but it also leaves tons of blank rows representing the rows of data applicable to the other men. Is there a function that would accommodate extracting only the rows of data for one individual from within the larger database without including blank rows.
I've attached a sample spreadsheet for test purposes.
Thanks,
Opv