Dragging data from a ‘selected’ sheet into another

I have a workbook which consists of 13 worksheets – a summary  sheet and then 12 sheets , one for each month of the year.

Each month, I populate the page for the relevant month with fiugres and comments from project reports.

On the summary page, most of the info is pulled forward into the relevant column/cell, i.e. there is a column for each month so it is very straightforward to populate each cell.

But, I have a few cells which only display a single set of data, usually the latest month’s input. Up till now, these cells have been filled manually but I would like to be able to select the month which I want to look at and then have this data pulled through automatically from the relevant sheet.

I wondered if it would be possible to use a drop-down menu containing a list of the months and then, when the month is selected, it goes to the relevant sheet and pulls those few cell’s contents through for me. I could do this on each cell to make it simpler if necessary.

Is it possible or is there another way, e.g. the user typing in the month or tab name?

Any help would be very much appreciated.

14 thoughts on “Dragging data from a ‘selected’ sheet into another

  1. ig

    Hello there, just became alert to your blog through Google, and found that it is
    truly informative. I’m going to watch out for brussels. I’ll appreciate if you continue this in future.
    Numerous people will be benefited from your writing.
    Cheers!

  2. sling tv

    Amazing blog! Is your theme custom made or did you download
    it from somewhere? A design like yours with a few simple tweeks would really make
    my blog stand out. Please let me know where you got your theme.
    Cheers

  3. coconut oil

    An outstanding share! I’ve just forwarded this onto
    a colleague who was conducting a little research on this.
    And he in fact ordered me dinner due to the fact that I discovered it for him…
    lol. So allow me to reword this…. Thank YOU for the meal!!
    But yeah, thanks for spending some time to discuss this matter here on your web site.

  4. ps4 games

    Hello! I know this is somewhat off-topic however I needed to ask.

    Does running a well-established blog like yours take a large amount of work?

    I’m completely new to operating a blog but I do write in my
    diary on a daily basis. I’d like to start a blog so I can easily share my own experience and
    feelings online. Please let me know if you have any kind of suggestions or tips for
    new aspiring blog owners. Thankyou!

  5. Ray Laing

    Hi Andrew,

    You are a star. It works like a dream. Many thanks – you have just made me and one of my (very) senior managers very happy. 🙂

    Regards

    Ray

  6. andrew walker Post author

    Hi there

    You could try this formula (I entered it into cell A5)…

    =INDIRECT("'"&$A1&"'!"&CELL("Address",M7))

    For my testing cell A1 was for the month and M5 was the data I wanted to pull across. So, if I typed July into A1 then cell A5 would change to reflect the data entered on the July sheet in cell M7.

    Thanks

Comments are closed.