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????
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????