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

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Watch MrExcel Video

Forum statistics

Threads
1,108,579
Messages
5,523,695
Members
409,531
Latest member
wo1f

This Week's Hot Topics

Top