I'm trying to use a concatenate function in a macro across several sheets. The problem I'm running into is that the number of columns in each sheet is dynamic, meaning it changes from day to day or week to week.
Is there a way I can incorporate a dynamic concatenate function into my macro?
Is there a way I can incorporate a dynamic concatenate function into my macro?