Excel sheet as input to software with "generate" click botton and new excel sheet as output

See more:

Javascript

MS-Excel

Delphi

C++11

Dear programmers,

I was looking in the internet for an idea on how to create a software or even if there is any existing regarding my issue, but it ended up on this forum Asking for it!! hope I'm in the right place.

without further ado let get to my request.

I am working in a company where two codes are very important for our job.

We are extracting codes from a "pre-made" excel sheet.

The Excel sheet has two columns: Ax which has two type of codes, the first one is like LK1234567 (first two letters which are always LK -doesn't change- followed by seven digits. The second type is 1234567. both codes increment "increase" by one for every case -scenario-

The second column has codes in the form 1234-5678-9012-3456

I am looking for a software that extracts these codes from the excel sheet then with a click it generates (extract or print) the code from Ax column with it corresponding code from Bx column with a condition that once a code generated and used it should be deleted from the excel sheet. (example to be shared below)

Example:

------------------------------------------
A column B column

LK1234567 1234-5678-9012-3456
LK1234568 1236-6548-9513-5649
LK1234569 3549-9587-7546-3158
------------------------------------------
Software should be like follow:

one click on botton and it should shows (print screen):

A: LK1234567 ----> B: 1234-5678-9012-3456

and the Excel Sheet should become;
------------------------------------------
A column B column
LK1234568 1236-6548-9513-5649
LK1234569 3549-9587-7546-3158
------------------------------------------
"Generate" botton clicked:

A: LK1234568 ----> B: 1236-6548-9513-5649

Excel sheet be like:
------------------------------------------
A column B column
LK1234569 3549-9587-7546-3158
------------------------------------------
*/*/*/*/*/*/*/*/*/**/*/*/*/*/*/*/*/*/*/*/*/
Hope you guys understood my idea.

Expecting to hear from you at the soonest pros as I need to present the idea to my manager.

What I have tried:

Honestly I did this back in the days using delphi and C++