Data transfer from one cell to another sheet

[ridgeroo85]

Hello,
Not sure if anyone can help, I am looking at consolidating information, I am creating report so in cells A1-A30 would be a list of names, in cells B1-B30 would be a number, what I need to do is transfer the name from cell A onto another sheet depending on the number depends where the name needs to be copied to ie: if cell B1 was a value of 20 or less then cell A1 would need to go to sheet 2 cell A5. But if it was between a value of 20&29 it would need to go to sheet 2 B5 and if the value was 30 and above then it would need to go to C5. What is the easiest way to do this please?

 

[My Aswer Is This]

Not sure I understand this logic:
You said "A1 would need to go to sheet 2 cell A5"

How about where would A2 Go?
Would it go to sheet 2 A6?

 

[kevin9999]

I note you have 365. You could do it this way:

Book1
	A	B
1	Adam	37
2	Bernice	6
3	Charlie	32
4	Deborah	9
5	Eric	2
6	Frida	9
7	George	12
8	Harriet	33
9	Ian	39
10	Janice	1
11	Ken	22
12	Laura	6
13	Mark	40
14	Nora	31
15	Oliver	38
16	Petra	24
17	Quinten	18
18	Rose	3
19	Steve	15
20	Thelma	3
21	Usman	13
22	Vera	38
23	William	32
24	Xena	4
25	Yorich	5
26	Zara	34
27	Alan	17
28	Brenda	5
29	Cuthbert	15
30	Davina	37
Sheet1

Book1
	A	B	C
5	Bernice	Ken	Adam
6	Deborah	Petra	Charlie
7	Eric		Harriet
8	Frida		Ian
9	George		Mark
10	Janice		Nora
11	Laura		Oliver
12	Quinten		Vera
13	Rose		William
14	Steve		Zara
15	Thelma		Davina
16	Usman
17	Xena
18	Yorich
19	Alan
20	Brenda
21	Cuthbert
22
Sheet2

Cell Formulas
Range	Formula
A5:A21	A5	=FILTER(Sheet1!$A$1:$A$30,Sheet1!$B$1:$B$30<=20,"")
B5:B6	B5	=FILTER(Sheet1!$A$1:$A$30,((Sheet1!$B$1:$B$30>20)*(Sheet1!$B$1:$B$30<=29)),"")
C5:C15	C5	=FILTER(Sheet1!$A$1:$A$30,Sheet1!$B$1:$B$30>=30,"")
Dynamic array formulas.

 

[ridgeroo85]

Thank you kevin9999. I'll give this a try later on and see if it works as intended, it does appear to filter the names out into a respective banding which is perfect. I'll let you know how I get on with it

 

[kevin9999]

Thank you kevin9999. I'll give this a try later on and see if it works as intended, it does appear to filter the names out into a respective banding which is perfect. I'll let you know how I get on with it

I look forward to your feedback.

 

[ridgeroo85]

Thanks kevin9999. Worked a treat and done as intended.

 

[kevin9999]

Thanks kevin9999. Worked a treat and done as intended.

Happy to help, and thanks for the feedback