View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
nathan_savidge nathan_savidge is offline
external usenet poster
 
Posts: 30
Default 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