I am importing data from text file and several columns get "wacked up". Is there a VBA code that would find all of the empty cells in column A and move that entire row left one cell?
I have attached a very small portion of what I mean by "wacked up". The entire sheet is 23,000 lines.
I assumed column B will have data in all relevant rows?
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Thank you Sir, perfect.Originally Posted by Arkadi
I assumed column B will have data in all relevant rows?
Please Login or Register to view this content.
Great! Glad I could help.
Also, thanks for the rep and for marking the thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks