LinkBack URL
About LinkBacks
I am try to to copy formula values (links to another sheet) greater then 1 in column A on sheet 1 then paste the unique records to column A in sheet 2.
Thanks Nunzio
I am try to to copy formula values (links to another sheet) greater then 1 in column A on sheet 1 then paste the unique records to column A in sheet 2.
Thanks Nunzio
Last edited by Nunzio; 11-17-2011 at 09:48 PM.
Have you tried using Autofilter?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Yes but I am not sure how to copy greater then zero?
Sorry I don't follow what you mean.
Dom
Sheet 1 has link formulas pulling from the master sheet with alot of zeros so I only want to copy the values greater then zero to paste on sheet 2 using the advanced filter.
Advanced filter can only copy to the same sheet unless you define a named range for the destination cell on the other sheet and use a macro to perform the filter.
Using Autofilter you would just set up a custom option of greater than 0.
Dom
Thanks Domski
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks