Macro for cell entry text

[excelhelpseeker]

Hi Champs,

I have a report with

Date -------------- column A
Description----------- column B
Amount-----------------column C


Description has two categories "trabsfer from" and "transfer to" for a partcular date.

So for each day there may be n number of "trabsfer from" and "transfer to".


I need a macro to output mentioned in output sheet like

if input description has 4 entry in "transfer from", then 4 entry of "transfer to" should be added

and same for input description "transfer to". pls refer the output for clear understanding.


Amouunt in input has to be split up as Dr and Cr based on entry. Thanks for the help in advance.

[davesexcel]

set the column number when you loop through the rows.

Please Login or Register  to view this content.

[excelhelpseeker]

Hi davesexcel ... thanks for the coode.

But what i need is for "transfer from" entry in input sheet, corresponding entry has to be added in ooutput. (eg, see input sheet has

4 entry for "transfer from" and 6 entry for "transfer to"

so the output has to be 4 entry for "transfer from" and "transfer to"

and 6 entry for "transfer to" and "transfer from"

[davesexcel]

This should do it.

Please Login or Register  to view this content.

[excelhelpseeker]

this macro does not do any thing. can u pls help

[davesexcel]

this macro does not do any thing. can u pls help

I know, because I would give you a macro that doesn't do anything.