Good Day All!!
We are looking for some help in extracting information from existing sheets based on a condition and copying it into another sheet.
We have two systems one core and one updated. There are lot of screen in the Updated system where no one has clue what has been updated.
The screen parameters could have been updated or a new screen could have been created. We are to figure out the difference between Core and Updated system and list it down for further evaluation and requirement analysis. We are to build new screens in mid-range systems so this would be the input to our requirements doc where we would be building new screens.
We have around 300 sheets where we manually copied which are mainframe copybooks. The intent is to extract the list of parameters from each copybook and map it against a mid-range database table. We are trying to get to the solution but getting stuck while moving from line to line to search and extract from each of the 300 sheets and then place it one sheet in order like below.
Below is the snapshot of the data.
The first line is the Screen name and each section has
a. Group Name
b. Parameter-L
c. Parameter-A
d. Actual Parameter
There are lot of sub components in writing macro, we are trying our best to get this done but help here would be really great as this would avoid lot of manual work.CORPORATE PARAMETER FILE ACCESS
MM-SC1-AREA.
FILLER PIC X(12).
MM-SC1-CORPORATE-GROUP.
05 MM-SC1-CORPORATE-L PIC S9(4) COMP.
05 MM-SC1-CORPORATE-A PIC X.
05 MM-SC1-CORPORATE PIC X(03).
MM-SC1-REGION-GROUP.
05 MM-SC1-REGION-L PIC S9(4) COMP.
05 MM-SC1-REGION-A PIC X.
05 MM-SC1-REGION PIC X(02).
Attached is the sample spreadsheet for your reference. Await for your support.
Regards,
Sri
Bookmarks