I have two formulas that I am trying to create a macro for that will copy the formula from one sheet and paste the formula onto another sheet. The formulas I am using are:

Retrieve Model # =IFERROR(INDEX(AllParts.csv!$F:$F,MATCH($B3,AllParts.csv!$E:$E,0)),"")

Retrieve Description =IFERROR(INDEX(AllParts.csv!$H:$H,MATCH($B3,AllParts.csv!$E:$E,0)),"")

The formula references an external workbook (AllParts.csv), but the formulas are located on a separate sheet (Formulas) in the "Main" workbook. The "Main" workbook has the following:

[TABLE="width: 500"]

A

[/td]B

[/td]C

[/td]1

[/td]Main

[/td]Main

[/td]Main

[/td]2

[/td]Part #

[/td]Model #

[/td]Description

[/td]3

[/td]101

[/td]4

[/td]102

[/td]5

[/td]103

[/td]6

[/td]104

[/td]7

[/td]105

[/td]8

[/td]106

[/td]9

[/td]107

[/td]

[/TABLE]

I tried recording a macro that would copy and paste the formula into cell B3, it changes "B3" to "B5"