Macro to move row from one worksheet to another
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
|