vba - Excel 2010 - Take whole rows from one sheet and display them in the 2nd sheet based on match in 3rd sheet -

-

i'll cut chase:

excel 2010

i have sheet1 list of orders. customer name in column f.

sheet2 contains list of customers names in column a.

i run macro / vlookup / index (whatever works) run through list of thousands of orders in sheet1 , copy sheet3 rows (whole rows) customer name sheet2 matches.

sheet1 has 10 columns , 10000 rows. sheet2 has 50 rows in column only.

i have tried few types of macros , did proper search couldn't find work. paste have embarrassment.

i might add need run weekly , list of orders changing. list of names may little frequency.

can help? :)

edit: answers far can see need use vba script. appreciate know next nothing language. should able manage modifying script suit needs need start. perhaps pseudocode make easier people:

read data a1:a50 in sheet2

compare f1, sheet1 a1:a50, sheet2

if no match - continue f2

if match - copy whole row a1 in sheet3

(...)

compare fx, sheet1 a1:a50, sheet2

if no match - continue fx+1

if match - copy whole row a(n+1) [n=number of matches] in sheet3

continue comparing rows in sheet1 a1:a50, sheet2 , return next match in an, sheet3

so far have problem returns data sheet3 only if row number in sheet2 matches row number in sheet1. also, returns sheet3, row number matching sheet1. end 1 result in row 45 in sheet3 instead of around 20 results in rows 1-20.

sub asd() counter = 1 sheets(1).usedrange.rows.count     if sheets(1).range("f" & counter).value = sheets(2).range("a" & counter).value       sheets(3).range("c" & (counter)).value = sheets(1).range("a" & counter).value       sheets(3).range("d" & (counter)).value = sheets(1).range("b" & counter).value     end if next counter end sub

thank you, pat

i believe you'll need use vba script copy entire row.

please make sure data in both sheets 1 & 2 sorted if wish use vlookup, don't think since vlookup "stop" on first hit, meaning if have customer names john on sheet1 repeats several times, vlookup pick first occurrence

regards,


Comments

Post a Comment

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

-
i'm trying apply flex button on firefox i'm having problem on chrome doesn't happens. this css: .button { display: inline-flex; align-items: center; } as can see in fiddle, "caret" word moved new line, happens if element <button> tag, <div> works expected. http://codepen.io/anon/pen/xblmgx is firefox bug or there css i'm missing? nevermind, looks "mr firefox" doesn't idea... <button> not implementable (by browsers) in pure css, bit of black box, perspective of css. means don't react in same way e.g. <div> would. this isn't specific flexbox -- e.g. don't render scrollbars if put "overflow:scroll" on button, , don't render table if put "display:table" on it. stepping further, isn't specific <button> . consider <fieldset> , <table> have special rendering behavior: data:text/html,<fieldset style="d...
Read more

html - Missing border-right in select on Firefox -

-
Image
when put select div width , padding-left, options have no border on right. more, happend if select have width 118px , parent have 15px of padding left! have idea, going on? my code: <!doctype html> <html> <head lang="en"> </head> <body> <div style="width: 1000px; padding-left: 15px;"> <select style="width: 118px;"> <option>a</option> <option>b</option> <option>c</option> </select> </div> </body> </html> and result: here plunker: click it happend on firefox on windows. tested on 40.0.2 version -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; box-sizing: border-box; source: https://stackoverflow.com/a/11390432/4431269 source of problem: https://bugzilla.mozilla.org/show_bug.cgi?id=924068 and use of google ! edit: (source of problem, explained) after rea...
Read more

python - build a suggestions list using fuzzywuzzy -

-
i building suggestion engine database. i'm using fuzzywuzzy module match user input string existing database shown below. if request.method == "get": display_dict = {} user_input = request.get["user_input"] # user input match_dict = {} food_items_obj = food_items.objects.all() # fetch objects table items in food_items_obj : match = fuzz.ratio(user_input.lower(),items.name.lower()) # try match user input existing names match_dict[match] = items.name # put 1 dictionary matched_dict = ordereddict(sorted(match_dict.items(),reverse = true)) # sort dictionary if max(matched_dict.keys()) == 100: # if exact match put in dict , return display_dict[100] = matched_dict[100] else : # if not found try best matching words.. ###########this part need help! ############# k,v in matched_dict.items(): if user_input in v : display_dict[k]...
Read more