search/manually modify and update record

anyone ???

Hello

I wish to create a macro to search a sheet called "data" for a number in column a only. Once it has found that number, copy and paste special and transpose in a worksheet called "user page" in cell "b2" say, Then i want to be able to modify the info just pasted and then use a second macro to take the modified info and replace back in the "data" where it came from in the same row ideally. i am currently doing it using a valadation list for my number and a macro to filter the row i want copying and pasting in a new weeksheet then copying again, but the marco is slow and i am looking to have the vba run faster but i do not quite have the skiils to manage it. Any help would be appreciated.
example work book attached 2003!
Belkin