A big THANKY YOU for the effort. What we have here is close and I think a couple minor tweaks and should be working.
Sheet 2 should be outputting 5 total columns. Current output is 4.
Let me try to clarify a bit more and let's assume we want data every 20 rows:
- Looking at Worksheet2 Column A: Cell A2 value should be the same as start cell from original sheet. Then the 2nd Value Worksheet 2 cell A3, should be the cell that's 20 rows below the start cell on 1st sheet so startcell+20(or "r"). If we started at sheet 1 cell A2, then Sheet 2 A3 should be cell A22 from sheet 1. The 3rd value, Worksheet2 Cell A3, should now be 1st sheet startcell+40 etc.
- Worksheet2 Column B will use same logic as Column A. In original sheet, the StartCell+1column will give us the cell for Worksheet2, B2. So if Sheet 1 A2 is start cell, then Sheet B2 is value for Sheet 2 B2. Sheet 2 B3 will be Sheet1 B22. The third value for Worksheet2 Cell A3 should now be 1st sheet startcell+1column+40.
- Worksheet2 cell C2, is the maximum value from sheet1 (C2:C21). Worksheet 2 C3 will now be the maximum value from sheet 1 (C22:C41). And so on.
- Worksheet2 cell D2. is the minimum value from sheet1 (D2:D21). Worksheet 2 D3 will now be the minimum value (D22:D41). And so on.
- Worksheet 2 cell E2 is Sheet 1, Start Cell + 5 Columns - 20 rows. Assume start cell A2 Sheet 1 with 20 row input, Sheet 2 E2 should be Sheet 1 cell E21. Sheet 2 E3 should be Sheet 1 cell E41. And so on.
I hope that clarifies a bit and I apologize if the original request wasn't specific enough. If something is unclear, by all means please let me know. Again I appreciate the assistance very much.
Bookmarks