![]() In this example, I'd only want Annie MacDonald and Sam Jones. I'll copy only the row data matching anyone in that list of 10 names. The function should be aware of this list. The names in column AK will change from day to day but the list of names is limited to 10 different known names. But Microsoft's examples don't fit the bill.ĭo I need to create a lookup_array? Can anyone point me in direction with great Xlookup examples? I'm familiar with building macros, but having trouble determining which Function(s) might best perform this job. I'm building a macro to copy data rows matching ONLY those Contact names I've listed in column AK. The column header never changes, it's AK. The column data I want to match on is composed of Sales Contact names. ![]() I want to copy row data that matches specific column data.
0 Comments
Leave a Reply. |