linking cells when it is autofiltered

  • Thread starter Thread starter salihyil
  • Start date Start date
S

salihyil

hi guys

i have 500 user details. i used autofilter for this. i have created
another worksheet which is blank. what i want to do is copy the
filtered user details to other (new blank) worksheet. and when i change
the autofilter to other user data that has been tranfered to new
worksheet should change as well.

i want to do this because i am using mail-merge. and i want to show
only the filtered data in word but it shows all the learners not just
the filtered one.

this is why i want to create new worksheet so i can use new worksheet
as a source to mailmerge document and when autofiltered changed to
other learner it will dire4ctly change and provide new learner's
details

thank you
 
I think you could accomplish this with a macro (and I'd have it update the
secondary list based on a click of a button), but why not just use Word's built
in features.

When I do mailmerge in OfficeXP, I get a screen that allows me to do the
equivalent of Data|Filter.

I can use a dropdown that filters the data there.
 
Back
Top