Compare multiple cells at the same time

If you could help me with my problem anaylising multiple cells at the same time, i would be appreciated.

Here's what i mean from the code i have.

Please Login or Register  to view this content.

I've attached the sample workbook too.

13081715551.xlsm

Variable a and d will be the fixed from the first selected cell.
Variable b and c will have values from the other selected cells which i want to compare against a and d.
If you have 3 selected cells the comparision i want is cell 1 vs cell 2 and cell 1 vs cell 3 all at the same time so that the line that will be inserted will be equally distribuited.

Thanks for your patience.

Hi,

I for one find it impossible to visualise what your code is doing to your data, largely because I can't see the data.

You would be better advised to upload your workbook, manually add whatever results you expect to see after a macro (not necessarily the one you give) has run and describe in a narrative form how you arrive at the results.

Hi,

I don't understand what you mean by sort so that the time columns match. The numbers in the red columns don't seem the same in the three tables so what do you mean by 'match'

I presume you're doing something more than a trivial sort of each table but can't see what. Are the tables you present after your macro has run or before.

What determines whether the cells in any of the tables are moved down?
It originally looked like the 2nd table values were always less than the same row in the first (base) table but this isn't consistent so presumably that's not the rule.

More Qs I'm afraid.

1. Is each table , i.e. Table 2, Table 3 etc. being compared with Table 1 as a discrete process and independent of the state of any earlier Tables that have been processed.

2. If the answer to 1 is Yes, is the Table to be compared compared with the original state of Table 1 or Table 1 after it may have had additional blank rows added as a result of earlier table processes?

3. If the answer to 1 is No, what are the rules for using the previous tables in the processing of the latest table?

4. When calculating the STDEVp for the four cells in the two comparison tables, are the cells to be compared always the cell position before any previous process has added a blank row to either of the two tables being compared, or with a cell after a blank row has been added. What I mean is this:

Assuming : where T1=Table 1 & T2 = Table 2
T1 K10 vs T2 Z10 & T1 K10 vs T2 Z11 are compared.

If as a result of this comparison T1 is shifted down introducing a new blank Row 11 is the next comparison
T1 K12 & T2 Z11 vs T1 K12 & T2 Z12 (i.e. 12 being the original row 11) or
T1 K11 & T2 Z11 vs T1 K11 vs T2 Z12

Similarly if T2 Cells are shifted down introducing a new blank Row 11 is the next comparison
T1 K11 & T2 Z1211 vs T1 K11 vs T2 K13 (i.e. 13 being the original row 12) or
T1 K11 & T2 Z11 vs T1 K11 vs T2 Z12