In excel sheet i am trying to search and copy searched data
there is row name called result on next row of that i want to search and automatically copy on that rows
it is possible
i have attached my sheet
please help me
Please Login or Register to view this content.
Last edited by baig123; 09-09-2014 at 07:22 AM. Reason: paragraph
you need a space after pasteSpecial and use xl instead of x1Please Login or Register to view this content.
like this
Also, you are looking in the wrong column, did you need to post to find that out???, using column A instead of BPlease Login or Register to view this content.
so
Please Login or Register to view this content.
Last edited by nathansav; 09-09-2014 at 07:22 AM.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
thanks
but still i am not getting any output
I ran it and did.
i am sorry
but still i am not getting any output
Can you post your changed code.
He also had Formula spelled wrong in PasteSpecialx1pasteformilasandnumberformats
Despite the high cost of living, it remains very popular.
Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
Yes, i covered that earlier.
No you didn't. You said he needed a space and to change X1 to XL, you did not mention the spelling. I guess you did correct it for him when you said "like this", just didn't mention it I guess.
see this have changed the code
Please Login or Register to view this content.
Were you searching for belt? What column is it you want to search on? Belt isnt in column B
My code was
you need to usePlease Login or Register to view this content.
Please Login or Register to view this content.
I get what you are trying to search (search for BELT within the column D) but what are you trying to return? This was my best guess.
Please Login or Register to view this content.
Baig, you really need to explain your posts more.
Agreed!
COLUMN D
seraching and copying it in the cell g6 in the same sheet
Last edited by baig123; 09-10-2014 at 05:02 AM. Reason: paragraph
Thanks for sharing ur knowledge
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks