VBA coding

[Aberdham]

Hi there,

I tried to combine sheets with different columns to a new sheet. and ran the code. but it says user-type not defined.

following link to the workbook: https://1drv.ms/x/s!Aqt4VfikFsyKdP__4BbJF1LMxlM

could anyone help me to run a debug?

Thank you in advance !

 

[mumps]

Re: Formula split and update master tables into sub tables(product) - Aggregate/replace

Since the changes are the result of a formula, the changes to the 2 master output sheets is automatic. When you change the data in the sheets that the formula refers to, the formulas automatically update the appropriate cells in the 2 master output sheets so it's impossible to check whether the data has changed.

 

[Aberdham]

Re: Formula split and update master tables into sub tables(product) - Aggregate/replace

are you referring that we should start from the beginning to use VBA to do the transfer to the output sheets?

 

[Aberdham]

Re: Formula split and update master tables into sub tables(product) - Aggregate/replace

for example, this time we transfer until 300 rows... and next time we ran a double check and copy the new one and then transfer to the respective sheets? would that be possible?