|I have a whole other issue that popped up while transposing. It's rather confusing to explain without the actual Excel workbook to view, but I'll try.|
In the Range we initially called "Guy" I have values that are causing the transposing macro to place the wrong data into the cells.
(Note that my actual table is monitoring wells in the "Guy" range. So I have MW-1, MW-2, MW-3,...MW-10, then MW-1D, MW-2D, MW-3D,...MW-10D.)
When I run that TransposeData() macro I can see the values entering into the cells changing before moving to the next row. Like it's scrolling through data. The data in the MW-1 row actually has data from the MW-1D row.
Using the original example we used for setting up this macro it's like data transposed from row "Bill" was replaced with data from row "Billy".
Is it because MW-1 and MW-1D have similar characters and although unique, not unique enough for the macro to differentiate?
I tested it by changing the .Find from Range B1:B2000 to B1:B575, as follows (note, "Sample_ID" replaced "Guy"):
For Each Sample_ID In Range("F2:F27")
Set c = .Find(Sample_ID, LookIn:=xlValues)
"B575" stops just before the cell Name "MW-1D". The data transposes perfectly at that Range. If I change to "B576" and higher, the values change. "MW-1" values now have values from "MW-1D".
Just when I thought I had this licked...
Hopefully my explanation is comprehensible and fixable.
Last note: just to make it more complicated I have well names of MW-1, MW-1D, MW-11, and MW-10. Also repeated are MW-2/MW-2d, MW-3/MW-3d, and so on. The data values in these other cells are all over the place as well.