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

excel formula


  • Please log in to reply

#1
blackmb

blackmb

    New Member

  • Member
  • Pip
  • 1 posts
I need help with an excel formula. I have spreadsheet setup:

Example: column A1 has mary smith then row D13, E13, F13, G13, H13, I13, J13, K13 each has a number entered then I have the formula for the total in C13
as I enter a number in each cell I want it to simutaneously be entered on another worksheet under the same name, how do I do it or better still what is the formula.

Thanks
  • 0

Advertisements


#2
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
Not exactly sure what you're asking but if you go to the second worksheet, click on the cell you want the mirrored information, press = on the keyboard, go back to the first worksheet, click on the cell you want mirrored and press Enter on the keyboard. Repeat for other cells.
Is this what you need?
  • 0

#3
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts
This one is easy.

Start by Grouping together the sheets you want the values entered into (Ctrl + Click each sheet)

Now, start typing the numbers in the cells, but don't just press Enter, hit Ctrl + Enter

You will have to remember to do this for EVERY cell you want populated.
  • 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