Previous Topic Next Topic

Automaticaly transfer a line of information to another sheet

Closed
Rubel - 6 Apr 2016 à 11:27
 Blocked Profile - 6 Apr 2016 à 17:08
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

Réponse 1 / 1
Blocked Profile
6 Apr 2016 à 17:08
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

Extract data from one sheet to another
phanikr -
Mazzaropi -

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

30 responses