| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do i transfer cell data from one sheet to the other in Excel
I have Sheet1 and Sheet2. In Sheet1, Column A, I merged rows 1-4 as one cell
to contain the ID # for the person Column B: name in Column B1, address in B2, city in Column B3, and phone # in Column B4. When I entered the ID# in Column A of merged rows 1-4 in Sheet2, I need the information from Column B1-B4 of Sheet1 to transfer to Sheet2, Column B1-B4 automatically. I would appreciated if someone can give me a hand....thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I transfer data from 1 sheet to another? | Excel Worksheet Functions | |||
| transfer data from one excel sheet to another | New Users to Excel | |||
| How do i get my data to transfer to another work sheet? | Excel Discussion (Misc queries) | |||
| Transfer data from one sheet to another | Excel Discussion (Misc queries) | |||
| How can I transfer a Lotus 123-9 data spread sheet file to Excel? | Setting up and Configuration of Excel | |||
Threaded Mode
