Extracting data from one sheet to another depending on certain criteria

[liampog]

Hi there

I have a sheet that I want two pieces of information to be extracted to a different sheet - A name and a value in £GBP.

However, I only want the name and the value to be "copied" to the other sheet when the value is over £2000.

There will be some names where the value is less than £2000, and these need to be ignored.

I'm thinking of creating a macro button that the user must click in order to "Create" the record rather than it being automatic. The create button macro would need to scan all the GBP value cells in the sheet to find if the formula equals an amount £2000 or over and if it does, then it copies the name and the value to the next available row in the other sheet.

I hope this makes sense, please feel free to ask any questions that might be necessary.

Thanks for the help,
Liam

 

[Peter_SSs]

1. What is the name of the sheet with the main data?

2. Does the 'other sheet' already exist?

3. If so,

a) What is its name?

b) Does it already contain any headings/data? If so should this data be kept or removed when the new process takes place?

4. Does this job just require looking in a single column for all values >=2000 and moving data from those rows to the other sheet?
- If so, what column?
- If not, more explanation would be helpful.

5. Are there more columns in the main sheet than just Name and Value. If so, what column holds the names?

6. What version of Excel are you using?