Modifying a Macro to trigger automatically & function across the column

[PritishD]

Hello Excel experts,

Need your help with modifying an excel macro. Also note that i do not have any knowledge about macros.

Kindly refer to the attached excel sheet, which has the excel macro. It also displays the Input and output on running the macro.
I require the following help from your end:

1. The macro should function for all input present throughout the column. And should also ignore blanks.
2. Secondly, it should get automatically triggered. Suppose if the valve in the cell KM2 says TRUE this macro should start functioning for the sets/pieces of texts in Column KP (starting from KP7 and uptil the end of the column) and give me the result in the column KS.


Furthermore, if i wish to modify it in terms of what column it should take the input and where to display etc. What changes should i make?

Please write back to me, in case anyone requires additional information from my end.

Thanks!

[LJMetzger]

Hi PritishD,

I hope I implemented your requirements correctly. There are constants (items in red below) that can be modified to allow you to put your data anywhere you want.

In the Sheet1 Module:

Please Login or Register  to view this content.

In Module1 (to replace your existing code):

Please Login or Register  to view this content.

To access a Sheet Module in VBA:
a. 'Left Click' on any cell in the Excel Spreadsheet.
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. 'Double Click' on the module you want to access in the 'Project Explorer'.
e. Insert code into the module if needed. 'Option Explicit' should only appear ONCE at the top of the module.

Lewis