Macro to relocate specific info

[Nigel]

Goodmorning...I have a workbook containing several hundred worksheets, each worksheet has a large amount of information about a particular vehicle. I would like to produce an individual report only taking specific information for that vehicle and placing it on a template. For example ....worksheet number 25 selected and now active, I then need a macro which will take the contents from worksheet 25 cell numbers c5, c10, c15 and place it on a template at d20, d25 and d30, print the template (print area A1 to J25) and then return back to the original active worksheet number 25. The important point being whichever worksheet I select, when the macro is run it takes the information from that sheet. The template being just a seperate worksheet in the same workbook called "museum". My macro programming knowledge is very limited so if somebody could point me in the right direction with this I would be very grateful...thanks in advanced.

[JBeaucaire]

1) Go to your Template sheet and set the Print Range for that sheet so it's already done and permanent.

2) Use this:

Please Login or Register  to view this content.

[Nigel]

Many thanks for taking the time to reply. Everybody is on Eid holiday here for a week so I wont be able to give feedback for a while. But thanks again for your help.

[Nigel]

Hi...Sorry for the delay in responding to your reply. The code works perfectly, many thanks.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

[Nigel]

Hi...I did try to add "solved" but it appears if the original post is more than 2 days old the "edit" feature is no longer available and you have to rely on a moderator to add it for you. Thanks again for your help.