If date is upcoming, show in list in different tab

[heybella]

Hi there,

Im building a report where on one tab, we fill in all out training dates. On another tab in the same file, there is a dashboard that I want to show only upcoming trainings (if date is today or further ahead).
So IF date there are dates that are upcoming in tab 2, I want the training information to show on tab 1.

Hoping one of you gurus will be able to help figure out this formula as I seem to make mistakes and not figure it out.

Thanks in advance!

[alansidman]

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[heybella]

Hey Alan,

Thanks for explaining how to get that file in there!! I was trying to add it in the "Menu bar" but it wouldn't let me. I have edited my post hoping this will make more sense

[alansidman]

Please Login or Register  to view this content.

[heybella]

thanks Alan for being so helpful!

I'm not very experienced with code in Excel and have mostly used formulas. Please can you help me understand where I would input this code?

Thank you SO much for your help, really appreciate it!

Bella

[Bo_Ry]

Please try at C7 drag to D7 and drag down

=IFERROR(INDEX(Trainings!A:A,AGGREGATE(15,6,ROW(Trainings!$B$2:$B$99)/(Trainings!$B$2:$B$99>=TODAY()),ROWS(C$7:C7))),"")

Then Change date format to column D

[alansidman]

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[heybella]

Thank you both for all your help - this works!!!!!

SO thankful for your help and now my dashboard is complete! :D