Is it possible to filter data and then sum data and populate in another workbook?

[SCPbrito]

I have a large data set with varying numbers of rows but same columns. Is it possible to filter data by a certain status in Column B and then sum the Qty in column G and have it populate in another workbook?

 

[Peter_SSs]

Is it possible ..

It should be but are you wanting to do this ..

1. Manually?
2. By formula?
3. With vba?
4. Using Power Query?

Also, does the "other workbook" already exist?

Depending on the responses to the above, there may be more questions following.

 

[SCPbrito]

I want to do this with VBA., and yes the other workbook exists.

 

[SCPbrito]

Correction: I want date to populate in another sheet in the same workbook

 

[SCPbrito]

I figured it out using formulas. Thanks anyways

 

[Peter_SSs]

I figured it out using formulas. Thanks anyways

Thanks for letting us know.