Bird spreadsheet

Hi people, i am a birdkeeper and am trying to set up  a workbook with various spreadsheets that relate to 1. an id 2.a pen number  and various other entries for each bird. On my Birds spreadsheet i have a colum named Pen and within the same workbook other spreadsheets named Pen1,Pen2,Pen3 and so on. What i want to do is , when i buy or breed a new bird i would enter its details into my Birds spreadsheet in a new row,  and in the colum named Pen if i was to put a 2 in the appropriate cell i would like the complete row of details to auto transfer into the spreadsheet named Pen2. Any help would be appreciated   Peter

Birds.xls19.5 KB
Birds-1.xls21 KB
Nick's picture

Bird spreadsheet

Hi Mr Feathers

To answer this question properly, I need more info.

1.  Add an excel file showing exactly the layout of the information.

2.  What are you actually trying to achieve here ?

... my thoughts are that a pivot table would work very well for your needs.

I have attached an example file to your post

... simply add new bird details in the empty rows, then right click on the pivot table, and choose "refresh".

Choose the pen number in cell F1 to see what is in each pen


Bird spreadsheet

Thanks for the reply. Have included a portion of the spreadshhet for you to check out. This is from a sheet named birds in my workbook also in the workbook is  sheets  named Pen1, Pen2, Pen3 and so on. What i want to do is, i  enter details into bird sheet as below and when i include Pen number under Pens i would like that row of details to duplicate into the appropriate Pen 1,2 or 3 spreadsheet ie; in row 1 below i have a cordon blue cock in pen 2. as i type in the pen number[2] into its column under Pens that data from the row would copy over to next available row in the Pen2 spreadsheet. As i have about 400 birds being listed under my birds spreadsheet, its a bit hard trying to keep track of what is in each pen at a glance. Thanks for any assistance given. Peter

BirdId Species Type LegRing Pens Sex Origin From Who Leg    
1c Cordon Bleu Red Cheek Pur 2 Cock Exotic Bundy Bird sale Right    
2h Cordon Bleu Red Cheek Red 2 Hen Exotic Bundy Bird sale Right    
3c Cordon Bleu Red Cheek   Cock Exotic H/bay Tony      
4h Cordon Bleu Red Cheek Dar Green 2 Hen Exotic H/bay Tony Right    
5c Cordon Bleu Red Cheek   Cock Exotic Mbro Blue      
6h Cordon Bleu Red Cheek   Hen Exotic Mbro Blue      
7c Orange Breast Normal Red 2 Cock Exotic Mbro Blue Right    
8h Orange Breast Normal lBlu/Red 2 Hen Exotic Mbro Blue Right    
9c Orange Breast Normal LteBlue 2 Cock Exotic Bundy Bird sale Right    
10h Orange Breast Normal LteBlue 2 Hen Exotic Bundy Bird sale Right    
11c Orange Breast Normal Wi/lGreen 2 Cock Exotic H/bay Tony Right    
12h Orange Breast Normal LteGreen 2 Hen Exotic H/bay Tony Right    

Nick's picture

Birds - use autofilter

Hi again

Rather than relisting all the pens on separate worksheets, use autofilter.

I have attached a workbook called Birds-1.xls

To see what is in pen 2, select the arrow on cell E1, and choose 2.



thank you,this has solved the problem. still would like to know how to do it the other way just to know how to do that sort of stuff. peter

Nick's picture

Bird Stuff

Hi Peter... this is a long and windy road, but I'll start you off

You need to learn VBA to do what you're intending..