Hello,
I would like for your unprofessional help please
I have the bellow code... and trying to filter from sheet(3) for any rows that contain a value >30 in column F and then copy the column A and N to sheet(2)...
The problem is that I want to paste them in sheet(2) in A and B columns... and need to copy-paste all the result for the filtered >30 from sheet(3)
thank you in advance...
Please Login or Register to view this content.
Try this codePlease Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thank you for the quick reply arlu!!
your code works good... but the result is not what I need... you copy the row... and I need only A and N columns from Sheet3 to be pasted to A and B in Sheet2...
here is what I have
this seems to work good... but how can I changePlease Login or Register to view this content.
not to be restricted to row number "37144" ...Please Login or Register to view this content.
or any other better suggestion
Try thisPlease Login or Register to view this content.
arlu you are awesome
.?*??)
`?.???.?*??)?.?*?)
(?.?? (?.?Pichingualas <---
??????????????????????????
Wrap your code with CODE TAGS.
Thank those who helped you, Don't forget to add to their REPUTATION!!! (click on the star below their post).
Please mark your threads as [SOLVED] when they are (Thread Tools->Mark thread as Solved).
yep! that is great
I made a small change, because I want to copy the O column also...
so the code looks like
That was the first step of my code!Please Login or Register to view this content.
now I want to apply this formula =IF(F2<30;0;IF(F2<50;0.2;IF(F2<100;0.4;IF(F2<150;0.6;IF(F2<200;0.8;1))))) for all rows in sheets(3) place it to column "O" and then copy the corresponding values to the Sheets(2) row C...
Actually I could first run the formula and then use the above code to copy everything...
Waiting for your help
Thank you
You will have to apply the formula first and then copy the rows.
But there is a problem with the formula - you are checking if a value is less than 30 and less than 50 and less than 100, etc. What about number 20. It is less than all 3, so which value will it choose? You can try explaining what you are trying to arrive at and we can help you with the formula.
The formula is ok arlu, it only checks the next step if the previous is false.
If(condition;what to do if true;what to do if false)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks