I have few cells in Sheet 1 with some values selected from the drop down list.
Ex:
Cell No: 3
DropDown1: ABC
DropDown2: CDE
DropDown3: FGH
Dropdown4: IJK
And have a command button in sheet 1, when selected it,
The data in sheet 1 should be used in Sheet 2 like below,
1) 'ABC' is first 3 characters
2) 'CDE' is second 3 characters
3) 'FGH' is 3rd 3 characters
4) 'IJK' is the next 3 characters
All 4 lines should be displayed within a single cell, that is in cell A3 as 3 is selected as cell No in sheet 1.
How to use macro to perform the above operation?
Bookmarks