Transpose Formulas From Range 1 to Range 2 ???

.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
4
5		ORIGINAL FORMULAS					The formua in B7 is "=BI1" ….. C7 "=BJ1"…..D7 = DK1…..E7 "=BL1"
6	Administrative
7	State/Federal Posters	Y	R	1	2
8	Orientation Records	Y	S	2	1
9	Training Records/Certifications	Y	R	1	2
10	Daily AHA Records	Y	S	2	1
11	Toolbox Meeting Records	Y	R	1	2
12
13	Medical
14	CPR/FA Qualified Person	Y	S	2	1				How can I transpose those formulas to G7:J7 with the integer changed from "1" to "2" ?
15	First Aid Kit	Y	R	1	2
16	Map/Directions to Hospital Location	Y	S	2	1				I need to repeat this process from Row 7 to Ro 184 for Cols G:J and L:O
17	Medical Transportation Plan	Y	R	1	2
18
19	Sanitation

Thank you for your assistance.

.
Cell Formula
B7 "=BI1"
C7 "=BJ1"
D7 "=DK1"
E7 "=BL1"

If you drag the contents of those cells to G7:J7, the formulas auto-change to :

Cell Formula
G7 "=BN1"
H7 "=BO1"
I7 "=BP1"
J7 "=BQ1"

The goal is to have G7:H7 become:

Cell Formula
G7 "=BI1"
H7 "=BJ1"
I7 "=DK1"
J7 "=BL1"

... which is an exact copy of B7:E7.

If you drag the cells (B7:E7) or copy/paste or anything else I've tried, the formulas
don't remain the same as they were originally. The formulas change.

Ultimately, I need to copy the formulas over to the new columns ... change the number 1 to a number 2,
then repeat the process down all rows to row #184.

The same will need to be done for Cols L:O, except the number will be 3.

Hopefully this had made the goal somewhat more understandable ?

.
Solution :

Select FORMULAS from top menu bar.

Click on "Show Formulas"

Highlight all the cells to be copied / pasted.

Click COPY.

Paste to Notepad.

Copy all from Notepad and paste to first cell of range where
formulas will be transposed to.

At this point, it is easy to go to the HOME tab, EDITING and
click on FIND & SELECT ... then REPLACE.

In my situation I had it search for the number "1" and replace it
with the number "2". Of course this was done after highlighting all
of the cells to be edited.

This works as desired because NOTEPAD changes the copied formulas to TEXT. This way the formula does not
change when pasted to another range and the formula still works.

Thanks to all for reviewing !