Creating a Template Printing Page or a clever way of copying linked cells

Hi, thank you for your response,

let me try and make my explanation a bit clearer:

In the main worksheet i have names, addresses, quantities, items, costs, etc.

I load this information in from a CSV file.

Each row is 1 person and their associated items, etc.

I then want to print this information so the name, address and some fixed information (returns address, postage image, etc.) are on the top half of a A4 sheet, on the bottom half is the quantity, item, cost, etc.
This is then repeated several times for each line of the main worksheet, i.e. each persons order can be printed off on a seperate sheet of A4.

Say i have 100 customers one day, that means i need 100 pages to be printed off, as it stands that would mean i would have a one off task of creating a very long excel sheet with the address, item, etc. correctly linked to the rows in the main worksheet. This obviously would take a long time, as ,as it stands i have to edit the formula for each page to link to the correct cell.

I have attached the excel sheet to show what i mean - you don't have to enable macros for it to work if you are worried about security - the macros are just used for tidy up.

Thank you,

Mike



***A slightly faster though still not ideal way is to copy and paste the pages and do a search and replace to update the linked cells cell numbers, i guess this will do if there is no better solution***