Changing colums|VBA & Macros|Excel Forum|My Online Training Hub

Hi,

Please help. I'am trying to automate my report using macro. The problem is the columns are not constant. 

This week, I need the data on column M but next week it's already in column N, then the week after it's either back in column M or still on column N, etc. What is just constant is the column name. I am trying to apply by searching the name first and copy that column but still it doesn't work. 

Here is an example by using the recording macro.

Cells.Find(What:="fbaperunitfulfillmentfee", After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
Cells.FindNext(After:=ActiveCell).Activate
Columns("U:U").Select

Thank you,

Beth