Hi there,
please see the screenshot. I've added 200 rows of data (Series 1-200), each row with multiple columns of data.
I'd like to rename each of the 200 series to the specific customer names, rather than just 'Series 1' ...'Series 200'.
There is a separate column (in a different work sheet) with all the customer names. How can I batch-rename
all 200 Series, rather than editing each single Series Name by hand?
Thx a lot,
George
Are the customer names you are looking for, in that other worksheet, listed with the series? If so you could just use an Index(Match()) type of formula to bring in the names to the 'destination worksheet'
if you need help doing that kind of thing, you will need to upload Excel examples (exactly the same process as attaching the images, but pick excel files instead!)
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Hi there,
please see file attached.
I'd like to have 'customer 1'....'customer 117' assigned instead of 'series 1' etc.
How do I do that, other than all manually?
Thanks a lot,
Georg
Anybody who could help me on this?
THX
Georg
Hi Georg,
This code will achieve your goal:
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks