Count number of instances from once sheet and add total in another cell on other sheet

Hi guys,

I've been trying to learn VBA over the last couple of years and am having issues with my code (Which mind you is extremely noob code)

I have the following problem to solve:

- I need to take Column C (C2:C) and basically number of times years 2017,2018 and 2019 come forth as an instance in Table1 and add the total amounts into C9,D9 and E9 on Table2. (I got it working somehow but my code is far from perfect)

- I have to take Column R from Table1 (combination of orders inputted and orders confirmed) and differentiate between years 2017, 2018 and 2019 and put in the sum values to C11, D11 and E11 respectively.

-Sum of orders shipped from Column R from Table1 need to be plugged into C13, D13 and E13 on Table2 respectively.

- After this I need to differentiate between which salesman inputted and confirmed orders using Column I from Table1 and also differentiate between years and plug the values into C22, D22 and E22 and so forth.

- Number or total rows in sheet Exhibit and Stored need to be saved in H9 and J9 respectively on Table2.

I have attached along the excel file and would be forever grateful for your help!

Hi guys, I got some parts of my code working and just need hep with these 2 points, any help or ideas with vlookup would be appreciated

- I have to take Column R from Table1 (combination of orders inputted and orders confirmed) and differentiate between years 2017, 2018 and 2019 and put in the sum values to C11, D11 and E11 respectively.


- After this I need to differentiate between which salesman inputted and confirmed orders using Column I from Table1 and also differentiate between years and plug the values into C22, D22 and E22 and so forth.