Hello Everyone.
I have a generic invoice sheet I use to display relevant info to my client. On a separate worksheet, I have created a log to record the information from each invoice, and its roughly 100 rows. Both the invoice worksheet and the log worksheet share information with eachother.
Ideally, I'd love to capture the info (entered in the invoice sheet) and recorded in the record log worksheet. Then, once I go back to input new data into the invoice worksheet, the record log sheet, after moving to the next row, would correctly capture the new invoice data, and so on.
I need a way for the worksheets to realize that data entry has been finalized, and will then move to the next row.
Sorry for the lack of clarity, terminology, and example. I don't see a way to link or attach my excel file, so if anyone knows how I can post this, that would probably help.
Thanks in advance.
I have a generic invoice sheet I use to display relevant info to my client. On a separate worksheet, I have created a log to record the information from each invoice, and its roughly 100 rows. Both the invoice worksheet and the log worksheet share information with eachother.
Ideally, I'd love to capture the info (entered in the invoice sheet) and recorded in the record log worksheet. Then, once I go back to input new data into the invoice worksheet, the record log sheet, after moving to the next row, would correctly capture the new invoice data, and so on.
I need a way for the worksheets to realize that data entry has been finalized, and will then move to the next row.
Sorry for the lack of clarity, terminology, and example. I don't see a way to link or attach my excel file, so if anyone knows how I can post this, that would probably help.
Thanks in advance.