tally

This query is : Resolved

kumar (Querist)
Follow

04 January 2011 I want to export TB from Tally to a Excel Sheet. From excel sheet I want to know the formulas for preparing the BS,PL and Schedules. Can anybody guide me please

Ram Avtar Singh

Ram Avtar Singh (Expert)
Follow

04 January 2011 V lookup command.for that

Ram Avtar Singh

Ram Avtar Singh (Expert)
Follow

04 January 2011 =IF($A4="","",VLOOKUP($A4,Data!$A$2:$H$486,COLUMN(),0))

Upgrade to CAclubindia Pro. Subscribe Now!

kumar

kumar (Querist)
Follow

05 January 2011 Dear Mr Ram Avtar Singh,

Could you please highlight this.
If possible if you can mail me yur preparation\ sample copy of tb + schedules iwould be grateful. I am not very much thru' with excel functions and formulas except a few.

my mail id is lakshmi_772003@yahoo.co.in