Previous Topic Next Topic

Automaticaly transfer a line of information to another sheet

Closed
Rubel - Apr 6, 2016 at 11:27 AM
 Blocked Profile - Apr 6, 2016 at 05:08 PM
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

1 response

Answer 1 / 1
Blocked Profile
Apr 6, 2016 at 05:08 PM
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!

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Extract data from one sheet to another
phanikr -
Mazzaropi -

1 response