copying and skipping consecutive row data
Hi all,
Can't seem to logically write the code for this and would like to reach out for help. Basically, I have a sheet with data listed in Column1 and Column2. The data was derived from backup of two file servers. The idea is to copy the first 13 rows in column 2 to the result sheet starting with 759 and skip the next three blank spaces, copy the next 13 and skip the next three. However, where it says 'Totals for SRV1' below, there is only 9 columns and I'd like to have the program skip that data and go to the next 13 consecutive row data. This is really the first question. The Result sheet is really what the output should look like. Please help, any and all suggestions/responses is appreciated, thanks! Job ID 759 Workstation SRV1 Source D: Target D_DIFF-MON Session 121 Start Time 11/2/2004 23:59 Total Directory 279 Total File(s) 357 Total Skip(s) 0 Total Size Disk 539.62 MB Total Size Media541.62 MB Elapsed Time 56s Average Thruput 580.31 MB/min Job ID 759 Workstation SRV1 Source D: Target D_DIFF-MON Session 122 Start Time 11/2/2004 23:59 Total Directory 279 Total File(s) 357 Total Skip(s) 0 Total Size Disk 539.62 MB Total Size Media541.62 MB Elapsed Time 56s Average Thruput 580.31 MB/min Totals For SRV1 Total Session 4 Total Directory 1,627 Total File(s) 2,204 Total Skip(s) 0 Total Size Disk 774.99 MB Total Size Media786.06 MB Elapsed Time 1m 52s Average Thruput 421.10 MB/min |
All times are GMT +1. The time now is 12:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com