JAMIR
Member
Dear Sir,
Please see the file at https://www.dropbox.com/s/vxwwzxysqznjv8z/RIDA.xlsm?dl=0.
My data now 13000+ row and 100/150 row increased everyday. The above code is getting very long time to give balance stock of specific code no. enter. I have make pivot table for receipt control regiter & issue control register. For getting current stock of Unique Code No. i use following formula in Stock Available Colomn.
[=VLOOKUP(IssueControlRegister!E12537,Sheet1!$A$4:$B$2000,2,0)-VLOOKUP(IssueControlRegister!E12537,Sheet1!$C$4:$D$2000,2,0)]
Can it is speedy through vba code for getting current stock in issue control register Stock Available colomn after + - of specific code no.
Remember there is mass of data for handling this calculation. And all data in table so when i insert new row its taking so time for giving new row. I just want to speedup calculation
Please do needful
Regards,
Zameer
Please see the file at https://www.dropbox.com/s/vxwwzxysqznjv8z/RIDA.xlsm?dl=0.
My data now 13000+ row and 100/150 row increased everyday. The above code is getting very long time to give balance stock of specific code no. enter. I have make pivot table for receipt control regiter & issue control register. For getting current stock of Unique Code No. i use following formula in Stock Available Colomn.
[=VLOOKUP(IssueControlRegister!E12537,Sheet1!$A$4:$B$2000,2,0)-VLOOKUP(IssueControlRegister!E12537,Sheet1!$C$4:$D$2000,2,0)]
Can it is speedy through vba code for getting current stock in issue control register Stock Available colomn after + - of specific code no.
Remember there is mass of data for handling this calculation. And all data in table so when i insert new row its taking so time for giving new row. I just want to speedup calculation
Please do needful
Regards,
Zameer