NewDaddy
03-09-2007, 07:38 AM
Hi all
I need some help please. I am not sure how to do this at all. I have the following sheets: Catalogue List and Sheet B.
In the Catalogue List sheet I have centre numbers in column A and names of people in columns H, I, J & K which forms a distribution list of people wanting reports for that centre.
I would like to build a template to use in emailing out reports. What I need is to create Sheet B with a list of names in column A and all the centre numbers for that person starting in column B, onwards.
That is to ‘populate’ column A of Sheet B with all the names that appear in columns H to K from the Catalogue List sheet and bring in all their corresponding centre numbers in column B onwards, i.e. centre numbers would start in column B and end wherever rather than a string of centre numbers in column B.
I am not sure if the following table will work to illustrate what I am looking for but hear goes, oh and I have also put in an example of the Catalogue List.
If it doesn’t I hope I have explained clearly enough.
Edit by mdmackillop: see attachment in next post
As you may be able to see a person can appear in any column but only once for each centre (row).
As ever your help is greatly appreciated.
Cheers
Jay
I need some help please. I am not sure how to do this at all. I have the following sheets: Catalogue List and Sheet B.
In the Catalogue List sheet I have centre numbers in column A and names of people in columns H, I, J & K which forms a distribution list of people wanting reports for that centre.
I would like to build a template to use in emailing out reports. What I need is to create Sheet B with a list of names in column A and all the centre numbers for that person starting in column B, onwards.
That is to ‘populate’ column A of Sheet B with all the names that appear in columns H to K from the Catalogue List sheet and bring in all their corresponding centre numbers in column B onwards, i.e. centre numbers would start in column B and end wherever rather than a string of centre numbers in column B.
I am not sure if the following table will work to illustrate what I am looking for but hear goes, oh and I have also put in an example of the Catalogue List.
If it doesn’t I hope I have explained clearly enough.
Edit by mdmackillop: see attachment in next post
As you may be able to see a person can appear in any column but only once for each centre (row).
As ever your help is greatly appreciated.
Cheers
Jay