Display entered data from one worksheet onto another leaving out the blanks ones

Hi,

Am trying to get the entered data from one worksheet to be displayed onto another but leaving the blank ones behind. It is better to explain my problem from the attached file.

Can anyone help please ... have tried doing the search but cannot find a suitable one.

Many thanks inadvance,
Phil.

Re: Display entered data from one worksheet onto another leaving out the blanks ones

Thanks for your reply aadarsh

When my colleagues enters the qty in sheets "General", "Mid" & "Executive", I would like those data be displayed onto the "Order Form". Those rows without qty are omitted from the display. Per example in previous attachment.

Thanks once again.
Phil.

Re: Display entered data from one worksheet onto another leaving out the blanks ones

Hi Aadarsh,

Thanks for the assist. Your proposed revision was not what I was planning to do but it certainly would suffice.

Many thanks for your efforts.

Kind regards,
Phil.