| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
using different sheets match string to specific work and enter that work in active
Excel 2010 VBA or Function solution
hi Guys All below in the same workbook. Starting from an empty column in a sheet called BankDownloadConvertor. Positioning my cursor in Cell D2 which is titles Company use the text string in C2 ('CALL REF.NO. 0165 , PROSPECT CONSULT , FP 18/08/11 10 , 57173104389042000N) then using a table “CompanyCategoryTrial” which is a list of all companies which does contain “Prospect Consultancy” locate/Match/Find “Prospect Consultancy” and enter it in cell D2. Don’t mind how I achieve this as I have very little hair left trying various combinations. I am as you can deduce a beginner. Here’s hoping I described my need well and you have a solution All the best Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy specific rows to different work sheets | New Users to Excel | |||
| how to enter data into different work sheets from a single interfa | Excel Programming | |||
| How to split the active sheets into two different work windows? | Excel Programming | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| I wish to save my Excell work in my work sheets | Excel Worksheet Functions | |||
Linear Mode
