Macro that selects specific cells and puts values into other cells

[scooby33]

Hello,

I currently have a formula that utilizes the round, offset, and row functions to pull data from specific cells. It is pretty quick, however i am looking for help to make it faster. Currently when i fill the formula across rows, i have to go in and change cell references to the correct cells before i can drag the formula down. If there is a way to utilize a macro to speed this up even quicker i would greatly appreciate some assistance!

In the pictures i uploaded you can see the desired output where it grabs the number, the letter (if there is one), and percentage sign and puts all the information into a table.

the current forumla i am using is:

=ROUND(OFFSET($D$6,(ROW(D1)-1)*6,0)*100,0)&$M$5&OFFSET($D$7,(ROW(D1)-1)*6,0)

If you need more information please let me know, thank you!

 

[StephenCrump]

You could do it in one formula, along these lines:

	A	B	C	D	E	F	G	H
1
2		A	B	C
3		1	2	3
4						A1	B2	C3
5						D4	E5	F6
6						G7	H8	I9
7						J0	K1	L2
8		D	E	F
9		4	5	6
10
11
12
13
14		G	H	I
15		7	8	9
16
17
18
19
20		J	K	L
21		0	1	2
22
Sheet1

Cell Formulas
Range	Formula
F4:H7	F4	=LET(d,B2:D21,FILTER(d,MOD(ROW(d),6)=ROW(INDEX(d,1,)))&FILTER(d,MOD(ROW(d),6)=ROW(INDEX(d,2,))))
Dynamic array formulas.

 

[StephenCrump]

That should really be ...

F4: =LET(d,B2:D21,FILTER(d,MOD(ROW(d)-ROW(INDEX(d,1,)),6)=0)&FILTER(d,MOD(ROW(d)-ROW(INDEX(d,1,)),6)=1))

... to allow for d starting further down the worksheet rows.