Data to populate from one WS to another based on data entered in a cell

[teamexcel777]

I have 2 worksheets; LEADS & SALES

When any date is entered into LEADS H6:H1005, The information in LEADS B, C, D, E, F, & H6:1005
Will populate into SALES B, C, D, E, F & G6:1005 (The last column letter is different on LEADS vs SALES)

I do not want the info to auto sort based on any dates. I just want it to populate the info row by row
based on any date being entered into LEADS H6:H1005. I need to be able to sort the info on the sales
page so this is why I do not want the formula to sort based on a date. Just whenever a date is entered
then that’s the next to populate and so on.

 

[JLGWhiz]

can i send you the WS so you can try it? I did all the steps over again, I first did it with the original code and it worked but had the issue sorting. Then I reopened and inserted the new code and nothing at all happens when I enter a date in LEADS H.

I have already tried it and it worked for me. Event code is event code. It works the same on my system as it should work on yours, if the parameters are as described in the post. Worksheet_change event only applies to the sheet in which the code resides. Any change on that sheet will trigger the macro unless a) events are disabled, or 2) design mode is active.

The code provided will not copy and paste if more than one cell is selected and changed, the change leaves the cell blank or the change is outside the designated range in column H.

Outside the above conditions, the code should be working as intended.

 

[teamexcel777]

Its working!!!!! The info about not having more than one cell highlighted was what I was doing wrong. Now its fine, thanks so much, really appreciate this!

 

[JLGWhiz]

Its working!!!!! The info about not having more than one cell highlighted was what I was doing wrong. Now its fine, thanks so much, really appreciate this!

You're welcome,
regards, JLG