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
Hi All Respected!
i am Muhammad Shakeel Ishaq from Lahore, Pakistan working as an auditor, accounts & operations on different projects on group of a companies. I am bachelor of commerce and doing Chartered Accountancy at present.
On different projects at start i am working on financial...
thank you Sir for your reply and post.
actually i have post it, because on my topic it was appeared that "RESOLVED" and i was unable to edit that. that's why i post again without any information. Sorry for that. i will be careful next time and thank you for guiding me.
you need .pdf file also??
Hi all respected!
hope you are fine and enjoying happy life.
i have to work with a file of has 500-1000 rows. after every row i need to enter blank row. can you people guide is their any short trick VBA or Formula.
Below is the link
https://www.dropbox.com/s/f4kfmwdhtz8u6kb/Enter%20Row.xlsx
ok thank you Sir its working only after installing adobe reader, but can you help me in changing the formatting of document?? i need other type of data use in School Fee Voucher
Following Excel File need to be in PDF.. the data highlighted in Yellow color is dynamic...