Copy columns A and B values from Table1 on Sheet1 to Table2 on Sheet2

Upon sheet.activate, the code below copies the entire contents of Table1 to Table2. However, I wish to copy only the values contained in columns A and B onto Table2. The values in columns D, E, and F in Table2 should not change when this happens. Each time a new row is added to Table1, a new date populated in column B, which should also result in a new row and date in column B in Table2.

I researched and tried numerous other related codes but failed to get anything to work. This code is the closest I could get. How can this code be rewritten to do as described above?

Please Login or Register  to view this content.

Give this a try:

Please Login or Register  to view this content.

BSB

Perhaps like this?

Please Login or Register  to view this content.

BSB

Exactly like that! Amazing how concise this is and how effortlessly you answered this. Maybe I did a bad job searching on the ‘net but there wasn’t anything I could find even remotely similar to these code lines for this kind of problem. Only change I had to make was to insert a “Range("A1").Select” line at the end to bring it out of highlight mode.
😊

I think the problem with searching for help on Excel (or similar) issues online is although you may know exactly what you want to achieve it's not always easy finding the correct phrasing. Search engines are a lot better now than even a few years ago at "guessing" what you mean by searching for alternative words to the ones you actually entered, but it's still a fine art to match your search phrase with that of an already provided solution to the same issue.
Combine that with the fact that in Excel there are always multiple ways of accomplishing the same thing and it gets even trickier. So don't beat yourself up for doing a "bad job" searching. You found this forum and you got a solution, so couldn't have been that bad a job!!

As for how effortlessly I answered it, if you'd been using Excel and writing code for as long as I have (it's been my job for 20+ years), you'd have answered it effortlessly too

Glad I could help and thanks for the rep!

Good luck with the rest of the build. You know where we are if you need more help with it.

BSB