Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel array copy paste loop
#1
Hello, I have been messing around with QM for a bit and after my work saw some of the things it can do was able to convince them to purchase a license. Since then I've been working on improving my macros. What I have now requires a ton of 'Cc and 'Cv with window switching all over the place.

To the question, what would code this code look like? Toss a column of data in excel into an array. Upon a trigger key the first cell in the array will paste into a field that I have selected. Then I select another field and upon the same trigger key press the next cell will paste. This would continue until the end of the array has been reached.

Thank you for your time!


Messages In This Thread
Excel array copy paste loop - by rob85048 - 07-08-2022, 07:23 AM
RE: Excel array copy paste loop - by Gintaras - 07-08-2022, 08:53 AM
RE: Excel array copy paste loop - by rob85048 - 07-09-2022, 06:22 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)