hi all..
i have several sheets (sheet a, sheet b, sheet c. etc...) in one file ..i want extract data only cell B4,B5,B6,H42,H43 and H44 into one sheet based on the same name header....
this my layout :
Excel 2007ABCDEFGH1LAND OF REPORT2JAYA CORPORATE34Name ofBulding A5Code ofXXXX6Address...