No Experience – Need a specific copy and paste macro

Hi,

I don’t really have any experience in VBA script but I was told there might be a way to make this easier. I was wondering if I could get some help for a script. I want to copy cells from column B through G as long as there’s a value in corresponding column A and list them in a new page in a single column. If there are duplicates, it doesn’t copy. Also, after all the items from B through G are listed in a single column, it needs to copy the corresponding length from its row next to it. Sorry it’s a bit confusing. I’ve attached the excel sheet with a result tab for what I want, please help if possible. Thank you in advance

Please Login or Register  to view this content.

Sorry for the confusion. The Result tab is meant as a reference only on what it's suppose to look like in the end. What I need is a macro to specifically copy and paste certain things and create a new sheet and display the results. I'm not even sure if it's possible.

rcm,

The script works when I added a new tab (Result). But for some reason it's missing values. The one it's missing are FF02 and FF01

Sorry, some of the keys were contained in other...

Please Login or Register  to view this content.

thank you so much for your help it worked perfectly! I'm sorry to ask another thing from you, but is there anyway you can make it so it creates the new sheet "result" instead of having to create it manually? thank you again for your help....I didn't know it was possible lol

Thank you SOOOOOOO much for your help rcm!!!!! Everything works great!

you are most welcome !!! just mark it as solved