Load cells based on 2 other cells

Hello -

I have attached a spreadsheet that has 3 tabs (Mother, ID, and Load). I have a Macro programmed that is breaking up the information on the Mother Tab in Column A based on byte location. The column in question on the mother tab would be Column K.

On the ID tab in Column A it has ID's.

On the Load tab in Column A it would have the ID's based on the criteria of this; Does corresponding cell in column K on the mother tab start with a letter, if so load information from Mother tab, if corresponding cell on mother tab starts with a number, load corresponding cell from ID tab.

Once cells on Load tab are loaded I would like to have a text box appear to ask the administrator to type in a farm name that will populate ahead of the ID's on the load tab that only have ID numbers in the cells.

The spreadsheet attached has the final product on the Load tab for clarification.

Thanks Much!!

Hi

Assumes you are on Mother when running this.

Please Login or Register  to view this content.

rylo

Thank you for your help and it looks to be working. Would their be a way to only have to enter the farm name once in a series vs. entering the farm name on each animal?


Thanks for your help on this.

Hi

OK, try this

Please Login or Register  to view this content.

rylo