Dear All, Anybody help me to transfer the data from main database sheet to other sheets based on sheet name condition. i.e., The data from B6 to Q6 from main database to Another sheet A7 to P7 based on Gauge name Condition. Sample work attached.