Hi
I am trying to do a sumproduct as a dynamic vba code but I cannot get it to work.
I'd use XL2BB but i'm on a work computer so i can't install anything, so attaching picture for some clarity.
This is for an order form and the reason i want it dynamic is because the number of rows changes depending on what supplier i'm ordering from.
Column B is empty and filled by me, Column C is already filled in and done.
I made a macro to clean up the spreadsheet but this is so far the only thing i cannot get to work, hopefully i'm making sense.
I am trying to do a sumproduct as a dynamic vba code but I cannot get it to work.
I'd use XL2BB but i'm on a work computer so i can't install anything, so attaching picture for some clarity.
This is for an order form and the reason i want it dynamic is because the number of rows changes depending on what supplier i'm ordering from.
Column B is empty and filled by me, Column C is already filled in and done.
I made a macro to clean up the spreadsheet but this is so far the only thing i cannot get to work, hopefully i'm making sense.