Search results

Thanks for the reply. But I am not that much familiar VBA Code. I can copy & paste and use the macro. Data range end cell is not known. It will vary in source files. Can we have a option to pick list of files which are to be merged?

Hi all, Background: After implementation of GST in India, Buyers of Goods / Services have got a serious issue in form of Reconciliation of GST Input. Every month we (Buyers) have to download GSTR-2A files in JSON format and convert into Excel. GSTR-2A is nothing but GSTR-1 of Suppliers who...

I am not that much familiar with VBA Code hence couldn't spend more time to test the code. I think I have to put all code under one SUB.

I need code for deleting blank rows, formatting the columns and of course deleting N to P columns...

Hope everyone in Holi and weekend holidays mood. Could anyone have look about this requirement?

I have attached two excel files 1) FormatAAR 2)FormatAAR - New 1st file is the report (Account Analysis Report) we generate from Oracle ERP and it contains a sheet namely"FNDWRR". 2nd file is the formatted form of 1st file which we do manually every time we generate from Oracle ERP as per the...

Is this final output? In pivot, total BG amount is considered instead of BG commission. We did manual exercise to identify financial years. How BG commission automatically be calculated financial year wise.

1) 0.5% means 0.005 2) In India financial year means 01st April to 31st March. So if a BG taken in 2009 and it's validity is till 2014 then BG commission to be found for every financial year starting from 2009-10. I am able to calculate number of days since original BG taken and till date BG...

First of all thanks for your time. But I want distribution of BG commission financial year wise. BG commission rate is 0.5% is correct.

please find attached the most possible crystal clear information.

When a new BG is taken, we take it for limited period. In this case, the BG was taken till its validity expires on 30-Apr-13. After it's expiry on 30-Apr-13 it is again extended till 31-Jan-2017. In the sample file, we had to insert rows to calculate financial year wise BG commission.

Header of Status column can be named as "Status". Depending on the string in this column, BG commission shall be calculated and year wise BG commission shall be published. Hope I am clear.

Yes. When a fresh BG is taken from Bank it's status would be "Issue". If it is extended after it's original Validity then against that BG number status will be changed to "Extension"

The attached file is having live data of BG Commission. BG Commission rate, BG amount is given. If the status of BG is "Issue" then BG Commission to be calculated for those number of days i.e. from BG date to till date of Extension (AD column in attached file). If the status of BG...

Dear all, Back from Pongal holidays... but disappointed to see my problem was not yet solved. Please look into this and help...

Hi Mr. Narayan, Did you check the latest file uploaded after filled up the data manually? Regards, Surya

Filled up the data in output range.

Thanks Mr. Narayan for your time. yes I have uploaded a sample file because the entire file contains similar data. I will upload full file now. Your Point 1: Correct Point 2, 3 & 4: Please refer Sheet 1 in attached file

The detail requirement is mentioned in the uploaded file. In gist, in a range of ageing columns of a vendor, any positive figure shall be adjusted with the negative figures depending on criteria. Output is required in another sheet in same format as in source data. At present I have been...

Thank you....working fine....

Hi Thanks for your time and reply... But I am getting #REF in all blank cells.. Surya

Hi all, Now the question is I have Project codes in Column A. There are blank cells between project codes. How to fill those blank cells... To understand better please refer attached excel file. Thanks in advance Surya

Hi Asheesh, We can ignore Item Description, UOM & Rate Columns... Regards, Surya

Dear Xiq, Thank you very much for the info. Sorry for not mentioning anything about "Item-Description" and "Rate" in my question. We have to simply ignore those two columns. As I am completely novice in Index function it took a while to understand, but its working fine. Don't mind I have to...