ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Summary sheet help (https://www.excelbanter.com/excel-programming/276753-summary-sheet-help.html)

John[_55_]

Summary sheet help
 
Ok..

For all sheets, column K is "Times Fed" , Column A is "First Name",
Column B is "Middle Name", column C is "Last name", and Column I is
"On a diet"


The first SheetName is "Ducks"
The next sheet is "Cows", etc through 30 sheets.

Ok. I want to move data to a new summary sheet as follows:

For all values in Column K that are <3, with no coresponding X in
Column I, then copy the contents of that row's columns A-C to a
summary sheet.

If you are folowing this, the summary sheet should list the first,
middle, and last names of all animals (all ducks, cows,
chickens-through 30 catgories) who have not been fed three times a day
(and aren't on a diet) who aren't getting enough food daily.

Any help appreciated! Thanks!

John

Don Guillett[_4_]

Summary sheet help
 
I used Ron de Bruin's google search with summary sheet as the subject and
got
http://tinyurl.com/n0om
"John" wrote in message
om...
Ok..

For all sheets, column K is "Times Fed" , Column A is "First Name",
Column B is "Middle Name", column C is "Last name", and Column I is
"On a diet"


The first SheetName is "Ducks"
The next sheet is "Cows", etc through 30 sheets.

Ok. I want to move data to a new summary sheet as follows:

For all values in Column K that are <3, with no coresponding X in
Column I, then copy the contents of that row's columns A-C to a
summary sheet.

If you are folowing this, the summary sheet should list the first,
middle, and last names of all animals (all ducks, cows,
chickens-through 30 catgories) who have not been fed three times a day
(and aren't on a diet) who aren't getting enough food daily.

Any help appreciated! Thanks!

John





All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com