Few Details required of Individual's Name with Range Address

SamDsouza

Board Regular
Joined
Apr 16, 2016
Messages
205
Hi I would like to get the range Address of Each Individual Name against payment made to them and received from them and few other details from each individual name.
All the names are in column B if you see below

For eg if I type Kate in txtName.Text to get the range Address ie A15:D23 in txtRngAdd.Text
And txtRngFrom.Text = A15 and txtRngTo.Text = D23

2nd thing to get Kate’s Total Payment made in txtPymnt.Text = 2100 and Total Payment Received
txtPymtRcd.Text = 3800 and txtBalance.Text = 1700
and in Steve’s Case as the Balance is equal so there is no row of balance
The following is the structure of worksheet

ABCD
1Individual Name:Jerry
2Transaction DateDescriptionPayments MadePayments Received
302-04-2015vchr no : 2600
403-04-2015vchr no : 3200
504-04-2015Agst vchr no : 2600
6Total800600
7Balance :200
8
9Individual Name:Mike
10Transaction DateDescriptionPayments MadePayments Received
1102-04-2015vchr no : 41750
1203-04-2015Agst vchr no : 4350
13Total1750350
14Balance :1400
15Individual Name:Kate
16Transaction DateDescriptionPayments MadePayments Received
1701-04-2015vchr no : 51500
1805-04-2015vchr no : 6600
1906-04-2015Agst vchr no : 122000
2009-04-2015Agst vchr no : 51500
2110-04-2015Agst vchr no : 2300
22Total21003800
23Balance :1700
24
25Individual Name:Steve
26Transaction DateDescriptionPayments MadePayments Received
2702-04-2015vchr no : 41235
2803-04-2015Agst vchr no : 41235
29Total12351235

<tbody>
</tbody>


Your help will be appreciated
Thanks
SamD
 
Last edited:

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
You're welcome & thanks for the feedback
 
Upvote 0
Will it be ok to post just a last question related on this thread or should i post a new thread all together ?
 
Upvote 0
Probably best to start a new thread.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top