![]() |
#1
|
|||
|
|||
![]()
Hi all,
I have a file with multiple sheets having the same information in Column B and C. Not sure if the RIGHT Function is the most appropriate function to accomplish this task. In Column B, from B4:B98 I have the following accounts in the following format. B4: AF-600-51000 B5: AF-600-51001 . . B98: AF-600-51098 in Column C, same range (C4:C98), I have the names associated with the accounts C4: Unit Name C5: Promotions . . C98: Other CC The macro should be able to get the last 5 digits from Column B and combine it with the text in Column C and put the end result in Column A using the same range (A5:A98). For example, in cell A4 (and so on) will look like this: A4: 51000 Unit Name A5: 51001 Promotions . . A98: 51098 Other CC My end goal is for the macro to be able to do this for 16 sheets in the file. As always thank you for your assistance and cooperation. Cheers! rsrasc |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
officeboy09 | Excel | 13 | 08-09-2021 12:59 PM |
Adding a function to this macro: | JohnGanymede | Excel Programming | 6 | 12-22-2017 02:57 PM |
How do you write a macro with an IF Function | Scheuerman1987 | Excel | 5 | 06-05-2013 06:04 AM |
Macro or user function to Extract row height | Catalin.B | Excel | 12 | 06-22-2011 09:21 AM |
![]() |
pawan2paw | Excel | 1 | 06-04-2009 12:28 PM |