Below is what my macro currently looks like. I use this when I download a report from SAP into Excel. After the report is download I wanted to create a macro that moved all the blank spaces on a row over to the left. My issue is that the starting point isnt always at 54. It changes every time I down load the report. How can I change this so that the macro starts running after a certain word. Specifically the word Components. The macro has already been ran and there is some personal editing I did to the sheet. Please see the attachment as well.
Bookmarks