Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If data is on one sheet, linking to another
I have multiple sheets in a workbook.
One sheet (call it Sheet A) has data that may or may not be inputted in specific areas. Another sheet (call it Sheet B) takes this data and populates cells that are in Sheet B. I want some of the data from Sheet A, only if it is has been added, to populate Sheet B and if it is not populated, I want it to refer to another cell on Sheet A or to say "not provided". Is this possible? (or make any sense!) |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If data is on one sheet, linking to another
=IF(SheetA!A1="",SheetA!B1,SheetA!A1)
or: =IF(SheetA!A1="","not provided";SheetA!A1) HTH -- AP "nevergiveup" a écrit dans le message de news: ... I have multiple sheets in a workbook. One sheet (call it Sheet A) has data that may or may not be inputted in specific areas. Another sheet (call it Sheet B) takes this data and populates cells that are in Sheet B. I want some of the data from Sheet A, only if it is has been added, to populate Sheet B and if it is not populated, I want it to refer to another cell on Sheet A or to say "not provided". Is this possible? (or make any sense!) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If data is on one sheet, linking to another
Thanks, but when I do the first one it comes back False. Any ideas why?
"Ardus Petus" wrote: =IF(SheetA!A1="",SheetA!B1,SheetA!A1) or: =IF(SheetA!A1="","not provided";SheetA!A1) HTH -- AP "nevergiveup" a écrit dans le message de news: ... I have multiple sheets in a workbook. One sheet (call it Sheet A) has data that may or may not be inputted in specific areas. Another sheet (call it Sheet B) takes this data and populates cells that are in Sheet B. I want some of the data from Sheet A, only if it is has been added, to populate Sheet B and if it is not populated, I want it to refer to another cell on Sheet A or to say "not provided". Is this possible? (or make any sense!) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Linking Data from 1 sheet to another sheet | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) |