Range of data to be copied in another sheet

Hi,

I have this code which helps me in saving data for two cells in different sheet.

Please Login or Register  to view this content.

With this code i want two things

1. Whenever i press F2 and enter on column C2 it shows the value in sheet 2 not sure how to make it working continuously without doing it.
2. Also save the data for the range F2:F7 and T2:U7 in different sheet same as where C2 and C3 getting saved starting from column C (Like F2 data goes to C, F3 data goes to D so on).

Thanks in Advance.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

Also, you need to use code tags when posting code please.

You posted this same question on another forum. That is the link you need to provide.