User Profile
malttbn
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Issue with autofill and absolute references while using a Macro
I have large arrays of text that I am trying to use a macro on to save time. The goal is to change a reference in the formula as bolded below: =xlookup($B$23,lookup_array,xlookup(A23,lookup_array,return_array)) I need to reference this to the same cell for each sectionof data. I record a macro where I change the reference, make it an absolute reference (by hitting F4), and then auto fill all the way down. This works as intended. When I try to run the Macro in the next section the formula refers to the original cell I referenced when recording the Macro. I need this to refer to the cell R-1C-2 and then autofill this down as an absolute reference. I hope this makes sense. See table below for an induction of what I'm trying to achieve. Note that I am using relative while recording the Macro. Any help would be appreciated.885Views0likes1Comment
Recent Blog Articles
No content to show