Hello,
I am trying to laterally move User IDs from Column A Column R.
Daily, the Users change (User ID: 7000, User ID: 7800), however they always start with the phrase "User ID: ".
The row location of the User IDs also change, but they are always in Column A.
Here is the code I tried. When I run it, it does absolutely nothing:
Any help would be appreciated. Thank you, in advance.
Please Login or Register to view this content.
Last edited by KSSLR; 06-12-2012 at 01:03 PM.
KSSLR,
Welcome to the forum!
Give this a try:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hello tigeravatar,
I ran this, and nothing happened. But thank you for your effort.
KSSLR,
Attached is an example workbook based on the criteria you described. It contains the macro code I posted earlier. Running that code results in the user IDs being copied to column R as requested.
Does your workbook have a different layout?
I was able to move only one User ID over, using both of our codes. It appears that it's the "User ID*" that is making things more difficult:
Please Login or Register to view this content.Please Login or Register to view this content.
tigeravatar: you are a genius! Thank you! I used *User ID* as the search term, in case there were a variable amount of spaces preceeding the User ID. There were. Your code did the job. Thanks for your help. I spent hours trying to figure this out on my own.
Hi KSSLR,
You could try:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
xladept: That was exactly what I was trying to do. Thanks!
Hi KSSLR,
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks