+ Reply to Thread
Results 1 to 2 of 2

Help with techniques on how to populate tables in different months Formula , VBA or Pivot?

  1. #1
    Registered User
    Join Date
    02-28-2018
    Location
    Edinburgh
    MS-Off Ver
    2016
    Posts
    12

    Help with techniques on how to populate tables in different months Formula , VBA or Pivot?

    Hi all,

    Just made an account on the forum as I'm completely stumped on how to tackle my issue. Basically I'm looking for a way to scan through the Data dump (Sheet2).Filter through what milestone falls into the correct month criteria i.e the next three months then correctly populate each cell in the column with info.I am a complete Excel Novice so my ability and understanding is very limited, perhaps there could be a way through VBA or pivot table?
    Also the formatting on the tables would have to be altered accordingly i.e if there is more in that certain month then the rows have to be extended or if less then reduced.

    I've attached an example of what my issue is , if someone could take sometime to have a look that would be hugely appreciated

    Thanks in Advance all !
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Help with techniques on how to populate tables in different months Formula , VBA or Pi

    First, I'd recommend restructuring your table to flat table with single date column.

    This can easily be done using PowerQuery.

    Convert range to Excel Table, then go to Data tab and use From Table/Range to load data to PQ (Get & Transform).

    Once loaded, select all the date columns (Milestones). And right click and select Unpivot.

    It should look like below.

    0.JPG

    Then load to worksheet. Now you can simply filter table based on the date column.

    See attached.
    Attached Files Attached Files
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Renaming Grouped Months in Pivot Tables
    By scionli in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-10-2016, 01:23 PM
  2. tips/techniques on how to speed up pivot table calculations
    By union in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-11-2015, 04:35 PM
  3. Replies: 5
    Last Post: 11-19-2013, 09:14 AM
  4. [SOLVED] Dates and Pivot tables - I just want months
    By MAA in forum Excel General
    Replies: 2
    Last Post: 05-03-2012, 09:37 AM
  5. pre-populate pivot tables all in one sheet
    By mr.atheist in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2010, 02:38 AM
  6. Can Pivot Tables break years into months?
    By mattlazarus in forum Excel General
    Replies: 0
    Last Post: 11-30-2006, 04:36 PM
  7. Pivot Tables/Summarizing data by months
    By hailnorm in forum Excel General
    Replies: 0
    Last Post: 01-24-2005, 06:29 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1