Example.xlsmSOLVED ON MY OWN USING A WORK-AROUND; THANKS.
Greetings,
I'm having a hard time piecing together the macros or functions to accomplish what I need Excel to do and hope you can help. Basically, I have a list of numbers in one column on a sheet (Column A). I need a function, or macro, to take the number from cell A1, for example, look onto another sheet in the same workbook and find a match, then return the entire contents of the row to the starting worksheet (VLOOKUP will not work because of mixed cell content - numbers and names in the same cell - I'd need a way to search the cells). See the attached workbook for an illustration of what I'd like to achieve.
Thanks,
CVinje
Bookmarks