Hello,
I have a two excel files
1. File One contains names in one column
ABC Company
BCd company
XYZ company
2. File Two contains data in several columns and rows.
Mobile Number Company Name retailer name
88998798 ABC Company popiiii
98798989 BCd company rettetetet
56656565 XYZ company tetetett
My aim is to search the text string from the range of names in file one and search the same text in second file then copy the entire rows where the text string is matching and paste it as a different file with the same search string/Name.
Eg: Searching abc company in data base file then copies all rows where abc company is available in any column any cell. End result should be copying the data 88998798 : abc company : popiiii the same row left to right and saving the copied data as a different excel file named abc company in specified path or folder. Also heading should also be copied with the specified data while saving it as a different file. Thanx
.net 2.0 excel format column Compare excel sheet columns if formula Excel 2007 macro moves entire row to another worksheet next available row Excel 2007 vba copying a range of cells Excel add up columns that match certain column heading Excel create a list of unique two columns Excel macro copy then move down one line Excel macro find last row on sheet1, copy range, and paste to sheet2 Excel macro get data from other file Excel macro select columns Excel macro that copies and inserts a row Excel match columns from two spreadsheets Find duplicates in excel two columns How to copy a row of cells to another column in excel 2007 Microsoft excel macro example row cell Row columns excel Select row column cell vba excel Vba excel find column label