LinkBack URL
About LinkBacks
Please Login or Register to view this content.
How would I alter the above so when it pastes into sheet test it doesn't paste the whole row, instead it just pastes rows A to O ???
Please Login or Register to view this content.
How would I alter the above so when it pastes into sheet test it doesn't paste the whole row, instead it just pastes rows A to O ???
I know it's the below line which currently copies the entire row but I just want the range Ax:Ox to be pasted.
Please Login or Register to view this content.
Untested but you can try -
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Doesn't work at all arlu I'm afraid.
Will this option work? Copy as is and delete the unwanted columns?
I don't want any columns deleted. What I want is, when the row is copied from sheet PIF, I want it to be pasted into sheet test, but only paste in the row from Ax:Ox.
I dont like the find code that much. But maybe if you explain to me what you are trying to achieve, i can create another code for you.
I want to look in column H on sheet PIF and if it finds 'U' then copy that row range A to O and then look at whats in column F on the row where it found U on the same sheet and then goes and find whats in column F on sheet test searching only column F and if it finds a match then paste on that row.
Last edited by ScabbyDog; 11-23-2012 at 02:43 PM. Reason: Clarifying what I want exactly
My original post works perfectly for what I've described. The only issue is that I don't want the whole row copied and pasted, just range A to O in the row.
Maybe this one.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Doesn't seem to work. Any other ideas?
Post your file so we can test it.
Basic sheet attached so you can test it.
Book1.xls
Book1.xlsm
OK, I've tested it and what you posted ooeldere works, but, it always give me an object defined error after it runs and highlights the piece of code you gave me even though it does what I now want it to do! Can you check the below sample file with code included?
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks