i want to copy a row from one sheet to the next automatecall

May 3, 2018 at 04:41:59
Specs: Windows 10
i want to copy a row from one sheet to the next sheet only if the row did not meet my requirements
how can i program it
iam having a number of columns, the last one is a conditional rule, if its yes the row should stay, if its no the row should move to next sheet in excel

See More: i want to copy a row from one sheet to the next automatecall

Report •

#1
May 3, 2018 at 05:31:23
I'm a bit confused.

First you said: i want to copy a row from one sheet to the next sheet

Then you said: the row should move to next sheet

When I read "move" I think Cut/Paste, not Copy.

Which is it?

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Report •

#2
May 5, 2018 at 22:20:20
i want it to be copied automatically

Report •

#3
May 7, 2018 at 07:13:28
It helps us help you when you supply enough detail that we know what you are trying to accomplish.

You say "i am having a number of columns, the last one is a conditional rule"

1 - Since we can't see your workbook from where we are sitting, we don't know which is your last column.

2 - What do you mean by "conditional rule"? Is it an IF function? A Drop Down list choice? Something else?

3 - When do you want it to be "copied automatically"? e.g. As soon as No appears in the cell? As part of group i.e. "Copy all rows with No when a I click a button? Something else?

Note: If you are using a Drop Down to choose Yes or No, copying the row as soon as the choice is made is fairly easy. If you are using an IF function to populate the cell with Yes or No, then things get a bit more complicated. Choosing Yes or No from a Drop Down will be seen as a change that a Worksheet_Change macro could react to. However, populating the cell with Yes or No via an IF function (or any formula) is not going to be recognized as a "change", i.e. a cell that was manually changed. We may need to monitor the cells that caused the Yes or No to appear in the cell, not the Yes/No cell itself.

That is why I say that we need a lot more detail as to what you are trying to do before we can offer a solution.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •
Related Solutions


Ask Question