Group,
I have a spreadsheet that changes weekly. The spreadsheet can have over a 1000 rows or just a few hundred. In column D, a cell may be blank or if there is an entry will have a text value with a suffix .checksum, like regioncode.checksum or rds.checksum. The prefix before the (.) dot will always be lumped together once there is an entry. In otherword, rds.checksum will never appear again after cell D7 once its initial incidence (D3) is found, regioncode.checksum will never appear again after D20 once its first incidence (D11) is found below. I want to show on another worksheet called "Summary", the name of the variable (ie: rds.checksum) in cell A2, its starting row (3) in cell B2, its ending row (7) in cell C2 and so on for each group of .checksum entries. Any help here would be awesome.
Cell:Contents
D1: < Blank>
D2: < Blank>
D3: rds.checksum
D4: rds.checksum
D5: rds.checksum
D6: rds.checksum
D7: rds.checksum
D8: < Blank >
D9: < Blank >
D10: < Blank >
D11: regioncode.checksum
D12: regioncode.checksum
D13: regioncode.checksum
D14: regioncode.checksum
D15: regioncode.checksum
D16: regioncode.checksum
D17: regioncode.checksum
D18: regioncode.checksum
D19 regioncode.checksum
D20: regioncode.checksum
D21: < Blank >
D22: < Blank >
D23: < Blank >
D24: < Blank >
etc...........
Tony
Bookmarks