Hi all,

I want to copy and paste a range based on values found in column A. The values will also be a range...so items that are between 15-2000 for example need to be copied and pasted to "sheetname1" values between 2001-5000 will be pasted to "sheetname2"

Is it best to name my range first or use another method to copy range? The range will be all information on the sheet based on value in first column.

Let me know your thoughts.

Thanks,