Hi guys,
I was hoping someone with some basic macro writing can urgently help me.
I have about 15 identical tables on individual worksheets each with
different data.
I also have a 16th worksheet with a similar empty table.
I would like a function that lets me select a worksheet name from a dropdown
list and that will make that sheets data appear in the 16th sheet.
In basic terms it would say something like:
If A1='Red Sheet' then the current cell this function is in will equal the
same cell in 'Red Worksheet'
If A1='Blue Sheet' then the current cell this function is in will equal the
same cell in 'Blue Worksheet'
If A1='Green Sheet' then the current cell this function is in will equal the
same cell in 'Green Worksheet' etc etc etc.
I cant use pivot tables for this, and the 16th sheet feeds various graphs
and stuff.
Can anyone help me?
Andy
Bookmarks