Index match table mid text file in a macro

[torresy01]

I have a table with 2 columns - one a description and the next a 3 character code.

I want to add a macro to an existing macro that will lookup a portion of a cell in my working file and find the closest match to what is on the table then have the macro copy the corresponding 3 character code to the working file. Can someone assist, please.

If the item is not on the table I want to be able to add it to the table. So the table needs to expand as items get added.

[alansidman]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[torresy01]

I have attached the files:

Pull and Match Test files are three separate files:

1. Create a Macro that generates the pivot tables for SUM PT and CAT
2. Create a Macro that will Match the Line item description from the table to the working file "Pull and Match Test" and place the match on column AB.
3. Create a Macro that will create the orange section automatically.

I am unable to find my personal macros. So all of my work so far is lost. Do you know how I can recapture what I had in my personal macros?

[torresy01]

I have a new macro that will pull the files from my directory and create one new file, however, it puts the data into separate worksheets. I need them to be cumulative so I need the macro to recognize an end of row which is where the next file will start. Here is the macro I am using:

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)