Solved: Copy cells VBA Excel

[Tomo1991]

Hi All,

I want to have a button that copies cells B5, D5, F5, H5, J5, L5 from worksheet "Input" into a table in the next page starting in row 2 and adding the entries into the next row continually on worksheet "Trial", based on if there is a value in the B column. I'm pretty new to VBA and I've been playing around with some different suggestions but just can't get the hang of if it.

Can anyone help????

 

[Garf13LD]

You are talking about a list or just row 5.
What is your excel version?
Pls upload a file with sample data.