Copying rows depending on criteria set?

  • Thread starter Thread starter forevertrying
  • Start date Start date
F

forevertrying

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Copy Row depending on an entry 1
Macro - Copy row base on criteria 3
display cell content based on date criteria 2
Automatically copy rows based on criteria 5
Satisfying two variables entered via popup 1
Pulling entire row when criteria is met. 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0

Back
Top