Master sheet to All Base range

[kannan1847]

I Have Data sheet
which contains sheet name "Item"in that sheet based on Item column, I need to Filter the Data in "Master Sheet" and copy paste to the specific sheet name automatically- and below that Total the Amount.

The Master sheet data may modified...so again run the program all sheets to be cleared and Modified data to be filled

[Alf]

Why don't you use the pivot data in the hidden sheet2?

Alf

[kannan1847]

Its not work

[Alf]

Try this then. In order to test run macro "FilterSplit"

Alf

[kannan1847]

How put total for F,G,H,Column where details to be include

[Alf]

As you uploade file don't have any data in column F, G, and H I don't know what you wish for but as the macro contains total for column E you should have no problem modifying it to your new needs.

Alf

[kannan1847]

ok I work and let you know ....thanks for the effort

possible mention code to extend total to h column