Populating Table with Data

[TheDudeness]

Hi all,

I found this site very helpful thus far and was hoping someone could help me out with a table I'm trying to fill using VBA.

TableFill.xlsm

Basically columns K and L will define where the animal in row I will be placed in the table. Everything seems to be working for the animal and location in row 3.

Please Login or Register  to view this content.

Unfortunately I'm not up to the point where I can cycle through the other animals and associated locations.

What would I need to add to my existing code to be able to to this? I realize that what I have may not be great, anything that might be better please let me know.

There might be a possibility that there are multiple animals in each location, this would need to be incorporated into the code as well.

Again thanks for the help!

[mehmetcik]

Your code needs a lot of work.

There are a few issues here.

I will create your macro and then explain.

Please Login or Register  to view this content.

[TheDudeness]

Yeah...I am just starting the learning process; I've got a lot of learning to do. I've starting reading a ton of books and trying to get up to speed.

This site and the people on here have also been amazingly helpful! Thanks again, I really appreciate your reply.

[mehmetcik]

This is untested but achieves the requirement using two read operations and one write operation.

Please Login or Register  to view this content.

[TheDudeness]

You are the best! Thanks you so much!