Home » Forums » Open Source Learning Center » Question and Answer

how to insert a formula that can take info from sheet 1 to sheet 2 but under conditions.

Submitted by karim.zheng on 30 October, 2015 - 12:52

greetings everyone. i need help to copy specific info from sheet1 to sheet2. its hard to explain by typing but ill show it through the attachment. many thanks.

AttachmentSize
Book1.xlsx14.82 KB
‹ extra data into excel from websites that require a login Rearrange Data from Sheetl to Sheet2 ›
»

u mean calculation on sheet 1

Submitted by katak101 on 30 October, 2015 - 14:14.

u mean calculation on sheet 1 and result copy at sheet 2?
so sheet 2 will not appear the calculation right?

»

if im not wrong, you just

Submitted by katak101 on 30 October, 2015 - 13:03.

if im not wrong, you just right click at sheet 1 and click 'Move or Copy'. after that, tick the box 'Create the copy..'

hope its can helps.

»

emm i dnt mean copy paste see

Submitted by karim.zheng on 30 October, 2015 - 13:06.

emm i dnt mean copy paste see the attachment its like conditional informations from sheet1 to sheet2

»