Hi Suresh!
i would like to suggest you to use Pivot in Back Up, while in new sheet you should manage profit and loss, it is also automatic as all cells are linked with Pivot table but are more dynamic, can change according to your desire.
Further if you share you work book, not exact data...
Deb Bro!
i want one thing more when i enter the code and my required data appears in required columns than formula should not showed their? is their any why for this.
But if someone can guide that in VBA when i just enter code in column A all actions performs automatically for vlookup..it means not to run VBA for that?
Hi all respected!
thank you for reading the post.
i hope you are all fine. :)
i am not well know about VBA code. i need your help for this.
below is the link of my file. Sheet "MES" column A2 (and so on) is lookup value.
table array is on sheet "COA". i have entered vlook up from Column...
Hi Ankit!
Welcome to forum
Please upload sample book so we can give u solution after better understanding
below is the method of posting sample workbook in forum
http://chandoo.org/forums/topic/posting-a-sample-workbook