Hello Experts
This code is running without error but I am facing 2 issues. 1.Not able to get the formula right in column AA. and 2. The seond filter is deleting all the rows of check sheet which is incorrect. I need your help to check what is wrong in the code. These are the lines in 2 different places connected to the issuse.
Thank you in advance.
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by RAJESH SHAH; 05-01-2023 at 03:50 PM. Reason: #Solved by John Topley
"There is nothing called problem, it's just absence of an idea to find*solution."
?I have not failed. I?ve just found 10,000 ways that won?t work.?
?Thomas Edison
What are Z and C ???
perhaps
Please Login or Register to view this content.
Last edited by JohnTopley; 05-01-2023 at 03:28 PM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Invoice Number containing Numbers and text
If it is not a problem then I can share a sample sheet.
Did you step through the code to see which column is getting filtered?
Not once but many times. The second filter which I shared is deleting all the rows.
Which column is getting filtered?
Oh Yeah. Column 26 but if the issue one is rectified then it will display some values and the auto filter will filter that value. Right now the column 26 is displaying 0 in all the rows as the formula is not working right.
Which column letter are you trying to filter on?
Filter column Z
Please Login or Register to view this content.
Corrected now it is column 27 (AA). As I am not getting any values in that column I am not able to get the filter value of Matched to recheckOriginally Posted by johnnyL
Please Login or Register to view this content.
Did you try what @JohnTopley posted in post #2?
Both the issues are solved with your formula John Topley. Thank you very much.
You people are pro. without a sample file you solved the issue.
Sorry. John Topley. I am not able to give you Rep+ for the formula. As usual, It is asking to spread some reputation around....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks