Looking for a solution to a common problem

**t1mmclaren** · 02-17-2009, 03:47 AM

I want to set up a event spread sheet in my work place that is very flexible, fairly clean and can be used by idiots.

Firstly I have a Worksheet that contains a list with all the personal data for the attendees. eg. First Name, Last Name, Company, Seat Number.

When we hold the events we produce a variety of different materials that require parts of this data filtered and sorted in different ways.

I would like to create a different worksheet for each of these variations that updates as I change the original data.

I can obviously do a Macro Script that will run an advanced filter when I want it but there are other issues... When I do the advanced filter how do I:

Clear the worksheet
delete the columns that are not necessary
sort the cells
create new columns that are merger of 2 or 3 cells

If somebody could through me a few resources for these things that would be great.

**arthurbr** · 02-17-2009, 03:59 AM

I want to set up a event spread sheet in my work place that is very flexible, fairly clean and can be used by idiots.

And who might those be?

**Steve R** · 02-17-2009, 04:57 AM

Originally Posted by t1mmclaren

I want to set up a event spread sheet in my work place that is very flexible, fairly clean and can be used by idiots.

Firstly I have a Worksheet that contains a list with all the personal data for the attendees. eg. First Name, Last Name, Company, Seat Number.

When we hold the events we produce a variety of different materials that require parts of this data filtered and sorted in different ways.

I would like to create a different worksheet for each of these variations that updates as I change the original data.

I can obviously do a Macro Script that will run an advanced filter when I want it but there are other issues... When I do the advanced filter how do I:

Clear the worksheet
delete the columns that are not necessary
sort the cells
create new columns that are merger of 2 or 3 cells

If somebody could through me a few resources for these things that would be great.

Create a new workbook with copied values from the advanced filter?
Then you delete the columns that are not necessary, without editing the original workbook.
Sort the cells
Concatenate to merge cells

**royUK** · 02-17-2009, 05:30 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.