Transfer data from multiple cells on one sheet to next available row on second sheet.

I am creating a sales log of sorts for my department at work and need a little help. My boss wants me to create a workbook where my coworkers can enter data that should be passed along to the appropriate sales rep (easy enough) but then have that data saved in a log on another sheet in said workbook on the next available row in the correct spot, preferably without having to type it a second time. I know this is possible and I have found a few different VBA formulas in Google but none of them seem like the one I need. If possible I also need a formula that will send an email of the previous days logs automatically, but only of the rows for the previous day. I am still a VBA beginner and could really use some help setting this up if at all possible. Here is my workbook I need the information in the left box "Gather Information" to be transferred to the "Log" sheet.

Reviewing your project, here is a simplistic approach to accomplish entering data to your database :

Please Login or Register  to view this content.

Attached example. You can add to this existing example to accommodate all the fields in your project.

The following will put into an email whatever you first highlight on the sheet :

Please Login or Register  to view this content.

Originally Posted by Logit

Reviewing your project, here is a simplistic approach to accomplish entering data to your database :

Please Login or Register  to view this content.

Attached example. You can add to this existing example to accommodate all the fields in your project.

This is great! is there a way to do this same thing but without the pop up window? so they would enter the information into the designated cells on sheet 1, hit the button, and then it be transferred onto sheet 3 automatically while also being deleted from the cells on sheet 1? if not that is okay this will work out just fine.

Originally Posted by Logit

The following will put into an email whatever you first highlight on the sheet :

Please Login or Register  to view this content.

Thank you so much, but is there a way to set this email up to automatically select the cells with the specific date? for example today (06-05-2025) at 07:00 the email button is clicked( or even once the application is opened) and it automatically selects the entries for 06/04/2025 and sends the email.

Originally Posted by bakerman2

This transfers data from Sheet1 to Sheet3 and clears cells at the same time.

Please Login or Register  to view this content.

Thank You so much!!! This is perfect!!! now just to figure out the email.

Originally Posted by bakerman2

Try this. On opening the workbook the code to send an email starts automatically.

Please Login or Register  to view this content.

I just realized I didn't specify what I needed for the email. This is almost exactly what I need, but it deletes the data of the previous days but i need to keep the entire log until the end of the month but send only the previous day in the email. (ex: today is 6/6/2025 email sends 6/5/2025 but leaves 6/1-6/4). sorry for the confusion, my boss tends to make things a little complicated.

Originally Posted by bakerman2

The code doesn't delete anything. It uses AdvancedFilter to copy the needed date rows to another sheet and present that in the email.

okay i deleted the copy I had downloaded from your post earlier and redownloaded it not sure why it was being weird before but now it works perfectly. Thank you so much for your help!!!

it worked in the copy you posted but when i added it to my original document it is giving me an error message of "Run-time error '1004': the extract range has a missing or invalid field name." and then it highlights

Formula:

Please Login or Register  to view this content.

what did I mess up?

Originally Posted by Coltara

it worked in the copy you posted but when i added it to my original document it is giving me an error message of "Run-time error '1004': the extract range has a missing or invalid field name." and then it highlights

Formula:

Please Login or Register  to view this content.

what did I mess up?

Nevermind I figured it out. Thank you so much for you help!!!!