Hello people,
I've been googling for about 2 hours without any good results... so hopefully someone can give me a hand.
I have a Excel file with 2 sheets.
Sheet(1) has pivot table
Sheet(2) has the data for that table.
All I need to do is make some script that would update data source for pivot table. In Sheet(2) only row number can change - column number will remain the same.
I have found a way to determine row number by using this:
row_num3 = Application.CountA(Range("C:C"))
Could someone give me a hand with updating pivot table with new data, when it's being added?
Thanks a lot!
BR,
Modestas
Bookmarks