Compare & copy the records from 1 sheet to another sheet in the same workbook

singhal_amit

New Member
Joined
Feb 11, 2019
Messages
3
Hello Friends,

Need the expert guidance from you. I am new to the VBA world.
My problem statement is as follows:

Problem Statement: There are 4 sheets in my workbook - Pending Old SP, Pending New SP, Onboarding Dump - Old SP & Onboarding Dump - New SP. Below is the manual process that i am currently doing:

1) I match the last record from Pending Old SP sheet in Onboarding Dump - Old SP & copy all the records after the last matched record from Onboarding Dump - Old SP to Pending Old SP. then send email to all the newly copied records & copy these records into another tab "Sent - All" & delete from Pending Old SP sheet.

2) Same process if followed with Pending New SP & Onboarding Dump - New SP tabs.

So in the end Pending tabs will have no records & all the records will be transfered to Sent - All tab once the email has been sent.

Please help me in this with your guidance & expert coding.

Thanks a ton in advance!!
Amit Singhal
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,619
Office Version
  1. 2007
Platform
  1. Windows
You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

Just 2 sheets: "Pending Old SP sheet" and "Onboarding Dump - Old SP". And explain what you compare and what copies.

It also explains how you send the mail, with outlook, send the sheet "Sent - All" as a file?
 

Watch MrExcel Video

Forum statistics

Threads
1,129,314
Messages
5,635,506
Members
416,861
Latest member
Breadnjam18

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top