| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Look UP or fill in
I have two sheets of data
Sheet 1 1-9999 sheet 2 1-2800 (from 1-9999) I want to combine the sheets where if there is data in Sheet 2 the remaing numbers will eithe be lfet bland or 0 added Exampe of data in two rows Sheeet 1 Sheet2 OCN Class OCN Class 146 3 147 Blank |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Look UP or fill in
Re-read your own question
-- Kind regards, Niek Otten Microsoft MVP - Excel "gfj" wrote in message ... I have two sheets of data Sheet 1 1-9999 sheet 2 1-2800 (from 1-9999) I want to combine the sheets where if there is data in Sheet 2 the remaing numbers will eithe be lfet bland or 0 added Exampe of data in two rows Sheeet 1 Sheet2 OCN Class OCN Class 146 3 147 Blank |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Some formulas don't track copies, pastes, fill right, fill down | Excel Discussion (Misc queries) | |||
| Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
| How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
Linear Mode
