Am new bie looking for the solution.
I have sheet1 and sheet2 details : Need to filter and paste in respective sheets:
Sheet1 : Filter A column for : "A","B","C","D" copy an paste in respective sheets:
Copy Column A : paste in Sheet A : A column row startes from 4
Copy Column B : paste in Sheet A : E column row startes from 4
Copy Column C : paste in Sheet A : G column row startes from 4
Copy Column E : paste in Sheet A : M column row startes from 4
same it has to paste in all sheets respectively
Sheet2 Filter B column for : "A","B","C","D" copy an paste in respective sheets:
Copy Column B : paste in Sheet A : A column row startes from 4
Copy Column C : paste in Sheet A : M column row startes from 4
Copy Column D : paste in Sheet A : E column row startes from 4
Copy Column E : paste in Sheet A : G column row startes from 4
same it has to paste in all sheets respectively
Control check sheet need to use pivot table.
Much appreciated for your help ( it will more helpful for us the calculation point of view)
I have sheet1 and sheet2 details : Need to filter and paste in respective sheets:
Sheet1 : Filter A column for : "A","B","C","D" copy an paste in respective sheets:
Copy Column A : paste in Sheet A : A column row startes from 4
Copy Column B : paste in Sheet A : E column row startes from 4
Copy Column C : paste in Sheet A : G column row startes from 4
Copy Column E : paste in Sheet A : M column row startes from 4
same it has to paste in all sheets respectively
Sheet2 Filter B column for : "A","B","C","D" copy an paste in respective sheets:
Copy Column B : paste in Sheet A : A column row startes from 4
Copy Column C : paste in Sheet A : M column row startes from 4
Copy Column D : paste in Sheet A : E column row startes from 4
Copy Column E : paste in Sheet A : G column row startes from 4
same it has to paste in all sheets respectively
Control check sheet need to use pivot table.
Much appreciated for your help ( it will more helpful for us the calculation point of view)