Tinkering Macro Code

Something in my code needs to be changed. I have data in columns A-H but my target value is in column F, so once that value is met, it transfers the line to another sheet (which is what I am looking to do) but it ignores the G & H column entries. Anyone know of a tweak I can throw in so that I can continue to edit the line values after the transfer is done? Please see the code below.

Thanks

Please Login or Register  to view this content.

Would this work?

Please Login or Register  to view this content.

I pasted the cod in place of the other. Unfortunatly it does not allow me to continue editing the fields after the copy has been done.

What fields do you want to edit? It would be easier to help if we can see your file. Could you post it?

If I fill out the line this way (a,b,c,d,e,g,h, then finish with f) I get all the data. but if I go from a-h it does the copy to another sheet at f and from that point on I can no longer add to the copy from the original sheet (sheet2).

Normally I would just fill it out in that order, but multiple users will be using this.

Thanks,

ER

That happens because your target range is column F. That means that as soon as you enter data in any cell in column F, the copy is made as soon as you exit that cell, so any data you enter in columns G and H will not be copied because the copy was done at column F. What you might want to do is enter a modifed code in a regular module instead of a worksheet and then run the macro after you have finished entering your data in all the columns.

Row F data transfer.xlsm

Here is a sample file that shows the problem.

Thanks again

ER

@Mumps1:
The data will be continuously added. There will be no moment where the database is complete. That's why I need some sore of coding that will allow me to edit after the copy has been made.

Try the attached file. Enter all your data and then click the button.

Hi Erusso. I forgot to mention that the code in file I attached will copy all the rows at once after you finish entering all your data. Unfortunately, the next time you click the button, it will copy the same rows again. This may not be what you want. One simple solution would be to use the code i posted earlier in your worksheet but move column F to the end so that it is the last column. This way all the data will be copied when you complete column F. Have a look at the attached file and see if this will work for you.

OK Thank you!

Anyone know of any changes that I can make to the code so that I dont have to move the column? Or is that the only option? How about something like this -If Target.Value = "BRING FORWARD / À REVOIR" AND column H has any sort of entry (there will ALWAYS be an entry in H) THEN copy to the other sheet. would that work?

ER