nukeemaway
New Member
- Joined
- Jul 12, 2009
- Messages
- 34
I have one file with thousands of cells. I filtered for unique cells. Now I want to take values from another worksheet, and paste those values so that they correspond only with the unique values. For example, if I have 1,000 unique numbers spread out amongst 20,000 cells, I have 1,000 corresponding values from a different worksheet that I want to paste next to those 1,000 filtered unique values.
2) The second thing I want to do, is then unfilter those cells, and then copy each of the pasted values throughout the 20,000 values. For example, if the number "1" in my filtered data corresponds to the value "500", I then want every "1" in the unfiltered data to have a value of "500".
Any suggestions, either internal excel, or via macro?
2) The second thing I want to do, is then unfilter those cells, and then copy each of the pasted values throughout the 20,000 values. For example, if the number "1" in my filtered data corresponds to the value "500", I then want every "1" in the unfiltered data to have a value of "500".
Any suggestions, either internal excel, or via macro?