| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I merge data in the same workbook?
I need to link data on two different worksheets in the same workbook. I need
to add LetterNo which is connected to specific CommentSource. Both sheets have CommentSource (not in same order). How can I merge the LetterNo into the main sheet without having to type everything individually? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I merge data in the same workbook?
You may take a look at the help for the VLOOKUP function, it may the most
adecuate for this. Hope this helps, Miguel. "Sno" wrote: I need to link data on two different worksheets in the same workbook. I need to add LetterNo which is connected to specific CommentSource. Both sheets have CommentSource (not in same order). How can I merge the LetterNo into the main sheet without having to type everything individually? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I merge data in the same workbook?
hi membes how can i merge the data of 15 different worksheets into single sheet in the same workbook data is almost of 5000 rows in each workbook. -- b166er ------------------------------------------------------------------------ b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912 View this thread: http://www.excelforum.com/showthread...hreadid=549134 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up Data from Worksheet within same Workbook | Excel Discussion (Misc queries) | |||
| how can update the data in an excel workbook without opening it | Excel Worksheet Functions | |||
| Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
| Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions | |||
| Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
Linear Mode
