Hi all --
I have a worksheet that needs to be parsed for certain information, so let me just explain how the sheet is setup first.
The sheet is used to analyze performance metrics, which run along the columns, among category groupings that run along Row A. What I have been charged to do is to copy/paste each Row in this worksheet that is at the TOTAL level (Row B details which level it is).
So my fuzzy logic goes such as this:
- Find "TOTAL" among Row B
- Select entire row (actual contents go through Col AA)
- Switch to new worksheet
- Find next blank row in worksheet, and paste clipboard contents
My problem is that I just don't know how to code this in Excel. If anyone here could help me out, or at the very least point me in a direction to do so, that would be great! I know how to find the TOTAL rows, but I don't know how to extract the row number so that I can do a select on the current row to copy it. I am also having trouble finding the next blank row in the destination worksheet.
Thanks everyone!
I have a worksheet that needs to be parsed for certain information, so let me just explain how the sheet is setup first.
The sheet is used to analyze performance metrics, which run along the columns, among category groupings that run along Row A. What I have been charged to do is to copy/paste each Row in this worksheet that is at the TOTAL level (Row B details which level it is).
So my fuzzy logic goes such as this:
- Find "TOTAL" among Row B
- Select entire row (actual contents go through Col AA)
- Switch to new worksheet
- Find next blank row in worksheet, and paste clipboard contents
My problem is that I just don't know how to code this in Excel. If anyone here could help me out, or at the very least point me in a direction to do so, that would be great! I know how to find the TOTAL rows, but I don't know how to extract the row number so that I can do a select on the current row to copy it. I am also having trouble finding the next blank row in the destination worksheet.
Thanks everyone!