| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge two sheets
I have two sheets Sheet1 and Sheet2. In A1 in both sheets I have a key.
I need to: 1. When A1:A100 in Sheet2 find at match in A1:A100 in Sheet1 - copy specific cells from Sheet2 to Sheet1 . 2. When a key in Sheet2 is not found in Sheet1 - copy the entire row in Sheet2 to the end of Sheet1. Can anyone give me a hint? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I merge and purge two excel work sheets? | New Users to Excel | |||
| How do I merge information from sheets on other files into the ma. | Excel Worksheet Functions | |||
| How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| is there an easy way to merge data/information on several sheets . | Excel Discussion (Misc queries) | |||
Threaded Mode
