Till now i have done with this simple code..
I have a Command button which calls all the bbelow three codes..
1) Clear Output1 sheet for fresh data & copy Input data & Paste in Output1 sheet
2) Sort Column F in Output1 sheet
3) Applying Subtotals on Column F & dispaly values for Column H
4) Finally Moving only data to Output sheet
But Actually it shows subtotalas & not a clear file as the "Required_Output" sheet.
Moreover i need to vlookup values from "Verify" Sheet in the output sheet...
Please suggest
Part 2 & part 3 is left.. puzzled..
please see the attached sheet
Bookmarks