Hi
Your question is too vague and I doubt anyone will reply. Make your
question clearer.
e.g. "Certain Columns" - which columns? does it change?
"underlying data" - do you mean the data in the columns?
"the macro chooses" - do you need a form with a listbox? Are column
headers chosen in some other way?
"puts it in a sheet" - puts what in a sheet? Column headers, columns
of data? Something else?
"and further on" - ??????

see the problem?
regards
Paul

On Jun 6, 9:19 am, "A. Karatas" wrote:
Hi,

A database is provided to me each month with approx 20.000 lines and
approx 140 columns. How could I extract (with a macro) certain columns
with their underlying data in them. In mind I had a sheet called
assumptions with in column A a selection of the columnheaders wich the
macro chooses from and puts it in a sheet called OLAP from column A
and further on.

Thankx in advance