Autofill data from one tab to another under certain criteria

[dvp]

I enter customer details onto an excel 2010 spreadsheet, ie customer name, date, description of order, amount of order etc. Sometimes, under certain criteria, the same or part of the same information needs to be added to another tab, ie tab2, on the same spreadsheet. I wanted to create an automated system to populate tab2, but cant figure out how.

I thought about creating another column in tab1, before all the customer information, which had a dropdown list option for yes/no when asked the question 'does it fit the criteria to add customer information to tab2'. This column would act as an alert, so that if i selected 'yes', then any customer information i enter in tab1 would then populate into tab2. But I dont know how to do this, can anyone help?

 

[james_mcdonald]

I tried the example above and it show "1" in the cell, not the "Yes" from tab 1.

 

[Derek Brown]

What is the formula in the cell (tab 2) that is giving you the "1" instead of "Yes"?
What is the column header for the column (tab 1) where the "Yes" is being found?

 

[Derek Brown]

It is not intended that the data in Column A on Sheet1 is copied to Sheet 2.
On Sheet 2 Column A contains an "index" to the rows on Sheet 1 (counting from the second row), so a '1' in Column A on Sheet 2 indicates that Row 2 on Sheet 1 is required.
Once everything is set up you would normally hide Column A on both sheets.

 

[james_mcdonald]

I was able to figure out on the example. I am attempting to use this on a pretty large workbook. I move the reference to point to search "Legal" in column "N," and the formula errors out.

 

[james_mcdonald]

I finally got it to work. Not sure how, but something changed. Thanks for your help!

 

[Derek Brown]

Thanks for letting me know that you have got it working OK now.

 

[beejays]

I have stumbled across this thread and i am trying to achieve a similar thing in my spreadsheet.
In sheet 1 I have data in starting in A3 and going across to column Y.
In column N it has either "financed" or "freehold" and I would like to autopopulate the data into sheet 4 if it is "financed".

Can you please advise which parts of the formulas I need to amend to achieve this??