Hi
i am new to VBA and have cobbled together code from various sources to perform various tasks at the NFP i work at.
We collect reams of textual information through a call centre and in the process of sorting through 150 column vs 1000 row data I find the need to change my simple Macros column references regularly for additional fields being added.
Anyway in the following code Sheet A is the master with all the records hence the row count
I search in Columns L ,V and DG for a string "DDD"and again "EEE" and post the resultant row in an alternative sheet.
i would like to reference Column headers (eg named ONE COL, FIVE COL and EIGHT COL) rather than each individual column by a loop
I would also like to reference the strings "DDD" and "EEE" I am searching as well by a loop so as I can minimize the code
The following code is an abridged version of what is miles long, to demonstrate. Any assistance would be most welcome
Please Login or Register to view this content.
Bookmarks