automaticaly transfer a line of information to another sheet Closed

Question

Hello, 

HI, 

I have a workbook that has 2 sheets, on sheet 1, I have 22 columns with different information, on sheet 2, I would like to automatically transfer the whole line of information to sheet 2 based on one criteria being met in one of the columns on sheet 1. 

I know nothing about working with VBA or Macros

Configuration: Windows 7 / Internet Explorer 10.0

ac3mark · Answer

OK, just put a link on sheet two that references the cell in sheet 1, as in =Sheet1!A2.

Are you familiar with the If(logic_test,true,false)?

SO, it would be like:
=If(somecell="this is a test",Sheet1!A2,"")

Have fun!

Automaticaly transfer a line of information to another sheet

1 response

Similar discussions

Subscribe To Our Newsletter!