VB Code to copy certain data

Hello:

Please refer to attached file.
I have data in sheet1 as shown.
I need VB Code to copy certain data from sheet1 to sheet2 at cell A7.
Start Row is in cell T1 of sheet1 and end row is in cell T2 of sheet2.
Now need to copy data from sheet1 Column A thru M and Column O thru P to sheet2 in column A thru M and Column O and P starting at Cell A7 of Sheet2.

Let me know if you have any questions.
Thanks.

Riz

Maybe:

Please Login or Register  to view this content.

Hi John :

Works super cool.
One more favor.
Need Cell N1 in Sheet2 to be the last row date in Column A of Sheet2.

Please let me know if you have any questions.
Thanks.

Riz

Hi xladept:

Thanks a lot...will work for me for sure.

Riz

Hi xladept:

Your code works great.
I need help to modify the code as below:
First i do not want the highlighted cell in Sheet2, need just in Sheet1 where the data is copied FROM.
Second : i want to automate the Start Row# and End Row# in cell T1 and T2 of Sheet1 as follows.
Please see attached file.
First time i use, i have highted A3 as start and A13 as end row.
So code need to use as start Row = 3 and End row as 13
Now you run the macro.
Your code will highlight cell A3 and A13.
Next time i run, Start Row will be A14 (last highlighted row + 1)
and end row will be the last entered data in column A which in this sample will be 28.

I hope this is clear and looking forward for your help.
Please let me know if you have any questions.
Thanks.

Riz

Hi xladept:

Superbbbbbbbbbbbbbbbb..
Thanks a lot, i feel it is accomplished to my need.
I will let you know if any further help is needed with this thread.
Once again thanks

Riz