I am working in Excel 2010 with an imported text file drawn from an older program where headers from a print version are repeated for each page - roughly 3000 headers in one of 15 reports I need to aggregate.
I have to keep the headers initiially in order to add data from the headers to the data I want to keep. Following that, I'd like a quick way to remover all those headers.
At the top of each header is our company name, which will not wind up in a consistent column, due to differences in the text-to-columns conversion across different reports. However, the company name will only occur as the entire content of a cell in the header - in other words, searching for that name will result only in landing on the top row of a header. Also, the header height might vary across reports, but on the initial report, it is 10 rows in height on this particular report. I want to delete the entire row for all 10 rows of the header.
My thought was to find the company name, select that row and user input for the # of rows below it, delete the header and then cycle to the next header and repeat.
One other trick - part way into the report, there are three summary lines added to the end of a page that I would like to delete. So on those headers, I need to find the company name, then select a range that includes the three rows above it and the entirety of the header below. I'm open to suggestions here - best I can think of is, using the idea above, executing a first pass deleting the 10 rows, then running it through again looking for another piece of unique info in the three remaining rows (which it has - a series of cells with "------------" on one row) and with the user input changed to 3 for rows, it could be done.
Thanks in advance for any help.
I have to keep the headers initiially in order to add data from the headers to the data I want to keep. Following that, I'd like a quick way to remover all those headers.
At the top of each header is our company name, which will not wind up in a consistent column, due to differences in the text-to-columns conversion across different reports. However, the company name will only occur as the entire content of a cell in the header - in other words, searching for that name will result only in landing on the top row of a header. Also, the header height might vary across reports, but on the initial report, it is 10 rows in height on this particular report. I want to delete the entire row for all 10 rows of the header.
My thought was to find the company name, select that row and user input for the # of rows below it, delete the header and then cycle to the next header and repeat.
One other trick - part way into the report, there are three summary lines added to the end of a page that I would like to delete. So on those headers, I need to find the company name, then select a range that includes the three rows above it and the entirety of the header below. I'm open to suggestions here - best I can think of is, using the idea above, executing a first pass deleting the 10 rows, then running it through again looking for another piece of unique info in the three remaining rows (which it has - a series of cells with "------------" on one row) and with the user input changed to 3 for rows, it could be done.
Thanks in advance for any help.