Combining data leaving out blanks
Hi
Can you pls help me out with the following issue. You'll find a file in attachment.
The red field shows you the data I have. The green field shows you what I should get too.
I'm really stuck on this one and my boss expects a solution asap.
Kind regards
Tino XXL
Last edited by Tino XXL; 12-07-2010 at 11:59 AM.
Hello friend,
I started working out an answer for you but encountered a problem myself. Here is two different macros that should do around the same thing and should work. Only problem is that when i run it on your workbook it will not delete and shift up all the rows, just some of them. Maybe someone else here can weigh in.
Please Login or Register to view this content.Please Login or Register to view this content.
one of the options to make it
Press Start
1. empty all 'empty looking' cells in column B
2. Use
PS. Trek je niet teveel van die bazen aan....Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks