Hi all,
Hope everything is good.
I just recorded a macro and I need help from you guys in editing this program.
Steps that are followed:
1) Insert a new column beside (Just for my convenience, I call the new column name as Temp column) Column B.
2) Use "TRIM" command.
3) Drag it till the end of the row.
4) Paste the obtained result as Values.
5) Again Insert new column just right side of Temp column.
6) Use "LEFT" command (Number of characters taken as 6).
7) Drag it till the end of the row.
8) Paste the obtained result as Values.
9) Delete 'A' column & Temp column.
My Requirement is, last row number (Here, the last row is 355 but it will change everytime) will be changing everytime and I want that to be identified automatically and perform the above steps that are mentioned.
Can anyone help me on this ? Thank you for your patience in reading this request.
Recorded Macro:
Thank you in advance.![]()
Please Login or Register to view this content.
Raju
Bookmarks