I have recorded a few macros for my colleague, i have sent the file across in
which the macro was coded and have advised my colleague to assign the macro
to a toolbar button.

He assigned the macro to a toolbar button but finds that each week he needs
to run the macro he has to copy and paste the new info in the old file (in
which the macro was created) and then run the macro because if he doesnt do
this and clicks the smiley face (where the macro is assigned) he gets a
message 'macro cannot be found' - because the macro was obviosuly not
recorded in this file.. but how can i make it so the macro works all the
times.. so he doesnt have to copy and paste over the old data all the time
just because the macro sits in that file.. it should work now all the time
because the macro has been asssigned to a toolbar button, right?

At one point he found that even when he did copy and paste the info from new
to old, the toolbar assigned macro didnt work and said 'file cannot be found'.

please advise.