I am working on an inventory system and need some help retrieving data from a worksheet. for the purpose of this post i will say i have 3 columns of data. A , B , and C. In column A i have a name. in column C i have a number. (Column B is irrelevant) When i run my one macro it will highlight all the values in column C that are less than or equal to 5 (lets say). In a separate worksheet i want to be able to run another program/macro that will find all the values highlighted in column C and copy over JUST the name from column A. i know there is no function to specifically look up the cells based on colour. Any suggestions? this is just to save me some time from copying everything from one work sheet to another