Worksheet sorting and cell recognition transfering

[Ty73r]

I am working on an extensive spreadsheet that will act as the registration program for a large event coming up. As exhibitors show up, they will give me their registration information, at which point I will enter it into the Master Data Entry sheet. After I have entered their information, I need it to then split up and transfer to other worksheets filling in the blanks on those documents. My question is, what is the best way to link the master sheet to the others so that I can then sort the master and not disturb the dependent sheets after they have been filled in.

Also, there is a section of the registration that allows the exhibitor to label which pen they want their animal in, I was wondering if there is a way to send information from the master sheet to the labeled pens based on what I type into the space on the master list.

Thanks guys

[Jack7774]

Welcome to the forums. That sounds pretty simple. You can setup formulas or you can use a macro to transfer the data from the master sheet to the other sheets. Question - Say you have the first vendor and you have finished typing it all in. Do you want it fill in the other spreadsheets and save a copy somewhere, print it, etc...and yes you can send it to a sheet labeled pens as well. Do you have a template spreadsheet you can upload?

[Ty73r]

Thanks Jessebranum777,
What I am trying to do is in the master sheet i type pen "B", is there a way to get the info pushed to pen B? Also, the show entries sheet can be linked to the master right? and if I sort the master, will it ruin the show entries page? Sorry for all the questions, my job depends on it.

[Jack7774]

I am trying to think of the best way to do this and I think it has to do with on event vba function which would trigger the macro each time you changed a cell in column B however I am not experienced with that yet unfortunately but everything you are requesting is possible.

Can I get someone else to step in and help Ty73r instead and I will learn in the process.

[Ty73r]

Yes, that would be wonderful! Thank you Jessebranum777.

[Jack7774]

I found youtube tutorial on how to do it. I will see what i can do now. @

http://www.youtube.com/watch?v=iYmITPeIX5k

[Jack7774]

Two issues, Issue one, if column B is the second thing you type in then the rest of the cells data won't be there when the on event macro runs. In order for this idea to work you would have to make column B the last data you enter. So instead a command button might be better however. Issue two, if i create a command button then what prevents you from pushing it multiple times and causing a duplication. Is there a column that will have unique data for each row like column I "Sweetpea Farms" will only be used once when carried over or would ear tag # be a better unique column. Also is tab "Lot B" a tab that will get updated each time you press the button or is Lot B a tab you only want one farm at a time on. Ditto question for Show Entries tab. Last question I am not sure what this is or what needs to be filled out on this. Can you upload a few lines of data on the Master Data Entry then color the boxes you want the data in and where. That would clear up these questions I have.

[Ty73r]

That helps a bit, but how would I set up the code to fill in the form on worksheet "lot b" based on typing "B" in the lot column of the main worksheet. I want the info from the main sheet to push over to the lot b page. Sorry it is all so complicated.

[Jack7774]

Check your private messages when you have time.

Which column is unique farm or ear tag?

When do you want the information filled in, after you enter one row or after you enter all the data?

Can you upload some more data and fill out the other tabs with color codes as to which boxes received new data please?

No, not complicated. I have to understand how you see it working before i can write the macro though.

[Jack7774]

In the mean time can you answer the questions above?

[Ty73r]

Jesse,

The ear tag is a unique number for the most part. They shouldn't match anyone else' tag. I can also move the "lot column" so the information is entered in already. I did not think of that and that makes a lot of sense. Also, with the lot and farm entries pages, I want it to update as I enter more information (not just one at a time). I hope those were the answers you needed. Thanks again.

[Jack7774]

To update everyone else. We exchanged emails and he sent me the workbook with the data on it and I was able to so far meet the requested solution. Let me know if something doesn't work out or you would like to add something else. Don't forget to add rep and thank anyone who might have helped. Thanks.