Macro to Move Cells Based on Value of Another Cell?

[nikkisayswhat]

See below screenshot, I need some help creating a formula for this. I have a list of services that I have to export to excel daily, and then manually edit it and then upload it to another program. I have a macro that does most of the formatting automatically, but there are two hiccups that I can't seem to figure out a solution to.

The first is the data that starts on line 47. This is the footer data that is included when you run this particular report, and it is always at the bottom of the first page, but the position varies based upon the number of entries above it, so while right now it is on line 47, it may be on line 46 on another day. I have been unable to figure out a way to tell Excel "see if a cell in column B has "Generated by" in it and then delete that line along with the 15 lines", in this particular example I would want to delete lines 47-62.

The second and similar problem is, due to a quirk of our software, sometimes the data on the second page will be offset. You will see that on the first page column H has "I" for each entry, but on the second page everything has shifted to the right one cell, and just to make things extra fun and difficult the bottom part of the header for row G has shifted over, but not the top part of the column header. For this scenario I have been unable to figure out how to tell Excel "Look for any data in row I that has a value of the letter I, if it does shift everything over to the left, starting with column G."

I know that both of these need some sort of if statement, I am somewhat familiar with programming but Excel and VBA is something I have never messed with and it seems to be absolutely evading me. Is what I want to do possible?

Attachment 696405

[Mumps1]

It's hard to work with a picture. It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.

[nikkisayswhat]

Sorry about that, I attached the workbook!

[Mumps1]

Try:

Please Login or Register  to view this content.

[nikkisayswhat]

Try:

Please Login or Register  to view this content.

That worked perfectly, thank you so much! Starting next week I am gone for a month on Medical leave and I have been trying hard to get this to work so I can make things easier on the person who fills in for me, and this is EXACTLY what I needed!

[Mumps1]

You are very welcome and get well soon.