Hi there,
I need to specify a date and if it matches a date in column A in a differet workbook i need to copy the whole row and paste it in a different workbook, and then loop through and copy/paste
So far I have the code below but for some reason its not copying or pasting
Please Login or Register to view this content.
why not just filter and copy it all at once?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
because I have multiple workbooks that I need to scroll through and do the same thing to. Ideally it would open all the excel documents in a specific folder and do this to each one of them... that's just how I receive the data
Are you not getting an error?
You are trying to "squeeze a quart into a pint pot"
which rows should be copied?
needs specifying
Rows = ALL rowsPlease Login or Register to view this content.
Will not fit unless you paste to A1
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
I switched it to
but its still not working. I think it may not be recognizing the dates for the rows i need to copy. As well I'm not sure if its cycling between the workbook correctlyPlease Login or Register to view this content.
Try this amended version of your code - which works for me
1. Let me know how you get onPlease Login or Register to view this content.
2. Is it consistently the first sheet in every workbook, with headers in row 2 and data staring in row 3 ?Ideally it would open all the excel documents in a specific folder and do this to each one of them..
3. This question from @humdingaling deserves further consideration. Filtering the data is MUCH faster than looping through rowswhy not just filter and copy it all at once?
Last edited by kev_; 01-30-2019 at 03:08 AM.
Thanks so much, it works perfectly and I was able to find to code any modify it was well through scroll through all worksheets in a folder
i did mean filter and copy via CODE not manually....no idea how big your sheet is or how many "hits" per macro run you are going to get
just doesnt seem like it will scale very well ....
if you had 50000 rows it would have to loop 50000 times then if you had 10000 hits then you would copy and paste 10000 times
vs
filter once, copy filtered results paste in one go. No looping required
anyways it seems like you are happy with your solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks