Hi All,
I am trying to copy selective data from one worksheet to another. My intent is to copy data in column F below to another worksheet in Column H. I only need to copy numeric data in Column F. Below is the screen shot of my data set. There are 244 Batches and each batch contain 4 members. In another words, I want to copy data for 4 rows (F2 to F5) then skip three rows (F6 to F8), Then again copy 4 rows (F9 to F12) the skip 3 rows and so on.
I would like to use a function to do that for me. PLease help. Here is the sample data -
A B C D E F G H I J
1
2 John Accounts 8 4 1.5
3 Jack Receivable 8 4 2.5
4 Jim Payable 8 4 2.7
5 Justin Claims 8 4 3.9
6 Next lines of Data contain expenditure for batch 2
7
8
9 Kevin Network 8 4 3.3
10 Kurt UW 8 4 2.1
11 Kiefer Sales 8 4 1.3
12 Karl Payable 8 4 2.4
13 Next lines of Data contain expenditure for batch 3
14
15
16 Mary IT 8 4 3.3
17 Marc UW 7 3 2.1
18 Mark Sales 8 4 1.3
19 Mike Accounts 7 3 2.4
I am trying to copy selective data from one worksheet to another. My intent is to copy data in column F below to another worksheet in Column H. I only need to copy numeric data in Column F. Below is the screen shot of my data set. There are 244 Batches and each batch contain 4 members. In another words, I want to copy data for 4 rows (F2 to F5) then skip three rows (F6 to F8), Then again copy 4 rows (F9 to F12) the skip 3 rows and so on.
I would like to use a function to do that for me. PLease help. Here is the sample data -
A B C D E F G H I J
1
2 John Accounts 8 4 1.5
3 Jack Receivable 8 4 2.5
4 Jim Payable 8 4 2.7
5 Justin Claims 8 4 3.9
6 Next lines of Data contain expenditure for batch 2
7
8
9 Kevin Network 8 4 3.3
10 Kurt UW 8 4 2.1
11 Kiefer Sales 8 4 1.3
12 Karl Payable 8 4 2.4
13 Next lines of Data contain expenditure for batch 3
14
15
16 Mary IT 8 4 3.3
17 Marc UW 7 3 2.1
18 Mark Sales 8 4 1.3
19 Mike Accounts 7 3 2.4
