LinkBack URL
About LinkBacks
Hi All,
I want to copy records where records = "a" at Column B. What's wrong with this syntax?
If on its own (without the copy), it is ok,
Please Login or Register to view this content.
Regards,Please Login or Register to view this content.
Nironto
Hi All,
I want to copy records where records = "a" at Column B. What's wrong with this syntax?
If on its own (without the copy), it is ok,Please Login or Register to view this content.
Regards,Please Login or Register to view this content.
Nironto
what are you trying to actually do?
the syntax for copy is wrong
expression .Copy(Destination)
http://msdn.microsoft.com/en-us/libr.../ff837760.aspx
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.
Hi Humdingaling,
I know is wrong. But I am trying to apply the same concept
This is my original which works.
But I do not want to copy everything. I only want to copy those records where column B as "a'. ( a is used as tick)Please Login or Register to view this content.
Regards,
Nironto
ok what do you do would you do with the copied data?
are you keeping the same length/rows?
you cant do it the way your thinking
you could set up autofilter to copy range but your range will not be the same length anymore or you can create a loop to do one cell at time
the autofilter method would be the way i would do it without VBA but can be replicated in VBA.
Last edited by humdingaling; 07-11-2013 at 03:05 AM.
example of loopPlease Login or Register to view this content.
copies from Column B (2) to column D (4) anything that has "a"
if you want column D to only show A with no blanksPlease Login or Register to view this content.
Hi Humdingaling,
I appreciate your help.
I attached an example of what I am trying to do.
Copy Sheet1 records with 'X' to Sheet2.
I am trying to skip Looping (Processing row by row) because there are 40k records.
Regards,
Nironto
Try the attached
Thanks AB33!
You are a genius!
Regards,
Nironto
Nironto,
You are welcome!
Hi All,
This is very similar to something I am working on.
I have uploaded the same file with the required output in sheet 2.
If the cell is X select copy and paste adjacent cell.
But
If cell in next column is X copy and paste adjacent cell (same as before) into next column.
Can anyone help?
thanks Miles
Miles,
Welcome to the forum,
You need to start your own thread as per forum's rule.
Sorry AB33,
Have done: Titled the thread 'AB33 - loop copy paste to next column'
http://www.excelforum.com/excel-gene...45#post3318345
The real problem is here: Rota VBA - advice
http://www.excelforum.com/excel-prog...ml#post3316328
I was searching for similiar problems when I came across this thread..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks