Populating A Matrix from results sheet

Nobody likes my problems or am I too difficult to understand (I will explain more if needed)

Thanks
Lionel

Hi Watersev,

Thanks for responding..


1. The data is dynamic - meaning it is added too when needed - so as the program is developed it will reach a stage when the maxtrix is full that the user will
have to set a date range to populate.

1a The matrix is limited to 15 cell range either way. (I hope I counted correctly)

2. The lower left has no value recorded.

3. From the data sheet we have the 1st record and in column c we have "13. Result M" so on the Matrix under Section of rows marked TYPE F
we need to find if this value already exists if it does we move on to next step if not we find 1st blank cell in that range and input "13. Result M"
next column D from record is "DESC A" so on matrix we look in range marked TYPE C which is a range of columns and see if this value exist in this range
if not find 1st blank cell and input.

Now with these 2 values inputed we find the intersect cell and enter value 1 - if a value already exists we add 1 to that value 1+1 =2
Next from record is column F which is "15. F Cause O" and we look in Matrix range TYPE CA and 1st cell is lower end of range going up we see if value exists
here and if not find 1st blank cell going upwards and input "15. F Cause O"

Now we find intersect cell of TYPE C last entered above with TYPE CA value just entered and here we add the number value from TYPE F from that record.
If a value exists here we add a coma and input value beside not add too.

Now next column G from record with this value we find the 1st empty cell in TYPE D range on matrix which the range goes from right to left and input here, if value exist we
move to next step and with intersect of these values from TYPE CA and TYPE D we add one to cell if value already here we add to value 1+1 =2

The cycle on matrix is anti clockwise on entering data.

I hope I haven't lost you.

4. The matrix I believe should be populated on viewing matrix either sheet activate or macro button to view sheet.
that means a clean start every time it is viewed.

As for the range being filled to being full I would like the code to halt and ask the user to select a date range and the user to restrict range if full.

Thanks
Lionel

Hi Watersev,

Mate, that is just wonderful.

I am going to give it a going through to understand what is happening and get back to you.

I really appreciate your help. (Some really good blokes on this forum)

Regards
Lionel

Hi watersev,

Thank you for responding.

After giving the code a run I find that if in column C (TYPE F) we used the last same letter on a different number the code will ignore that data.

The determining factor of column c (TYPE F) is the number preceding the data. But the data is always the same for a particular number.
The same is for any column that has a number preceding it.

The following applies
Column C (TYPE F) a number followed by data but always same data after the same number.
Column D (TYPE C) the description of a part, is a range of data but can be used more than once. eg. Bearing, Guide, Bolt, Bearing, etc

Column F (TYPE CA) same criteria applies as in Column C
Column G (TYPE D) same criteria as in column D

The data used was dummy data to give an example.

Sorry if I mislead you.

Thank You watersev

This is looking very good mate.

Can I ask you to add a date range function to allow the Matrix to populate from between start date and end date.

This would allow full access to data if it holds quite a few records.

I am looking at autofit columns for Column S to AG.

I really do appreciate you guys sharing your knowledge and it is helping me learn from a different angle.

Thanks
Lionel

Hi watersev,

You have helped me greatly mate.

Last part of my assignment is populating some more data.
Please check attached for further explanation.

My learning curve has gone thru the roof in the last week or so.

Thanks
Lionel

Thank you for latest update.

I encountered error on 1st run, just had to declare Causechk as string

Could I ask that the CAUSE A TO E be fixed if no value, in order (That is Column AI to AM on results sheet)

Regards
Lionel

please check attachment

Thank You kindly.

I will give it a whirl

Regards
Lionel

Hi watersev.

Very happy with your efforts mate.

Everything is looking good.

I will let you know how it goes.

Regards
Lionel

Hi watersev,

Went well after adapting to original data.

Is it possible to list only the data that fits onto matrix and indicate last record used to fit onto matrix.

Regards
Lionel

Thank you once again.

Will check with original data and post back.

Lionel

Sorry for posting back late.

Everything works perfectly.

Thank you for your time and effort.

Lionel