Need help in in syntax to add formula to an existing formula

[tony0710]

Hi

Thanks to all that have helped me from the forum so far. I need a bit more help - I've got:

Please Login or Register  to view this content.

In which the second part of the code i.e. from Dim Cell - populates column "G" with the unique user input value from Col "A" and then the total (using the SUMIF) is populated in Col "H" for the corresponding unique value.

The other codes that I have are:

Please Login or Register  to view this content.

These drag the values from my reference page, based on my Target.value from Col "A"

So the question is - what is the correct syntax - to combine the formulas to:
populate col "G" and "H" using the Dim Cell, then use the application.index formulas to relate to the unique value in col "G" and populate Col "I" and "J"? Is it just a case of changing "Target.value" in the application codes?

I.E.

Col A - User input
Col B - date of input
Col C - qty of input (defaulted to 1)
Col G - Auto list of unique values of col "A"
Col H - Sumif values
Col I - application to index/match range $K:$K from ref page based on value in Col "G"
Col J - application to index/match range $B:$B from ref page based on value in Col "G"

All help will be much appreciated.