SamPaulRoger
New Member
- Joined
- Jul 28, 2018
- Messages
- 12
Hi,
I am looking to have a spreadsheet that is updated from a database, and then someone manually types in what has been completed, I would like to have a macro where it would compare the values between two cells then output the what is missing. For example, in cell A2 I have "ABCD" then in B2 I have "AB" it would look at the specific Alpha characters, and output "CD" in C2. Also not sure if it matters or not, however, I will have to do this for approximately 20,000 rows...
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Auto Populated[/TD]
[TD="align: center"]Manually Populated[/TD]
[TD="align: center"]Script Output[/TD]
[/TR]
[TR]
[TD]Requirements[/TD]
[TD]Completed[/TD]
[TD]Remaining[/TD]
[/TR]
[TR]
[TD]ABCD[/TD]
[TD]AB[/TD]
[TD]CD[/TD]
[/TR]
[TR]
[TD]ABCDE[/TD]
[TD]ABCDE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]A[/TD]
[TD]BC[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]AC[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]ABCD[/TD]
[TD][/TD]
[TD]ABCD[/TD]
[/TR]
</tbody>[/TABLE]
I am looking to have a spreadsheet that is updated from a database, and then someone manually types in what has been completed, I would like to have a macro where it would compare the values between two cells then output the what is missing. For example, in cell A2 I have "ABCD" then in B2 I have "AB" it would look at the specific Alpha characters, and output "CD" in C2. Also not sure if it matters or not, however, I will have to do this for approximately 20,000 rows...
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Auto Populated[/TD]
[TD="align: center"]Manually Populated[/TD]
[TD="align: center"]Script Output[/TD]
[/TR]
[TR]
[TD]Requirements[/TD]
[TD]Completed[/TD]
[TD]Remaining[/TD]
[/TR]
[TR]
[TD]ABCD[/TD]
[TD]AB[/TD]
[TD]CD[/TD]
[/TR]
[TR]
[TD]ABCDE[/TD]
[TD]ABCDE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]A[/TD]
[TD]BC[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]AC[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]ABCD[/TD]
[TD][/TD]
[TD]ABCD[/TD]
[/TR]
</tbody>[/TABLE]