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
| Attachment | Size |
|---|---|
| Birds.xls | 19.5 KB |
| Birds-1.xls | 21 KB |
»
- 4feathers's blog
- Login or register to post comments
- 15151 reads
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
Nick
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
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.
birds
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
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..
excelexperts.com/Free-VBA-Training-Videos