VBA to copy data and formatting but also have that its only for certain rows

[Ajax40]

Hi
Im new to the Board. I have a spreadsheet that contains alot of rows of data. But i Only want certain rows to go to the new sheet with the data and formatting included
Thanks!

 

[eiloken]

what kind of data and formatting you want to get?

 

[Ajax40]

Hi
Its a mix of text and numbers based on date. I have attached an image of example. I want to say move rows 2 and 4 with formatting into sheet 2 from sheet 1. The sheet I have has multiple rows but I only want the data and formatting from select rows. Also the ability for this to auto update would be great rather than cutting and pasting everything over

 

[eiloken]

so that you want is copy all the rows you selected (with value and formatting) to another sheet?