Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trying index match
I am trying to find a way to do this:
The boss has a master sheet of products he requires from different suppliers, once he has selected what he wants, he will go throught the list and give PO numbers, there are times the same PO number will be on several different rows, because it is from the same supplier, when he is ready to print out his PO , I have it set up so he can just click a button, a userform pops up asking for the po number he wants.he presses ok and the macro starts, Now from here it gets quite clumsy. on another sheet I have the formula, something like this, =IF(Sheet1!H1=po,Sheet1!A1,0),there is about seven columns of this formula going down for many rows(as many as spreadsheet 1) Then the macro sorts the sheet and the top ten rows end up on the actual PO sheet( I have never seen more than 5 required I chose ten just to be sure. I can get index,match for one; what do I use to find all of the PO's number rows and have them inserted into the actual PO? Dave |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trying index match
Hi Dave
I would use Advanced Filter to pull the data required across onto the PO sheet for printing. Take a look at Debra Dalgleish's site for information on how to achieve this. http://www.contextures.com/xladvfilter01.html#ExtractWs Regards Roger Govier damorrison wrote: I am trying to find a way to do this: The boss has a master sheet of products he requires from different suppliers, once he has selected what he wants, he will go throught the list and give PO numbers, there are times the same PO number will be on several different rows, because it is from the same supplier, when he is ready to print out his PO , I have it set up so he can just click a button, a userform pops up asking for the po number he wants.he presses ok and the macro starts, Now from here it gets quite clumsy. on another sheet I have the formula, something like this, =IF(Sheet1!H1=po,Sheet1!A1,0),there is about seven columns of this formula going down for many rows(as many as spreadsheet 1) Then the macro sorts the sheet and the top ten rows end up on the actual PO sheet( I have never seen more than 5 required I chose ten just to be sure. I can get index,match for one; what do I use to find all of the PO's number rows and have them inserted into the actual PO? Dave |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trying index match
thanks I'll check it out
Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Index | Excel Worksheet Functions | |||
Match or Index Question | Excel Worksheet Functions | |||
Match & Index | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |