| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Blank cell from another page within a worksheet?
Hi,
I am trying to find a way to leave a blank cell on my summary sheet that is populated from another sheet within the worksheet. i.e. Summary page - A1 is populated from worksheet1 from D5 If D5 says 'Yes' then 'Yes' appears in A1 of my summary sheet My question is how can I leave A1 blank if D5 is blank on worksheet1? At the moment if D5 is Blank I get a '0' in A1 on my summary sheet which does not visually very nice. Thank you for your help in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet opens to blank page-no cells | Excel Discussion (Misc queries) | |||
| Link to last non-blank cell in another worksheet | Excel Discussion (Misc queries) | |||
| Clear cell borders for blank white page | Excel Discussion (Misc queries) | |||
| Clear cell borders for blank white page | Excel Discussion (Misc queries) | |||
| change cell size from page to page on the same worksheet | Excel Worksheet Functions | |||
Threaded Mode
