Copying rows depending on criteria set?
 

Hello,

I have a main database of information for tracking orders at their relevant
stages. I use this sheet to total up different stages of payments.

Now I want to be able to copy some of this information into another
worksheet at the moment I enter a certain criteria.

For Example:

My main database has 8 headed columns of information.

If I were to enter the number 156 in the eighth column, I want it to copy
the cell from the 3rd, 4th, 5th, 6th and 7th in that row into a new worksheet.

Is this possible, and is it possible that you can reply in completely basic
excel talk. I have tried reading some other comments on this but I'm not sure
what is meant by coding.
Thank you in advance

Copying rows depending on criteria set?
 

Give me your email and i can email this soloution

"forevertrying" wrote:

Hello,

I have a main database of information for tracking orders at their relevant
stages. I use this sheet to total up different stages of payments.

Now I want to be able to copy some of this information into another
worksheet at the moment I enter a certain criteria.

For Example:

My main database has 8 headed columns of information.

If I were to enter the number 156 in the eighth column, I want it to copy
the cell from the 3rd, 4th, 5th, 6th and 7th in that row into a new worksheet.

Is this possible, and is it possible that you can reply in completely basic
excel talk. I have tried reading some other comments on this but I'm not sure
what is meant by coding.
Thank you in advance

Copying rows depending on criteria set?