Dear Friends,
I am trying to create Macro Program for my regular activity for Data Extracted from Tally.
I am having cells filled with Amount as number and custom Formatted as ""0.00" Cr" and ""0.00" Dr"
So Cell display will be D5 = 100 (Display as "100 Cr") and D6 = 150 (Display as "150 Dr") like "N" number of rows
I want below result
If D5: "100 Cr" then I need E5 = Cr
If D6 = "150 Dr" then I need E6 = Dr
Example Photo in below link
https://drive.google.com/file/d/0B3NIO-ZYSEYjanp6VUFMOFZrWHc/view?usp=sharing
I am trying to create Macro Program for my regular activity for Data Extracted from Tally.
I am having cells filled with Amount as number and custom Formatted as ""0.00" Cr" and ""0.00" Dr"
So Cell display will be D5 = 100 (Display as "100 Cr") and D6 = 150 (Display as "150 Dr") like "N" number of rows
I want below result
If D5: "100 Cr" then I need E5 = Cr
If D6 = "150 Dr" then I need E6 = Dr
Example Photo in below link
https://drive.google.com/file/d/0B3NIO-ZYSEYjanp6VUFMOFZrWHc/view?usp=sharing
Last edited: