Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

macro help

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

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.

Share: 

 

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.




Tagged: