StephenMatthews
New Member
- Joined
- Sep 26, 2013
- Messages
- 28
Hi Guys,
I have an Excel spreadsheet that lists various lines of data for hundreds of addresses, under each address there is a list of products but what I want is to transfer those lines of data from column B into columns C, D & E with an "X" or a "Tick" as per the example below and then delete the duplicate line/s so only one address line is listed showing the products in their designated columns. I have branch numbers ie 000789 which could be used to identify the branch as opposed to an address which could be subject to errors. I would like a Macro to do this for me and would need to create the additional columns being C, D & E with the headings and then move the data from Column B into the assigned columns. I hope someone can help me with this, I tried IF formulas but would prefer a Macro so when I run the Report it does all this automatically for me.
Thanks
Stephen.
I have an Excel spreadsheet that lists various lines of data for hundreds of addresses, under each address there is a list of products but what I want is to transfer those lines of data from column B into columns C, D & E with an "X" or a "Tick" as per the example below and then delete the duplicate line/s so only one address line is listed showing the products in their designated columns. I have branch numbers ie 000789 which could be used to identify the branch as opposed to an address which could be subject to errors. I would like a Macro to do this for me and would need to create the additional columns being C, D & E with the headings and then move the data from Column B into the assigned columns. I hope someone can help me with this, I tried IF formulas but would prefer a Macro so when I run the Report it does all this automatically for me.
A | B | C | D | E | |
1 | Address | List | Sandwich | Sweets | Drink |
2 | High Street, London | Sweets | X | X | |
3 | High Street, London | Drinks | |||
4 | Park Road, London | Sandwich | X | X | |
5 | Park Road, London | Drink | |||
6 | The Avenue, Coventry | Sandwich | X | X | |
7 | The Avenue, Coventry | Sweets |
Thanks
Stephen.