Find and display information
 

Hi

I am creating a spreadsheet that holds a large amount of data collected from questionnaires - I currently have 30 columns across, with each column representing a single client, and 50 rows down containing their answers to the questions we asked. This data is then going to be used to benchmark against one client's data against anothers.

The spreadsheet user needs to be able to select single or multiple criteria, and then have excel display only those columns containing matching data (for example, the user wants to display the data from all clients with a turnover in excess of 100 million, Excel then only displays the information from those columns (the whole column, not just the cell) where the client answered with 100 million or higher).

I have an interface set up but I can't get the macro (using the FIND v.b. function) to check through the columns, find a whole column of data, copy it, paste it on to an output worksheet I have set up, then check through remaining data and repeat this function until it has returned all relevant data. The Macros I have written so far haven't worked.

I know this sounds horribly complicated to explain, but has anybody got any ideas?!

Cheers

Find and display information
 

Just a suggestion, but if you transposed your data, you could use the built
in Autofilter to do this.

--
Regards,
Tom Ogilvy

"PGB" wrote in message
...
Hi,

I am creating a spreadsheet that holds a large amount of data collected
from questionnaires - I currently have 30 columns across, with each column
representing a single client, and 50 rows down containing their answers to
the questions we asked. This data is then going to be used to benchmark
against one client's data against anothers.

The spreadsheet user needs to be able to select single or multiple
criteria, and then have excel display only those columns containing matching
data (for example, the user wants to display the data from all clients with
a turnover in excess of 100 million, Excel then only displays the
information from those columns (the whole column, not just the cell) where
the client answered with 100 million or higher).

I have an interface set up but I can't get the macro (using the FIND v.b.
function) to check through the columns, find a whole column of data, copy
it, paste it on to an output worksheet I have set up, then check through
remaining data and repeat this function until it has returned all relevant
data. The Macros I have written so far haven't worked.

I know this sounds horribly complicated to explain, but has anybody got
any ideas?!!

Cheers