Transfering issue

Good afternoon all,

Having a bit of a problem getting code worked out to transfer whole rows of information upon selections of specific information.
I also have a descriptions in the actual file itself. The red area are the problem childs, and the yellow is wheer the abreviation goes for the specific devise. If a abravitation is input of only specific devices it than takes the whole row of info and transfers it onto the other sheet in the workbook. I think that makes sense.

Any help would be more than appreciated.

Thank you very much for any direction.

AnthonyS

forum.ozgrid.com/index.php?attachment/54331/

Re: Transfering issue

Started to write a long if statement but had to stop realized that the ending IF statement wouldnt transfer properly, and a vlookup isnt going to accomplish the needing to go to the next line on the following sheets. Still stumped

Re: Transfering issue

NO luck on this one yet still ending up with a error, its compiling data in same place rather than using new line, that hasnt been copied to yet.

Re: Transfering issue

That looks like it does the job I had to keep it the same since that is the way the fire marshals need to see it in a set order, they are pains. But anyways I just swicthed the look up column but it works perfect I also have a macro automatically abbreviating as well so as they put in the info which they primarily use copy and paste from another program that grabs all the info off of the system itself causing less errors so when they pop all the info in it changes those full desriptions that come out of the panel abbreviate them using again the above shown legend then transfer dpending on the selection. ITS PERFECT. Exactly what I was trying to accomplish, THANK YOU VERY MUCH. That was the main part that was stumping me. Again I appreciate the help greatly Mumps.

Re: Transfering issue

Ok the only problem I am having now is implementing it in the complete book version of the forms. And I cant get it to transfer the macro doesnt come back with any errors its just the info isnt showing up on the EP3 page as designed. The total workbook has 15 sheets to it, The device tested page is the 3rd of 15 and the ep3 sheet is the 13th page of 15. Im not sure that should matter as I see it referencing a specific page name not number of the page, but I could be wrong.

Re: Transfering issue

Its not letting me attach the whole book its over 250 kb which i guess is too big for this site???