Create a list from existing list ignoring zero values

[awanak]

i want to creat a list from existing list ignoring zero values

For Example [TABLE="width: 500"]
<tbody>[TR]
[TD]Original List[/TD]
[TD]List to be created[/TD]
[/TR]
[TR]
[TD]Aslam[/TD]
[TD]Aslam[/TD]
[/TR]
[TR]
[TD]Akram[/TD]
[TD]Akram[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]Mohsin[/TD]
[/TR]
[TR]
[TD]Mohsin[/TD]
[TD]Waseem[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Waseem[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Re: Create a list on another from existing list on sheet 1 ignoring zero values

Doesn't this part adapt the range's length ?

It does, but
- that code changes the original data, which was not requested
- it doesn't put anything on Sheet2 in the first place, and even if it did ..
- when the list on Sheet1 changes, nothing will change on Sheet2 unless the existing data on that sheet is cleared and the code is run again.
Perhaps I am wrong but post 3 seemed to me to imply an automatic update of the list was required.

Whilst all of those things could be addressed with adaptations of that code, I suspect that if the OP was capable of all those adaptations I doubt they would be asking this question in the first place.
Perhaps I am wrong with that too.

 

[Fluff]

Re: Create a list on another from existing list on sheet 1 ignoring zero values

@awanak
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread (rule 12 here: Forum Rules).
I have merged both threads.