I am hoping to get some help on copy and paste! Seems like something simple and probably is but here goes....I need to repeat several data sets that have 6 rows of data down a single column, the data sets point to various other sheets but the constant is that I need each row within the data set to increase by 1 each time I paste the data set, however, it is increasing each row 6 due to the 6 individual lines of data...See example below..... (I will need to copy and paste the data sets around 60 times).
Direct Craft Description | =Sheet2!$B9 | |
Number of Craft | =Sheet2!$D9 | |
S.T. Pay Rate | =Sheet2!$K9 | |
O.T Pay Rate | =Sheet2!$K88 | |
S.T. Billable Rate | =Sheet3!$R9 | |
O.T. Billable Rate | =Sheet3!$S9 | |
COPIED AND PASTED FROM ABOVE | ||
Direct Craft Description | =Sheet2!$B17 | <<<How can I make this paste as =Sheet2!$B10 |
Number of Craft | =Sheet2!$D17 | <<<How can I make this paste as =Sheet2!$D10 |
S.T. Pay Rate | =Sheet2!$K17 | <<<How can I make this paste as =Sheet2!$K10 |
O.T Pay Rate | =Sheet2!$K96 | <<<How can I make this paste as =Sheet2!$K89 |
S.T. Billable Rate | =Sheet3!$R17 | <<<How can I make this paste as =Sheet3!$R10 |
O.T. Billable Rate | =Sheet3!$S17 | <<<How can I make this paste as =Sheet3!$S10 |