New to Excel; Need help moving data from one sheet to another

[LeesieInDurham]

I have searched for information specific to my needs; however, I haven't found anything that does exactly what I am looking to do.

I have a workbook with 2 active sheets. The front sheet is CURRENT Patient Tracking. The next sheet is Patient Tracking RECORDS.

I want data that is entered into the CURRENT sheet to automatically be copied to the RECORD sheet - THEN I also want to be able to delete the data from the CURRENT sheet, have it stay on the RECORD sheet, and then be able to re-enter NEW DATA on the CURRENT sheet (where text has been deleted) and have this NEW DATA also copy and stay on the RECORD sheet.

I am new to Excel, and I am not sure if this is even possible. I hope it is okay to post Newbie questions in this forum. If not, I do apologize.

Lisa

 

[Joe4]

Welcome to the Board!

That certainly can be done with VBA. If you give us the specific details, we can help you come you with that code.