How I write "if cell value =>1, copy entire row & paste at dest.

  • Thread starter Thread starter sanjeev
  • Start date Start date
S

sanjeev

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 (e-mail address removed)
 
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 (e-mail address removed)
Click to expand...

I recommend Advanced Filter and choose the Copy to Another Location option.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and paste range instead of entire row 1
Create if partial match then copy and paste data from one cell to another 1
Copy rows with values in sheet 1 to next empty row in sheet2 2
copy row if contain keyword 7
How to write a macro to hide an entire row 9
paste value column based on first cell command button 1
How to paste a value for a preceding row if a cell is empty 1
Insert Rows if Pasting more Than 1 Row 5

Back
Top