The formula works a treat, very simple, thanks. One more question, by autofilling yes/no, is there a way where all the information on that row could be copied as well if the result is yes?

If i give you an example, below is sheet 1:

Required Supplier Description Amount
Yes Lets get branded 5000 shopping bags 3549
No Media Pool 200 t-shirts 5000
No Lets get stranded 1000 folders 3549

So that all populated cells in row 2 would be copied over to the sheet 2 as 'Yes' was used. Is this possible?



On Thu, 5 Jan 2012 12:57:01 +0000, dvp
wrote:


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?[/quote]