Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

calling all excel wizards I NEED HELP

3ezz3ezz Registered User new member
edited November 2011 in Help / Advice Forum
i need help on excel sheet that contains dates and a group of celss under each date no i need to enter the date on another worksheet and below it returns the data in the cells under it

any one could help .........

https://docs.google.com/open?id=0B9INpTRfNH7-ZGNkOTlhNzctYTRhMy00MjUyLWIyYmUtOWVkNWRjNmZhMmNm

3ezz on

Posts

  • DeebaserDeebaser on my way to work in a suit and a tie Ahhhh...come on fucking guyRegistered User regular
    you want to do what now?

  • DeebaserDeebaser on my way to work in a suit and a tie Ahhhh...come on fucking guyRegistered User regular
    edited November 2011
    ffffffuuuuuu.... registered an hour ago. Shouldn't have clicked that link so quickly.



    pleasedontbeaspambotpleasedontbeaspambotpleasedontbeaspambotpleasedontbeaspambotpleasedontbeaspambotpleasedontbeaspambot

    Deebaser on
  • LaOsLaOs SaskatoonRegistered User regular
    Without clicking on the link, it sounds like a vlookup situation, with the formula on another sheet referencing cells in the original sheet.

  • japanjapan Registered User regular
    In situations like this, I usually cheat by having the actual data on another sheet in a sensible format, then having the sheet that needs to be prettily formatted pull its data from it.

    I'm not sure you can easily do what's required without a macro or an intermediary sheet, given that the data's spread all over a horrible layout.

  • PailryderPailryder Registered User regular
    I agree with LaOs. Do a help lookup on "vlookup"

    Steam: http://steamcommunity.com/id/pailryder/
    Blizzard: Pailryder#1101
    GoG: https://www.gog.com/u/pailryder
Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum