Hi
I have a workbook with two worksheets: Sheet 1 and Sheet2
Sheet 1 has date, Time, Value1, Value2
In Sheet 2:- I have the following cells with formulae.............
A1 = Sheet1!A6
B1 = Sheet1!B6
C1=Sheet1!C0
D1 = Sheet1!D6
A2 = Sheet1!A12
B2 = Sheet1!B12
C2=Sheet1!C6
D2 = Sheet1!D12
etc.
How do I create a formulae using both the MOD function and the ROW function so that I can Copy Row 1 and Paste to Rows2, 3, 4, 5, etc where the result is as shown above?
Many thanks
Bob M
Bookmarks