flatten data

If in a workbook I have a column of importance, in this case Animal. I have multiple Cats. I do not need all the Cat rows, I just need one with the lowest Start and the highest end. So, in this case my result would give me one row with Cat like so. I want to do this for all of the Animals in...

I am using the below code at the end of my mod to copy and export my workbook without it's formulas and macros. Seems to work well, but if I want to exclude a couple of worksheets from the file that it exports, what do I need to add? Dim Output As Workbook Dim Current As String Dim...

I am using an export code to take my worksheets to a destined folder in xlsm format. I am looking to adjust this formula so when the worksheets are exported it is a flat file that just contains the values in the cells NOT the formulas. Sub CreateWorkbooks()Dim wbDest As Workbook Dim wbSource As...

I have a file that looks like below. What i want to do is flatten the data out so it's all on one line. Can someone let me know if there is a way to do this? <TABLE style="WIDTH: 520pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=693><COLGROUP><COL style="WIDTH...