Formulas or VBA?

Formulas................... in Sheet2 B2 enter

=IF(SHeet1!$A2="yes",Sheet1!B2,"") copy this across and down where
required

VBA would require event code to use the same logic to copy the info
without any formulas on Sheet2.

Post back if you want that................also provide more details on
"etc" and "some or part"


Gord

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?