Hey!
So I have a big sheet that I'm working on that is using this code to pull items over from one sheet to the next which works great until I change some values in it and I'm not sure why.
So when I change it to source.range to A:D instead of A:C, it will paste repetitively for thousands of more columns past A:D. So E:H will have the data too, etc for thousands of rows. Just wondering what I'm doing wrong there!
Please Login or Register to view this content.
Thanks!!!
[/CODE]
Last edited by jamief; 12-11-2019 at 06:33 PM.
I'd be inclined to change thisto thisPlease Login or Register to view this content.Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
That fixed that issue! Thanks!
I did run into another issue right after though.
K here's some more code.
I'm sure there's reason I can't do something I did here...
Basically, Once all the info is on the "CSV2" sheet, I want for it to use the same code to look on that sheet for any A's in column D, and copy and paste them to the "Order" sheet, then go through the same info, and copy all the B's, etc.
Am I able to use this code multiple times like this? or is there a different way I should do this?
Thanks again, you da bomb.
Please Login or Register to view this content.
You're looking at column C, not column D.
It's been a long morning
Thanks!!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks