krishhi
09-20-2011, 04:23 AM
Hi Guys,
Please check the excel sheet, I need a macro to work. where "##" should be replaces with the Column Heading in this case Heading is "RochesterNY" without last two letters i.e. "Rochester", where # should be replaces with the whole Column Heading i.e "RochesterNY".
Here is the file link:
http://www.4shared.com/file/BNHtxzak/Lawyers_data_base.html
Any help?
I have nearly 120 Columns. Its very hard to find and replace.
Waiting for your kind reply.
Thanks,
Please check the excel sheet, I need a macro to work. where "##" should be replaces with the Column Heading in this case Heading is "RochesterNY" without last two letters i.e. "Rochester", where # should be replaces with the whole Column Heading i.e "RochesterNY".
Here is the file link:
http://www.4shared.com/file/BNHtxzak/Lawyers_data_base.html
Any help?
I have nearly 120 Columns. Its very hard to find and replace.
Waiting for your kind reply.
Thanks,