Hi, I get this data from a source which is not captured in order, cell values gets jumped to next adjacent cell. Refer the "AS IS" tab.
I would like to copy the cell values from J (row 2), L(row 5) and P (row 6) to column H. Once cell values copied delete the blank columns. "TO BE" tab shows how it should look once it's completely cleaned up.
I tried to record the macro however it's not of much help, was having a look at "offest" any help here would be really appreciated!! Thanks
Hi,
Try this code :
Regards
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
awesome!!, this does the magic!! thanks for your help.
not sure how to give reputation points though
Or you may try this.......
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
You are welcome.Originally Posted by raghunaik
To give reputation points to someone, look at the left area of the screen, there is a star shape button with "Add Reputation" text right to it for each post.
Choose the person you want to give the reputation points, click this star shape button, then click the "Add to reputation" button.
Regards
FWIW:
Please Login or Register to view this content.
FWIW:
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