Display data from one tab as merged cells on another tab of workbook

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    Hello,


    On my tracker I have two sheets, ( schedule, calendar view) on the schedule sheet the different sections simply enter section number, start and end date, event. I manually move all that to the calendar view sheet to get a quick snap shot over the years(s) . I shortened the calendar for this example , but it will continue for several years. Is there a way to have excel automatically move data to the correct area of the calendar view sheet?

    As you can see on the calendar view sheet I have merged cells and placed the events from the schedule sheet under the correct section. (1-1 means section 1 tm 1, 3-2 means section 3 tm 2, ect.)

    Files

    • Tracker.xlsx

      (12.58 kB, downloaded 21 times, last: )

    Edited once, last by alansidman: Crossposted: mrexcel.com/board/threads/disp…-tab-of-workbook.1162333/ ().

  • Merged cells will make this difficult.


    Maybe this old calendar that I made some time ago might help

  • Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. We are here to help so help us help you!




    Read this to understand why we ask you to do this



    https://www.excelguru.ca/content.php?184

  • My apologies, I think I have made enough rooky mistakes to be covered for the next million years now.

    The worst thing you can do with Excel ... is using Merged Cells :cursing::evil:


    They should simply be BANNED ... !!!


    Be aware of the fact that using Merged Cells is ... Sowing the seeds of ALL your Future Problems ...;)


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • To be complete .... below is THE ALTERNATIVE ... How to Avoid Merged Cells ...



    To center text across multiple columns, do the following:

    1. Select a range that consists of the text and the cells across which you want to center this text.

    2. On the Home tab, in the Alignment group, click the dialog box launcher

    3. In the Format Cells dialog box, on the Alignment tab, click the Horizontal list and then select Center Across Selection

    4. Click OK.



    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • I suppose I wouldn't need to merge the cells, but I would like the event to take up the cells representing the days from start to finish for the month that the event is happening. I have to figure out how to get excel to recognize that the cells N4:AR4 represent the month of Jan 21 and that AS4:BT4 represent Feb 21. Maybe a VLOOKUP to make sure the correct section/tm is aligned with the correct dates??????

  • Indeed ... no Merged Cells ...


    In terms of cosmetics ... attached is your test file


    and to get you started ... a formula to determine your Target Row ...;)


    Hope this will help

    :)

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Quote

    My apologies, I think I have made enough rooky mistakes to be covered for the next million years now.

    Many mistakes cannot be avoided by spending a few minutes reading the Forum Rules. All Excel Forums have similar if not the same rules.

  • Thank you,

    This is by far the closet thing to what I want to achieve, I still need to figure out how to separate where you make the entries and the chart onto different pages, could have over 100 entries tracking just 16 tms so wouldn't need that so much vertical as horizontal ( linear calendar).


    this helps a lot!

  • If I am only tracking 4 tasks , labeled 1,2,3,4, that will be repeated throughout the year, is there a way to have the Gantt chart just continue the entries on just four rows?

    I would like the chart to remain only 4 rows in size and simple add to each of the 4 rows as more entries are added, what function would allow for excel to recognize that an entry belongs to either 1,2,3 or 4 and fill in the cells associated with that tasks for those dates without adding a new row to the chart?