Hi,

I am recording travel information in one worksheet using a drop down meny
for location. I want a macro that use the location as a determenator for
deciding which other worksheets the information should go to. And several
locations can go to the same worksheet. For example -

I fill in 28.10.2006 - Roger Rogerson - STA
and 30.10.2006 - Dana Danason - STB

Now I want to by the touch of a button send the information determined by
the location STA and STB to a worksheet named STX.

Is this possible?

Kind regards
Anders

--
Regards Anders