| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing Data
I have a workbook with five(5) sheets and I am trying to import data on sheet
four from sheet 2. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Importing Data
You can use copy/paste, you can use formulas such as
=if(isblank(sheet2!a1),"",sheet2!a1) in cell A1 of sheet4 and drag that formula to adjacent cells. How much data are you talking about? Is this a one time thing? "Batmancd" wrote in message ... I have a workbook with five(5) sheets and I am trying to import data on sheet four from sheet 2. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Importing Data
Dave,
I will try your suggestion, the occurance is not all that often, I do have four sheets in the workbook and some of the info on sheet 2 has to go from 2 to 3 or to 4. "Dave Thomas" wrote: You can use copy/paste, you can use formulas such as =if(isblank(sheet2!a1),"",sheet2!a1) in cell A1 of sheet4 and drag that formula to adjacent cells. How much data are you talking about? Is this a one time thing? "Batmancd" wrote in message ... I have a workbook with five(5) sheets and I am trying to import data on sheet four from sheet 2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing data | Excel Discussion (Misc queries) | |||
| Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
| Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) | |||
| Importing Data & Refresh Data Problem | Excel Discussion (Misc queries) | |||
| Importing data | New Users to Excel | |||
Linear Mode
