Hello,
I am new with VBA and i would like the following. There a 2 pivot tables each on different sheets(Sheet 2 is the database).
In Sheet 1 loop through the pivot table Column 1 and find a match in the database Column 1. When there is a match select the value of the same row only Column 5 in the database.
Now here is the tricky part when the value is selected do a calculation, lets say divide by 100 and multiple with the number in Sheet 1 Column 5 and store the value in the loop and summarize it to cell F26. Can anyone please help me.
I added a file as a example http://www.mediafire.com/file/ceg2ymj0b6tfsx6/test.xlsx/file
I am new with VBA and i would like the following. There a 2 pivot tables each on different sheets(Sheet 2 is the database).
In Sheet 1 loop through the pivot table Column 1 and find a match in the database Column 1. When there is a match select the value of the same row only Column 5 in the database.
Now here is the tricky part when the value is selected do a calculation, lets say divide by 100 and multiple with the number in Sheet 1 Column 5 and store the value in the loop and summarize it to cell F26. Can anyone please help me.
I added a file as a example http://www.mediafire.com/file/ceg2ymj0b6tfsx6/test.xlsx/file
