Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to extract a sheet from another?
Hi,
I have a set of data (5000) in one sheet and another set of data (30) in another sheet. The 30 datas are included in the 5000 one. I would like to extract them from the 5000 one. The reason is that I don't have all the infos on the 30 one but all the infos on the 5000 one. Hope it's clear. Thanks. -- DD |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to extract a sheet from another?
Answer was provided in your other post by myself and completed by Shane...
"deedee" wrote: Hi, I have a set of data (5000) in one sheet and another set of data (30) in another sheet. The 30 datas are included in the 5000 one. I would like to extract them from the 5000 one. The reason is that I don't have all the infos on the 30 one but all the infos on the 5000 one. Hope it's clear. Thanks. -- DD |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to extract a sheet from another?
Perhaps try the VLookup function on each value in the '30' list to return
the value from the desired col in the '5000' list using appropriate offset references. hth, jay "deedee" wrote in message ... Hi, I have a set of data (5000) in one sheet and another set of data (30) in another sheet. The 30 datas are included in the 5000 one. I would like to extract them from the 5000 one. The reason is that I don't have all the infos on the 30 one but all the infos on the 5000 one. Hope it's clear. Thanks. -- DD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract info from one sheet to another | Excel Worksheet Functions | |||
extract odd numbered rows from one sheet to put into another? | Excel Discussion (Misc queries) | |||
macro to extract data of a selected sheet | Excel Discussion (Misc queries) | |||
Help me, compare 2 sheet and extract the match data into the new sheet. | Excel Discussion (Misc queries) | |||
Extract sheet name/number to cell | Excel Discussion (Misc queries) |