How to combine multiple cells value (dynamic) in one specific cell in excel via VBA macro?
<p>I am working in a consent as account assistant. I need to generate the outstanding report every month. Below is my master data sheet where I am regularly updating client invoice, amount , date of invoice and payment status</p>
<p><a href="https://i.stack.imgur.com/2ONnL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2ONnL.png" alt="Mainsheet" /></a></p>
<p>Every month end I need to prepare outstanding report as below (sheet name Outstanding that sheet contain two column, clients and another one pending_date_amount). Manually I’m entering all pending invoice date and amount and total pending amount next cell to relevant Client name cells. This process takes more time. If anyone suggests how to simplify this process and avoid manual process, formula or VBA (I have very little bit knowledge in VBA) please help on this and my work pressure will get reduced.</p>
<p><a href="https://i.stack.imgur.com/hxe4m.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hxe4m.png" alt="Reportsheet" /></a></p>