agnesz
04-22-2009, 01:55 PM
Hi there -
This post is a result of another post I left last week, which I had marked as solved, but turns out its not.
I have a business review report that is created from another "Lookup Report" whereby a set of columns from each tab in the "Lookup Report" gets pulled into this main recap. There can be as many as 15 tabs, or as little as 2. The reason why the original macro doesn't seem to work is because the real system-generated "LookUp Report" also will have three hidden tabs. They will ALWAYS be in the same place, ie the first tab and the last two tabs will ALWAYS be hidden. I think that's why this macro doesn't work.
Can someone please help?
So sorry and thanks for everything.
az
This post is a result of another post I left last week, which I had marked as solved, but turns out its not.
I have a business review report that is created from another "Lookup Report" whereby a set of columns from each tab in the "Lookup Report" gets pulled into this main recap. There can be as many as 15 tabs, or as little as 2. The reason why the original macro doesn't seem to work is because the real system-generated "LookUp Report" also will have three hidden tabs. They will ALWAYS be in the same place, ie the first tab and the last two tabs will ALWAYS be hidden. I think that's why this macro doesn't work.
Can someone please help?
So sorry and thanks for everything.
az