Hi there,

I have a source file which contains x columns. For illustration sake, let's say it looks like this:

CATEGORY NAME
1 J
1 J
1 J
1 J
2 J
2 J
3 J

What I want to do is to take this file in (it will be in Excel format) and allow the user to pick what columns they want, and produce a table like this:

1 4 Names
J
J
J
J
2 2 Names
J
J
3 1 Name
J

I am used to Access VBA, and the way I see it is I have to do the following;

A) Count how many columns there are. Loop through to get the name and column reference of each.
B) Display columns as a choice to the user (through a form or something?) and allow them to pick (checkboxes?) what columns to include.
C) Upon clicking a button, copy only the columns that are needed, and then copy to a new sheet in the Excel file.
D) Apply the grouping (not quite sure how to do this in Excel)

I would prefer to do an Access Report (is 1000x easier!) but the stipulation is that Access will only be used to supply raw data and not to supply the end table (this is not up for discussion, as my preferred way is to do it via a report in Access)

Any ideas?

Thanks