Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Microsoft Excel Formulas


  • Please log in to reply

#1
hrdwrjnkie

hrdwrjnkie

    Member

  • Member
  • PipPip
  • 46 posts
Hi all, hoping that someone with some Excel experience can help me out here. I am setting up a dual-sheet workbook to tally votes for an orginizational meeting. The idea of the book is this:

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
  • 0

Advertisements


#2
cycling-rod

cycling-rod

    New Member

  • Member
  • Pip
  • 2 posts
One way:
The sum cells on sheet 1 are B4, B8, and the next will be B12 (and so on). Open sheet 2 and type an equals sign "=" in B3. Open sheet 1 and click B 12 and press enter. Sheet 2 will now show the sum cell B12 from sheet 1. B12 of sheet 1 is now linked to B3 of sheet 2. There is probably a macro or code that would increment by 4, but it only takes a moment to link the 2 cells as above.

Another way:
I'm using excel97. Copy B12, sheet 1. Paste Special in B3, sheet 2. Click on Paste Link.
  • 0

#3
hrdwrjnkie

hrdwrjnkie

    Member

  • Topic Starter
  • Member
  • PipPip
  • 46 posts

One way:
The sum cells on sheet 1 are B4, B8, and the next will be B12 (and so on). Open sheet 2 and type an equals sign "=" in B3. Open sheet 1 and click B 12 and press enter. Sheet 2 will now show the sum cell B12 from sheet 1. B12 of sheet 1 is now linked to B3 of sheet 2.  There is probably a macro or code that would increment by 4, but it only takes a moment to link the 2 cells as above.

Another way:
I'm using excel97. Copy B12, sheet 1. Paste Special in B3, sheet 2. Click on Paste Link.

View Post


This is what I've been doing, but I was wondering if there was an easier way than clicking back and for several hundred times...
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP