Hello , I would appreciate any help regarding the following question:
I have many registers for incoming correspondences (about 8 registers in different location on my PC and server).
all these files have same table structure & design from column A to column K, and start from column L the information changed upon type of register.
The attached 3 files are sample for incoming letters, MOM and transmittal.
I wish to pull out the data from these registers, Only which match word “open “ in column K.
The other excel file “Pending Correspondence” is the consolidation file for the “open” data as following:
1. In the sheet named “input”: all variable data, I will update manually all information in the column A, B and column C as mentioned in the log.
2. regarding sheet named “Overall Pending” :
a. In the column A, I need to have name of the file that the data was imported from.
b. In need to have all imported data from other registers to be paste in column B up to column L.
I have made manual sample for result that I am expecting automatically and hope it will give you better idea for what I need.
Thanks in advance for your efforts.