Okay, I want to click on one cell, take the text from the cell next to it (let's say it's ABC-123), and use that text to search for matching text in a certain column in a closed workbook. If ABC-123 exists in the searched column, I want to insert a row below ABC-123, copy the information in the row containing ABC-123 in the closed workbook, and paste this in the inserted row.
I can already click on the cell, obtain the text from the cell next to it, do a few other things, and insert rows. My problem is searching and obtaining information from the closed workbook.
And as a background, the open workbook is 151 KB of pure data and the closed workbook is 127 KB of pure data, so my laptop isn't a huge fan of copying all of the data over.
Any help would be great.
Thanks!
I can already click on the cell, obtain the text from the cell next to it, do a few other things, and insert rows. My problem is searching and obtaining information from the closed workbook.
And as a background, the open workbook is 151 KB of pure data and the closed workbook is 127 KB of pure data, so my laptop isn't a huge fan of copying all of the data over.
Any help would be great.
Thanks!
