Dear experts,
Is there a way to create multiple names in batches? For example I have 200 names (single cells) in column A ending with "Case1", I want the same names in columns B, C, D onwards ending with "Case2", "Case3", "Case4" etc..
A copy and paste followed by replace all would be ideal, but I figure I cant do that for names and any help or suggestions would be highly appreciated.
Thanks,
Aloisio
You'll need a macro for that.
You sayThey can't have all the same name. What do these names start with?I have 200 names (single cells) in column A ending with "Case1"
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Thanks for the quick reply Tsjallie.
In each row I have a different name, such as "Production_Case1"; "Revenues_Case1"; "Opex_Case1" etc..
And I want all of that ending with Case2 in column B, for example..
Can you upload the workbook or a screenshot of a relevant part of the sheet.
Prefer the workbook, of course
Last edited by Tsjallie; 04-19-2017 at 03:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
aloisiomf 
Register To Reply
Bookmarks