Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying data from 1 worksheet and pasting to another skipping blan Concertgoer Excel Discussion (Misc queries) 1 October 1st 08 12:30 AM
Copying a formula but 'skipping' a cell Mike Langensiepen New Users to Excel 2 May 3rd 07 06:17 AM
Copying values but skipping empty cells Handyy Excel Worksheet Functions 1 February 9th 06 01:41 AM
Subtraction formula for consecutive cells in a column, skipping blanks [email protected] Excel Worksheet Functions 2 September 16th 05 12:20 AM
Skipping empty rows when copying a formula down a column Rachel Jones Excel Programming 1 July 31st 03 03:55 AM


All times are GMT +1. The time now is 05:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"