Data collecting from different sheets

[Martin]

Hi!

I have a workbook where I collect data to "raw data sheets". In theese
sheets the average of eath data category is calculated. What I need is a
macro that i can run in each new sheet so that theese averages are filled
into a presentation sheet. To make things more complicated there will be
different amounts of data (rows) in eath sheet.

The setup I need to work with is this:
Column A: States the type of data (only in the row where the average data
is, otherwise blank)
Columns C,E,G,I,K,M,O,P: The data I wish to copy. (But only in the average
data rows, determined by column A)

To complicate things more there is an eventuality that i will need to expand
my data collection to even more variables (columns) and willl thereby need to
collect that data too. Is there any way to do this relatively simply?

I am using excel 2003
Can Anyone Help?


Thanks in Advance

Martin

 

[Joel]

You need first to desing the presentation sheet. Once this is done you can
ask for additional help. Basically descripe the source column of the data
the destination column of the data, do you want all the data move or just a
summary, and where you want any formulas added.

 

[Martin]

Hi Joel

Thank you for your swift reply.

The presentation sheet looks exactly the same as the raw data sheet. The
difference is that I only want the mean values for the different experiments
(5 experiments -> 1 mean value). In every experiment i measure different
things, which gives data in columns C,E,G,I,K,M,O,P.
What I want to do is write a macro which I can use on any worksheet (with
this structure of course) which will add the rows with the mean values to the
presentation sheet.
In column A in every "mean value row" I have te corresponding test-average
number which i need in the presenting sheet. The rows where the raw data is
presented (not the mean values) is blank wherefor I´m thinking something
around the lines of making this the indicator for the macro to know that this
is the row to exporting the numeric value from.

I hope I make a little more sens.

Martin