VB Code to copy data

Hello:

Please refer to attached file.
I will have data as shown in "Report" Sheet.
I need VB Code to do the following.
1. Create another sheet called "FINAL"
2. Copy Column C data of "Report" sheet into Column A of "FINAL" sheet.
3. Copy Column A data of "Report" sheet into Column B of "FINAL" sheet.
4. Copy Column D data of "Report" sheet into Column C of "FINAL" sheet.
5. Copy Column E data of "Report" sheet into Column E of "FINAL" sheet.
6. Add text "Payroll:Gross" to column D of "FINAL" if text in corresponding cell on column F "Report"
Sheet text is Payroll Check.
Add text "Payroll:Taxes" to column D of "FINAL" if text in corresponding cell on column F "Report"
Sheet text is Deposit EFTPS.


Let me know if you have any questions.
Thanks.
RM

Hi Skywriter:

Works great...Thanks a lot
RM

Hi Skywriter:

I forgot to ask one more favor.
I will now have a list of Payee in "FINAL" Sheet starting at cell H2
Now i need to see if any names in column C of "FINAL" sheet has names which is listed in Column H.
If it finds then would like to change corresponding text in column D to text in I.
I have attached the sheet.
Let me know if any questions.
Thanks
RM

Hi Skywriter:

Works great.

Thanks a lot

Riz