BILL-CUST WISE Outstanding Data Required

[yogendran123]

Dear All,

I need your help

My client outstanding detail follow as

| Cust code| cust name | Inv no | Inv date | Inv amt | |O/S days | Order locn |

if I enter my cust code in the top sheet all the data’s are related to that cust code to be fetch automatically so that I can copied those details.

Why i am need this i have a huge client outstanding data i cant filter every time to search a particular outstanding detail.


is there any possible to get this using a Vba


TIA

 

[rahulshewale1]

HI @yogendran123,

Please upload sample File with desire output then we will help better.

Regard
Rahul Shewale

 

[yogendran123]

Dear Rahul,

As requested,please find attached the excel sheet

 

[Marc L]

URGENT removed from your thread title accordingly with this forum rules :​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

 

[yogendran123]

Sorry

 

[rahulshewale1]

Hi @yogendran123 ,

See if it is ok ?


Regard
Rahul Shewale