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
|