Dynamic range based on find function

Hi,

See the attached file.

- It contains three datafeeds sheet, which pulls data from an external website. (Dutch, German, Nordic)
- DataCollection Sheet, This sheet is updates when the excel workbook is opened with the data from the datafeeds sheets.
- DataSummary Sheet is the sheet which is supposed to sort the data in the DataCollection sheet into columns. (this is the problem).

I need the fomula in the DataSummary Sheet to Find the correct value based on the data of the row and data id (eg. ENOYR-10)

At the moment I only get 0, but the error might have to do with the dates not being dates... or something. If this is the problem, then I need to convert i to dates with VBA when copying it over from the DataFeed sheets to the DataCollection Sheet.

I hope someone can give a helping hand. Thanks

Ahh thanks..

SO I can just do a replace . with , function in VBA for the K column for each time the macro runs...

Brilliant, thanks

Hi,
the dates are in fact text in both cases which shouldn't be a problem.
But your values in col K are also text, not numbers. If you replace 31.45 with 31,45 it works

Just replacing the . with a , works in Excel, however if I do the same with a macro it doesn't.

Anyone got a solution for doing it so that it is stored as a number rather than text, by using a VBA?

Maybe you'll want to post an extract of your code ( don't forget the code tags)

Below is the code that I am using, however I also need to convert it to number from text.. as this isn't done automatically when doing it with VBA.

Do I need to multiply each cell with 1?

'   Makes sure that data i column K in Sheet Data Collection, is numbers.
'   Replaces the value . in the cells with ,

    Sheets("Data Collection").Select
    Range("K4").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Replace What:=".", Replacement:=",", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False

I'm not a VBA man myself but the code works.
You don't have to multiply with 1, it will revert to a number automatically