To your first question yes but sometimes I've been away for a while and then
I download a lot of info at the same time.
then no I do not delete the raw data but it's being copied into the sheet
aswell.
The closing values I would like to treat the same.

All of this is for my own convenience so that the worksheet will do all the
work it self and I don't have to copy and paste every day.

I would like to send you the file but I don't know how to do it here! Any
suggestions?

"Biff" wrote:

Hi!

This should be pretty easy but there are a couple of
things that I don't quite understand.

Do you download the raw data daily? And if so, after you
have that data sorted out to the other sheet do you delete
the raw data?

Where do you get the closing values?

I can think of a few different ways to do this but at the
same time it sounds like this file is very big and would
require a lot of formulas.

Have you considered using a pivot table or even a database
program?

To come up with a specific solution I would need to see
the file.

Biff

-----Original Message-----
Date Company Name Mnemonic opening
3-1-2005 ABN AMRO HOLDINGAABA 19,53
3-1-2005 AEGON AGN 10,09
3-1-2005 AHOLD KON AH 5,67
3-1-2005 AKZO NOBEL AKZA 31,25
3-1-2005 ASML HOLDING ASML 11,76
3-1-2005 BUHRMANN BUHR 7,2
3-1-2005 DSM DSM 47,51
3-1-2005 ELSEVIER REN 10,04
3-1-2005 FORTIS FORA 20,44
3-1-2005 GETRONICS GTN 1,68
3-1-2005 HAGEMEYER HGM 1,72
3-1-2005 HEINEKEN HEIA 24,55
3-1-2005 IHC CALAND IHC 46,65

So this is my Data input as I can download it from the
server what I would
like now is that this number you can see under opening is
being looked up in
another worksheet.
But now the A column states all the different dates and
the first row states
the different companies so that i don't have to copy
everything by hand.
As you can see the date here is only the 3rd of january
but in the complete
worksheet this must accumulate to a whole year as time
goes by and I can
download the data weekly.

Like this:

AABA

Date Open End
3-01-05 â,¬ 19,53 â,¬ 19,70
4-01-05 â,¬ 19,65 â,¬ 19,82
5-01-05 â,¬ 19,66 â,¬ 19,76
6-01-05 â,¬ 19,80 â,¬ 20,48
7-01-05 â,¬ 20,46 â,¬ 20,65
10-01-05 â,¬ 20,56 â,¬ 20,58
11-01-05 â,¬ 20,52 â,¬ 20,28
12-01-05 â,¬ 20,24 â,¬ 20,06
13-01-05 â,¬ 20,14 â,¬ 20,09
14-01-05 â,¬ 19,98 â,¬ 20,11
17-01-05 â,¬ 20,17 â,¬ 20,27
18-01-05 â,¬ 20,51 â,¬ 20,56
19-01-05 â,¬ 20,64 â,¬ 20,69
20-01-05 â,¬ 20,62 â,¬ 20,61
21-01-05 â,¬ 20,53 â,¬ 20,73
24-01-05 â,¬ 20,66 â,¬ 20,64
25-01-05 â,¬ 20,72 â,¬ 20,84

And then if this would be columns A through C but in the
complete worksheet
it goes through to AQ

Again is this possible?



"Biff" wrote:

Hi!

Can't really tell what it is you want.

Can you provide more detailed info? Be very specific.

Biff

-----Original Message-----
Ok what I need to do is to get the number from a
certain
cell with all kinds
of data (Stocks) into a worksheet in wich I can modify
my
investments.
Now the problem is that I get the data in the
following
order:

DATE COMPANY HIGH LOW VOLUME
x x x x x

What I would like now is that as I will have to add
more
data that the
'HIGH' and 'LOW' will be copied within a formula to
another worksheet in
which the Date can be found on the different rows and
all
the companies are
filled in the columns now there are 24 different
companies I have to aquire
the stockindexes from.

Will this be possible? What I can do is to get all the
first stock indexes
correctly but as I try to autofill all the dates it
doesn't seem to work with
only just the VLOOKUP formula!

Any help will be greatly appreciated.

.


.