How to check for similar headers remove/rename

April 28, 2016 at 10:46:10
Specs: Windows 7
I am exporting information from different versions and schematics of a program in tab delimited text that will be imported back into the schematic.

Over the years/versions some of the header information has changed slightly. I need to search for the preferred header, if it exists I want to keep it (do nothing) but remove the other similar headers. If it doesn't exist, I would like to search for the similar name and rename it if it exists.

I need to code Excel VBA to do this as I am automating a series of steps so that users will be able to process a file and save to Tab Delimited file easily.

The preferred header has an underscore in the name. PL_Position vs. PL Position


See More: How to check for similar headers remove/rename

Report •

#1
April 28, 2016 at 18:13:45
What do you mean by "header"?

Header as "Header & Footer" or Header as in "Column Header"?

You said:

...if it exists I want to keep it (do nothing) but remove the other similar headers.

and then:

PL_Position vs. PL Position

"Other similar headers" implies that there may be multiple headers to remove, yet you only gave one example.

I think we need some more details before we can offer any suggestions. Please keep in mind that we can't see your spreadsheet from where we're sitting, so you need to supply as much detail as possible about your layout, etc.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question