Need to populate a dynamic table with data by year

dataLurker

New Member
Joined
Aug 9, 2010
Messages
1
I have 5 tables with 21 rows and columns. On one page, I have a drop-down list to select year - What function do I use to populate the table for each of the five years based on the selection in the drop-down? I have been away frome excel for awhile...and need some help to get me going!

Thank you
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,843
Messages
5,507,634
Members
408,641
Latest member
billigee

This Week's Hot Topics

Top