Pull data from sheet1 to sheet2 with condition

[suusabox]

Hello,

So, i have question about pulling some data from sheet 1 to sheet 2.

In sheet1 i have destination and how far it is, on sheet2 i have empty table and cell named Total:

Now, what i would like excel to do for me is: when i write some random number in the Total: cell(Sheet 2) ie 234, it will pull data from sheet 1 and fill table on sheet 2 in random order, but total km will be 234.
So if i write there 432 it will bring more rows to match sum of 432km

Sheet 1 will have more destinations.


Can someone point in right direction here?



Sheet1(where the data is stored):

example2.xlsx
	A	B	C
3	from-to	description	distance in km
4	start-destination 1- start	client meet	23
5	start-destination 2- start	sale	45
6	start-destination 3- start	client meet	2
7	start-destination 5- start	picking up tools	3
8	start-destination 6- start	sale	1
9	start-destination 7- start	sale	10
10	start-destination 8- start	client meet	8
Leht1

Sheet2(whre output is stored, i filled it manually atm):

example2.xlsx
	A	B	C
4	from-to	description	distance in km
5	start-destination 8- start	client meet	8
6	start-destination 2- start	sale	45
7	start-destination 1- start	client meet	23
8	start-destination 7- start	sale	10
9	start-destination 3- start	client meet	2
10	start-destination 2- start	sale	45
11	start-destination 6- start	sale	1
12	start-destination 2- start	sale	45
13	start-destination 6- start	sale	1
14	start-destination 1- start	client meet	23
15	start-destination 7- start	sale	10
16	start-destination 8- start	client meet	8
17	start-destination 5- start	picking up tools	3
18	start-destination 7- start	sale	10
19
20
21		Total:	234
Leht2

Thank you in advance.

 

[SanjayGMusafir]

with Excel 365 it can be done with a twist

• Add running total column for distance on sheet 1
• Then on sheet 2 filter results based on the total you have written - Filter being Running total <= Distance Total
• Also since filter will give a spill range prefer putting total at top or some distant cell to avoid spill error.

Hope it helps you in some way