| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging
I I have a large spread sheet, I NEED TO MERGE DATA FROM THIS SHEET AND
PLACE IT ON ANOTHER SHEET. I NEED TO MERGE COLUMNS A, H, & I AND PLACE THEM ON TO THE NEW SHEET IN COLUMN F HOW DO I DO THAT? ANY AND ALL HELP/ SUGGESTIONS WOULD OF COURSE BE APPRECIATED SHARLENE |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merging
Why the new sheet? If you set the data as a database, you can retrieve only
the data you need in an open range, or use (H or V) LOOKUPs to pull the data into new columns independent of the rest. P. -- Overcome Sales Barriers http://salesbarriers.typepad.com/ "Sharlene" wrote: I I have a large spread sheet, I NEED TO MERGE DATA FROM THIS SHEET AND PLACE IT ON ANOTHER SHEET. I NEED TO MERGE COLUMNS A, H, & I AND PLACE THEM ON TO THE NEW SHEET IN COLUMN F HOW DO I DO THAT? ANY AND ALL HELP/ SUGGESTIONS WOULD OF COURSE BE APPRECIATED SHARLENE |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging errors | Excel Discussion (Misc queries) | |||
| Merging Excel Files - Option "grayed out" | Excel Worksheet Functions | |||
| When merging information not merging correctly | Excel Worksheet Functions | |||
| Converting a group of lines into one line without merging | Excel Discussion (Misc queries) | |||
| need assistance with merging cells | Excel Worksheet Functions | |||
Linear Mode
