Need help on this format

[Mohandas]

Need to populate the data as per the sheet3 from sheet 2.

need to macro to separate block wise data into separate sheeet

No of customers is from account no column

Collected is amount column

due is the blank cells in amount column

please heelp

 

[vletm]

Mohandas
1) Could You use same terms? ... or should someone just guess?
2) Could You also make a sample 'needed' result?

Maybe above would be so clear for You, but ... how about others?

 

[Mohandas]

Mohandas
1) Could You use same terms? ... or should someone just guess?
2) Could You also make a sample 'needed' result?
View attachment 47593
Maybe above would be so clear for You, but ... how about others?

Need for all blocks i want to data validation list box for it

 

[vletm]

Okay ...
I did three questions (marked with ? end of line )
and
... yes, none answers!
Now, You 'need' .. would like to get something else ...
If You don't know what would You need
... then there would be a challenge!

 

[Mohandas]

Okay ...
I did three questions (marked with ? end of line )
and
... yes, none answers!
Now, You 'need' .. would like to get something else ...
If You don't know what would You need
... then there would be a challenge!

I need to select the block from list in sheet 2 B1 cell then data should be populated based on the selection

 

[Mohandas]

Please help

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan