Hi, I have 40 columns named 001,..., 040. They consist of up to 200 hundred NATURAL numbers. I need to create a macro that will copy values only from certain columns based on the strings I have to process (e.g. 002-040-017-023 or 009-008 or 006 etc.).
Example:
Any idea? I was thinking about selecting values based on prefix from a column where I would store all column values (with prefixes representing column names). Then the macro would remove prefixes, blanks, duplicates and sort it out values. I am able to produce everything except for the function selection column values.![]()
Please Login or Register to view this content.
Bookmarks