Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Excel 2000 - this is under help - keyword-null and doesn't work and I need it
to work or am I reading wrong? I hv 2 databases w 2 col 1 for owner name and 1 for financial ofcr name I need to cut/paste fin ofcr name into owner name cell if there is a financial officer name because I would rather mailer go to fin ofcr. There isn't always name in fin ofcr col. I scroll until I find fin ofcr name, cut/paste to col to the left and overwrite the owner's name with fin ofcr name. about 10 fin ofcr names per visable screen. Painful on mouse hand. I want to highlight maybe whole fin ofcr col or at least visable page cut/paste and overlay col to left with fin ofc name but not make other cells blank. currently when I do this fin ofcr name is pasted and all other blank cells are pasted as blanks also. If copied blank cell overlays not blank cell I want blank cell not copied. Please help. -- claudia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to prevent copied data from appearing until triggered by anoth | Excel Worksheet Functions | |||
New data will not sort with existing data from copied file | Excel Worksheet Functions | |||
Replacing blank cells | Excel Worksheet Functions | |||
how to prevent blank cell copied when combining cells? | Excel Discussion (Misc queries) | |||
Prevent Hidden Column data from being copied/pasted? | Excel Discussion (Misc queries) |