Copy and paste between two words that you find

[tonywatsonhelp]

HI everyone,
so i have a tab called RAW and a tab called SALES
What i would like to do is look down RAW column a and find 03 Sales
Then find 04 Loss and copy from Row find 03 Sales to one row up from find 04 Loss
and paste values into sheet Sales cell F11
please help if you can
Thanks
Tony

 

[KRice]

I'm not sure I follow what you want, but if you have something like this on the RAW sheet:

MrExcel_20220603.xlsx
	A
1	Col A Heading
2	a
3	b
4	c
5	d
6	03 Sales
7	e
8	f
9	g
10	04 Loss
11	h
12	i
13	j
RAW

...and you're using Excel 365, you can extract the values between 03 Sales and 04 Loss like this in F11...and if you have an older version of Excel, the approach is G11 is an alternative:

MrExcel_20220603.xlsx
	F	G
10	Values between
11	03 Sales	03 Sales
12	e	e
13	f	f
14	g	g
SALES

Cell Formulas
Range	Formula
F11:F14	F11	=LET(start,MATCH("03 Sales",RAW!$A$2:$A$1000,0),end,MATCH("04 Loss",RAW!$A$2:$A$1000,0),INDEX(RAW!$A$2:$A$1000,SEQUENCE(end-start,,start)))
G11:G14	G11	=OFFSET(RAW!$A$2,MATCH("03 Sales",RAW!$A$2:$A$1000,0)-1,,MATCH("04 Loss",RAW!$A$2:$A$1000,0)-MATCH("03 Sales",RAW!$A$2:$A$1000,0),1)
Dynamic array formulas.