MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

macro help

  Asked By: Bogart    Date: Nov 17    Category: MS Office    Views: 532

I need a macro that bring data from 3 possible worksheets (Wk sheet A,B
& C),in each worksheet there are 10 product lines which are reported in
8 regions (columns B to J).

I was hoping the macro would work be driven by the 3 possible scenarios
for users to pull data from. at the moment I have a drop down menu with
1st one being the 3 possible worksheets. 2nd drop down being the 8
regions and the last being the 10 product lines.

Now comes the question,if someone want's to select e.g. wk.sheet 2 and
region column B (the information will come from the wk.sheet selected
i.e wk. sheet 2). and the last drop down selected is product z.(info
will come from wksheet 2)

is there a way this can run via a code in the background to bring all
this in one wk.sheet.



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on macro help Or get search suggestion and latest updates.