| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How I write "if cell value =1, copy entire row & paste at dest.
On Mon, 26 May 2008 01:19:00 -0700, sanjeev
wrote: I want to write a conditional program to execute a command. If the cell value is equal to or greater than 0, excel should copy the selected cells OR entire row (as per my requirement at that time) and paste it at another destination. If I copy this command on every row and if there are blank rows due to condition being 'false', in the destination rows of pasting it should delete blank rows. In short I want to make a 'summary' of the rows of data which meet the condition in a particular cell. kindly advise. My email I recommend Advanced Filter and choose the Copy to Another Location option. -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a one button shortcut for "copy cell above & paste here" | Excel Worksheet Functions | |||
| Write formula for simple copy and paste to another cell | Excel Worksheet Functions | |||
| want to copy entire text box and paste in new cell | Excel Discussion (Misc queries) | |||
| How do i link an entire source wksheet to a dest' wksheet | Excel Worksheet Functions | |||
| I would like to copy & "paste special" an entire book | Excel Worksheet Functions | |||
![Dick Kusleika[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
