Hello,
I am trying to write a macro that formats a report. I have successfully written the macro however it's the report that throws my macro off because depending on how many parameters I use to generate the report it will start the data on a different row. For example if I use 6 parameters it might start the data on row 19. If i use 8 it might start it on row 22. The reason is the parameters are written above the data on the report and so the more I have the more rows it adds.
The report however always has the same headers above the data. As an example in column B at the top of the data it will always say Source.
What I want to do is find the first instance of the word "source" in column B. Identify what row that is (say row 19). Then insert a bunch of rows directly above it until Source is on row 30. I know for sure I would never use enough parameters that the data would start after row 30. So by forcing the inserted rows to get it source to row 30 every time, the remaining of my macro can be trained to assume the data always starts on row 30.
I would love your help!.
Bookmarks