@VaibhavJ (Believe!! Live your dreams!) (33511 Points)
28 June 2014Hi
After exporting file from tally in to excel all Dr /Cr values are shown as positive number only, so when we try to add or subtract number we get undesired result.
I have crreaed macro taht will convert Cr value as negative keeping format intact.
Do post if you have any query.
Thnaks!!
Nilay Shah
(AM- Finance)
(41 Points)
Replied 06 July 2014
Sir, Attached is the file.
Please suggest me some formula to separate the number 1087 Dr as shown in Colum E. By Pressing F2, i could not see the same text format as showing in the Column
Kindly help me out. Thanks
@VaibhavJ
(Believe!! Live your dreams!)
(33511 Points)
Replied 07 July 2014
hi
Runmacro given by me, after that change number format of all cell in col. D or col. E. All Dr. values will get changed to positive & vice versa.
Thanks
Gopalkrishna Hegde ,CA,DISA
(employment)
(275 Points)
Replied 26 March 2015
Good Macro Vaibhav, can we copy this macro in our excel work book or do we need to used it int your sheet only
Gopalkrishna Hegde ,CA,DISA
(employment)
(275 Points)
Replied 26 March 2015
whether this formulae can be used for 100 of rows
@VaibhavJ
(Believe!! Live your dreams!)
(33511 Points)
Replied 26 March 2015
| Originally posted by : Gopalkrishna Hegde ,CA,DISA | ||
 |
whether this formulae can be used for 100 of rows |  |
Hi
You can run on any no. of rows, you can copy your data in this sheet & Run macro on it..
Do let me know if you need any help.
Thanks
Gopalkrishna Hegde ,CA,DISA
(employment)
(275 Points)
Replied 04 August 2015
Thanks You, Can please help me to convert debit to minus in excel after downloading from tally by any of the macros
@VaibhavJ
(Believe!! Live your dreams!)
(33511 Points)
Replied 07 August 2015
@ gopalkrishna
Check attachment..
Best!
VaibhavJ
kumaravel d
(senior manager)
(21 Points)
Replied 27 August 2015
you may use this link as well https://www.ashishmathur.com/extract-text-from-a-custom-formatted-cell/
@VaibhavJ
(Believe!! Live your dreams!)
(33511 Points)
Replied 27 August 2015
| Originally posted by : kumaravel d | ||
|
you may use this link as well https://www.ashishmathur.com/extract-text-from-a-custom-formatted-cell/ |
|
It has limitattion since it works on particular column only..
Sayed Nazar Abbas
(Student CA IPC / IPCC)
(40 Points)
Replied 05 April 2016
pls help me to replace dr & cr sign with plus & minusin op bal & closing bal.
as I'm not able to do with macro which you provided.
pfa excel sheet
Manoj Kumar
(Consultant)
(34 Points)
Replied 20 August 2016
From Manoj
Convert "Dr" or "Cr" contained data into CSV format (under excel save as option) and data can be modified with excel options.
Manoj Kumar
(Consultant)
(34 Points)
Replied 20 August 2016
Convert "Dr" or "Cr" format excel file into CSV form under save as option of excel, then you can modify exce data based on user requirments.
Manoj Kumar
(Consultant)
(34 Points)
Replied 20 August 2016
Hi,
No need to write any macro, use excel CSV format to remove DR and CR
Regards
Manoj
Sayed Nazar Abbas
(Student CA IPC / IPCC)
(40 Points)
Replied 05 September 2016
Thanks
That is much easier and time saving
CAclubindia
