By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,384 Members | 714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,384 IT Pros & Developers. It's quick & easy.

VBA Excel If function

P: 1
Hi there,

I have an excel spreadsheet with 2 sheets. On 1 sheet i have a list of cars with the prices on. The other sheet has the cars that have been sold on it.

If a car has been sold i enter SOLD in the price cell.

What im trying to achieve is when i click a button if there are any rows that have the word sold on them they move to the new sheet.

Is this possible and how?

Thanks

Ben
May 4 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.