Sheet 1 -- Details
A B
Org #1 1
Voter #1 Votes 2
Voter #2 Votes 3
Total VotesSUM1 4
Org #2 5
Voter #1 Votes 6
Voter #2 Votes 7
Total VotesSUM2 8
Sheet 2 -- Summary
A B
Org #1 Votes (=Sheet1!B4) 1
Org #2 Votes (=Sheet1!B8) 2 <-- These need to fill by fours
Now, my problem lies in that we do a lot of these sheets, and we have over 300 Orgs. Is there a way to fill the formulas on the summary sheet to move 4 cells per one cell? As in on the summary sheet (Sheet 1), there is only one line difference between Org #1 and Org #2, where on the detail sheet (Sheet 2) there are four lines of difference. When I use a standard fill command, the numbers increment by one in the formuls =Sheet1!B4, so the next one would be =Sheet1!B5. This is wrong, I need it to inrement by four so that it goes =Sheet1!B4, =Sheet1!B8.
Any help is much appreciated. Thanks