Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default formula needed to bring values to another sheet

i have a data list which indicates p.o. numbers in one column and the next to
it is the product and sku in another column etc. i want a formula that will
look for the p.o. number and then bring in the info that is with that p.o.
which is the product sku etc. for example if one p.o. has 5 items then that
p.o. is typed repeated 5 times so i need the formula to bring back those 5
items on a new sheet. hope this makes sense.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default formula needed to bring values to another sheet

Makes sense and you could use a series of VLOOKUP formulas to return the data
based upon PO number chosen.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP


On Tue, 5 Jun 2007 08:34:09 -0700, veena
wrote:

i have a data list which indicates p.o. numbers in one column and the next to
it is the product and sku in another column etc. i want a formula that will
look for the p.o. number and then bring in the info that is with that p.o.
which is the product sku etc. for example if one p.o. has 5 items then that
p.o. is typed repeated 5 times so i need the formula to bring back those 5
items on a new sheet. hope this makes sense.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default formula needed to bring values to another sheet

Assuming your data has column headers - if it doesn't, add them. Let's say
they are PO and SKU.

On the sheet where you want to pull the data, find an empty area and type PO
in one cell. In the cell immediately below that type a PO number.

In the cell immediately above the range where you want the data to show up
type SKU

Now select several cells and use Data-Filter-Advanced filter
You'll get a warning, but just click on OK
In the dialog that comes up
1) click on Copy to a new location
2) clcik in the List range box & then select the data range
3) click in the criteria box and then select the cells where you typed the
'PO' header and a PO #
4) click in the Copy to box and select the cell where you typed SKU
5) click on OK

You can update this easily by changing the PO #, then going through the Data
menu. Better yet, record a macro while going through these steps. Then you
can change thee PO and simply re-run the macro


"veena" wrote:

i have a data list which indicates p.o. numbers in one column and the next to
it is the product and sku in another column etc. i want a formula that will
look for the p.o. number and then bring in the info that is with that p.o.
which is the product sku etc. for example if one p.o. has 5 items then that
p.o. is typed repeated 5 times so i need the formula to bring back those 5
items on a new sheet. hope this makes sense.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula help needed (if values) [email protected] Excel Discussion (Misc queries) 3 January 19th 07 09:38 PM
Bring one sheet from one workbook to another via formula Fgbdrum Excel Discussion (Misc queries) 1 November 28th 06 10:18 PM
Bring back lowercase values Pat Excel Worksheet Functions 3 October 3rd 06 06:16 PM
copy values generated by conditional formula in one sheet to the other work sheet as values ramana Excel Worksheet Functions 1 October 5th 05 01:04 PM
copy values generated by conditional formula in one sheet to the other work sheet as values bobby Excel Discussion (Misc queries) 1 October 5th 05 12:18 PM


All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"