VBA for Excel/Find record from the list
$30-250 USD
Paid on delivery
Hi all,
This is an easy task. Do not bid more than minimum.
TASK DESCRIPTION
1. Create a button in Sheet2 of SourceFile.xls. At the beginning, Sheet2 has one column with data (A)
2. For each line column A in Sheet 2, find all the records (lines) that the value in column B in Sheet1 of [login to view URL] is the same as column A in Sheet2
3. Copy all found records (lines) and make a new file [login to view URL] that the content (columns) is the same as [login to view URL]
4. In Sheet2, write the “found values” in column B and “not found” for value that cannot be found in column B of Sheet1
Thanks
Hi all,
I forgot a preparation step that wee need to collect all data from all other files (example: Source1, source2,...anothersource3...)into one SourceFile.xls. Therefore, we will need another button to collect data first. This button will work:
For each file in folder1, copy all data and paste into the next line of SourceFile.xls and delete that file.
Finally, we will have only one SourceFile.xls and proceed the Finding tasks.
Thanks
Project ID: #455080
About the project
Awarded to:
This can be done using VBA. I am ready to start immediately. Please refer to PM. The project will be completed in 6 hours.
17 freelancers are bidding on average $32 for this job
Hi, I have fully read your requirement and understood them. I will be more happy to work for you. Thanks djain01
Dear Tandem7! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.
Exceptional quality & Fast work. *** CAN BE COMPLETED IN 6 HOURS ***. Please refer to Profile & PMB for details. Thanks FAZ
Yes, it is an easy task. It can be done with macros and few functions in visual basic. I am always working with excel and macros. So If you want to see any similiar work I have done in excel please send a PM
Hi I just finished a similar assignment. All you need is "findnext" to exhaust repeat items.
Hi VBA is the best solution, to find anything in Excel and do what you imagine with that record. B.R. Zoltan
We can deliver this for you with no issues. You will find no issues for getting this delivered as per your description in the description section.
ya,Its very easy. We have other projects about stock market,so no of days for completion is 5,otherwise we can do it in 1 day.