Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying data from 1 worksheet and pasting to another skipping blan | Excel Discussion (Misc queries) | |||
Copying a formula but 'skipping' a cell | New Users to Excel | |||
Copying values but skipping empty cells | Excel Worksheet Functions | |||
Subtraction formula for consecutive cells in a column, skipping blanks | Excel Worksheet Functions | |||
Skipping empty rows when copying a formula down a column | Excel Programming |