I have an IF function that automatically pulls items from one tab and drops it in another =IF(COUNT(SEARCH("T",'Risk Assessment'!D8)),'Risk Assessment'!A8,""). This sheet goes from A-R and 2-64. The problem is there are multiple spaces between some of the cells. Is there a way to have this tab automatically sort itself and remove the blank cells?
Attached is an example.
Hi.
Try
Please Login or Register to view this content.
Last edited by marreco; 04-26-2014 at 10:28 AM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Whow !
Needs 4 lines only with a For loop …
Thanks for the post. I tried entering the code and it came back with a compile error. When it comes to code, it's out of my realm of knowledge
Thats assuming I am doing this right. After I copied and pasted I hit run code, which is where I received the compile error.
Try to change [A1] key to [A2], must be in sorted range … And so on for next lines …
I just hope that columns are independant from each others …
Hi.
works well for me.
see file
Weird. When I copied and pasted from your excel sheet it worked perfectly. Thanks for the help and quick response!
Hi i'm Glad to help you, mark you post solved, please.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks