I am right now working on making a macro that iterates through multiple xlsx files in a folder and applies the same formulas to them all referencing the same named sheet in each file. I am using xlookup to get a lot of the values but I only want to look at the left part of the range when I am searching for the cell in questions contents. Is there anyway I can do that? The current code is not working where I have Left(PTDws.Range(“N:N”),5)

I am not very experienced at VBA Macro code, and the code that I am trying to accomplish is a little too advanced for me to do haha. Anyways, I am looking to make code using nested if-statements to detect grouped rows and indent those specific lines and one that pastes specific strings in 16 rows.