First off all, I'm going to apologize. I know this question gets asked a ton, but I just can't seem to find a particular answer that is what I'm looking for.
So, I have two sheets with identical column headers. I would like both sheets to be formatted as basic tables.
The data being entered will be dates. I would like to have a macro so that when I enter a date into the last column available on sheet 1, the entire row will copy into the next available row on sheet 2, adhering to the table format, while being deleted from Sheet 1. I need sheet 2 to continuously update and not delete any data.
I would prefer triggering the macro by entering a date rather than entering a word like "Completed", but if this can't be done, I can use a trigger word. Does anybody have some decent VBA coding I could use to achieve this?
Thanks in advance!
So, I have two sheets with identical column headers. I would like both sheets to be formatted as basic tables.
The data being entered will be dates. I would like to have a macro so that when I enter a date into the last column available on sheet 1, the entire row will copy into the next available row on sheet 2, adhering to the table format, while being deleted from Sheet 1. I need sheet 2 to continuously update and not delete any data.
I would prefer triggering the macro by entering a date rather than entering a word like "Completed", but if this can't be done, I can use a trigger word. Does anybody have some decent VBA coding I could use to achieve this?
Thanks in advance!