Search column from A1:CE1. If matched than copy entire row for that column.
I have a folder, which contains 1000 of excel workbook, I am trying to open workbook 1 by 1. In sheet 1 I am searching all columns using case.
Now problem is that I want to copy entire row 1 by 1 if column matched.
For example:
Please Login or Register to view this content.
Your help will be much appreciated.
Last edited by shivanisachdeva167; 11-04-2014 at 02:33 AM.
Hi Shivan
Please use Code Tags, first edit your post by adding code tag to your code
after editing your thread provide sample workbook of master file & source file
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hi, shivanisachdeva167,
your code:
tryPlease Login or Register to view this content.
If the column is equal in both sheets you could refer to that column in both commands but you would need to make sure to copy more than just the heading..Please Login or Register to view this content.
Ciao,
Holger
Last edited by HaHoBe; 11-04-2014 at 01:21 PM.
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hello HaHoBe ,
Thank you all for a prompt reply and assistance. Today I tried your suggestion.
It is not working for me.
I am trying to give some intelligence power to my macro. For example opening folder and copy all sheet just copy the static range.
But I want to try search column using case. If found then copy rows value for all workbook in a selected folder.
Once again thanks in advance to Hahobe and Naveed.
Hi, shivanisachdeva167,
Did you receive a run time error, which one? What didnīt work? You would need to elaborate on that.It is not working for me.
Iīd go with an Application.Match from the destination workbook on the new worksheet rather on that as Iīm afraid VBA wonīt be "intelligent" enough to asssume what you are trying to get, you would need to code it in order to get the proper result. You could use arrays for that although I donīt see the benefit. And you would make sure to havbe the same items being used the headings in every workbook/worksheet as well. If these differ you could try Find or loop and InStr or Like or use an array with synonyms for each item.I am trying to give some intelligence power to my macro.
Ciao,
Holger
Thank you for your kind reply. I was trying to fetch all column value listed in case.
For example date:
It may have positioned in A1 or B1 or C1. That is why 1’stly I searched column date
And now I want to paste “Date” column’s row value.
I am wondering if following syntax can be attached in Case.
Please Login or Register to view this content.
Hi, shivanisachdeva167,
the command you posted is sort of overload. Cells refers to all cells on a sheet, so what should CurrentRegion do about that? For Cells the entire sheet is the Cuzrrent Region. If you use a single cell or a small range you may find and use the surrounding region.
Application,Match will deliver the index of the range being tested if the item is found and in that case delivers a long value while if no match is found an error is delivered.
You would need to either use Resize for both areas or use copy/paste for just one cell.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks