Load cells based on 2 other cells

[mma3824]

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!!