Thats the perfect result I expect !!! Am not sure despite your advice I tried removing the blank records in my input file , I am still getting the same result . Thats my final input final covering all the needed scenarios .
I will prepare the worksheets covering all the scenarios and share it with you at the earliest. Your code is undoubtedly rectified my issues for most of the countries . Except there are few countries where the gl acocunt number formats are different .
Dim oCn As Object, P$, F$, V, C%, R&...
There is nothing wrong with the excel sheets, I have given the requirements and also the code which is working you gave is perfectly working . No qualms . The data i receive is very dynamic . I guess it is highly unlikely for anybody to predict the possible scenarios on which you can receive the...
Thats it . Wow finally my expected result :) :) no words Marc , you are great. Sweet Thanks . Self pat on my back for sharing the correct requirements !!!
the column titled Gl accc is the gl account ( name would not be gl account same as i mentioned ). the curr ,currency refers to the currencies of the country
My strategy from the input files
a) pick the month , country_code ,currency , gl account , the revenue/non funded income from payment file
b) compare the corresponding country code , (currency/Curr/Curr_details) , gl account , revenue /non funded income in the core banking file
c) the look up...
Hi Marc , the data given in the earlier attachment stands good , there are umpteen columns which are not utilized while making the comparison . The total columns in each file are 20 . The file sent in the previous attachment suits the best possible columns that would be taken . you can give the...
The maximum number of columns in each of the files could range from A1 to AS column . Since I am in a position not to upload the orginal file due to security reasons , I had sent the payment ,Corebanking files with mocked up columns , while the column names , column positions of these attributes...
Sorry for the inconvenience . Most of the cases the header or the column names were fixed and hence your earlier code was perfectly working . As I worked with more countries I realized , the column names were changing and also the positions . My sincere apologies for my inability to list the...
The country files for the systems such as payment , corebaniing are maintained separately in the folder and the above codes pick the first two digit character and matches the contents in the two system . can we have two
Hi , i am having difficulty in maintaining country wise sheet .Is it...
Hi , Have macro code in place "summary.xlsb" that creates a report by fetching data from various files inside the folder and producing a report . User can click the summary button in the summary sheet to produce the results. The number of rows is not fixed in the summary and depends on the input...
Hi , Have macro code in place "summary.xlsb" that creates a report by fetching data from various files inside the folder and producing a report . User can click the summary button in the summary sheet to produce the results. The number of rows is not fixed in the summary and depends on the...
Thanks Marc. Would like to place a pivot button to create a pivot table for the dynamic range of cells next to the summary button you mentioned . Is it possible ?
Hi Marc , am unable to rechange the system names in the code and run the macro in some other folder attaching the details for better clarity .
It will be great if i can cusomize the code to change the systems names and run the macro in someother folder . e..g collections etc .
Can you please...
Yes to make it simple you can consider the folder to contain files related to payment and corebanking across various markets .
I can replicate the code to compare against corebanking system with other systems such as trade etc at my end by segreagting folder wise . This will minimize the...
Yes , the files can be differentiated based on their names for example , core banking files would be under the names SG Corebanking , similarly payment would be under SG Payment . however , the names are input by various teams . the revceiver out of his experience knows that the files pertain...
Hi Mark , Thanks for the quick revert . Yes the country files contain only 2 character followed by a space . The name can end with any combinations not just corebanking , Payment , coule be any generic string . For example names could be SG Retaildata , SG <Space> any string ( generic codes max...
Hi guess, I have posted my query earlier in the wrong window . Reposting the same under macros.
I have folder that contains 100 excel workbooks - countries and systems . In each of these workbook I need to retrieve few columns and make a key in the master table . retrieve the chosen columns...