Look up a range of cell values and extract matches

[glynn1969]

Hello and hope you experts can help.

I am new to world of macros but have just how powerful they are when used correctly.

On sheet 1 I have in column A a list of invoice numbers from 1 to 100 (which may contain duplicates). On sheet 1 column B I have associated invoice value....with more data in columns c to AZ.

On sheet 2 column ZZ (in column zz. so theyre. hidden a bit) I have a range of invoice numbers, let's say...1,22,43,47,56,78,88. And on sheet 3. in column ZZ I have invoice numbers 2,35,38,57,59,79.....this pattern continues across multiple sheets covering all 100 invoice numbers.

Is there a vba code that will allow me to extract all data from sheet 1 into the relevant sheets in the workbook based on the ZZ column.

Hope you can help as currently doing manual filter taking me hours.

Thanking you for any guidance.

 

[oldbrewer]

On sheet 1 I have in column A a list of invoice numbers from 1 to 100 (which may contain duplicates). On sheet 1 column B I have associated invoice value....with more data in columns c to AZ.

On sheet 2 column ZZ (in column zz. so theyre. hidden a bit) I have a range of invoice numbers, let's say...1,22,43,47,56,78,88. And on sheet 3. in column ZZ I have invoice numbers 2,35,38,57,59,79.....this pattern continues across multiple sheets covering all 100 invoice numbers.

Is there a vba code that will allow me t

pretend sheet2

pretend sheet3

pretend sheet 1

inv001

44

inv002

47

inv009

68

inv002

47

inv008

65

inv006

59

inv003

50

inv003

50

inv001

44

inv004

53

inv005

56

inv005

56

inv006

59

inv007

62

inv008

65

inv009

68

formula finding 47

against invoice 2

=OFFSET($A$11,MATCH(G12,$A$12:$A$20,0),1)

if there are two inv 005 in above list do you want too bring across the total ?

<colgroup><col><col span="13"></colgroup><tbody>
</tbody>

 

[glynn1969]

Hello, thank you for looking at my query. I would actually like both inv05 to pull across in two separate lines. Hope this helps

 

[glynn1969]

Hello, thank you for looking at my query. I would actually like both inv005 to pull across in two separate lines. Hope this helps

 

[oldbrewer]

not sure how to - see if somebody else steps in -