LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Filter External Data

I've developed a spreadsheet that is shared amongst several different reps
and relies on quaterly updates of external data. Column A has the each rep's
unique territory number. I used to filter the import query for each reps
territory, and save it under each reps name and forward it to them with only
their data. However, I recently redesigned the w/s and developed some custom
toolbars. This is where I'm having problems. If I forward the sheet, the
toolbars don't get forwarded. I tried attaching them to the individual
sheets, but they only seem to attach themselves to the last saved sheet,
meaning that I would have to filter, attach, save, email, and repeat for each
rep. So my question is twofold, depending on which is easier: 1) is there
another way of attaching these custom toolbars that would work 2) should I
develop a userform that pops up on entry asking the rep to select their
territory (Ie: a simple way to get them to filter their import query.) which
would result in me having only to send one sheet which would take care of the
toolbar problem. Hopefully this is clear. Any help, tips or ideas would be
appreciated. I'm relatively an amateur at this.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter external data El Jefe Excel Discussion (Misc queries) 1 January 2nd 08 03:20 PM
Automatic filter during import of external data? CW Excel Discussion (Misc queries) 0 November 29th 06 11:51 AM
in data/filter/auto filter sp8 Excel Worksheet Functions 2 May 12th 06 01:03 AM
Set external cell filter for a range nastech Excel Discussion (Misc queries) 1 March 29th 06 08:36 PM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du TC Excel Worksheet Functions 1 May 12th 05 02:06 AM


All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"