I need macro to do:
In the initial sheet with the macro, it has buttons at the top one besides the others.
From left to right, buttons: "Import From Folder & Run", "Filter" "Clear Filter" "Help" (where all this info gets into)
1. "Import From Folder & Run" button to be able to choose Import from folder: From the Import Folder location, once clicked Select Folder, Application starts and it Opens each excel sheets (CSV type) in order to first spread using comma delimited, than to copy the data into the main sheet (the sheet with the buttons) (after copy of each sheet close each sheet). The copy is done in the following format: Title of the sheet comes first, second all the data from the sheet and a space at the end so there is a space between the last cell of data and the next sheet.
2. Move all columns starting with B 2 additional columns on the right.
3. Calculate number of words in A and insert on B.
4. Calculate the now J * F and put info on C.
5. Under the buttons, there are the fields to enter numbers as filters above each column. It filters for and has min and max fields. Ex if want to put Min 50 Max 500.
"Submit" button in order to filter by criteria entered.
6. B is now named "Keyword Length"
7. C is now named "Paid Clicks"
Functions
"Import From Folder" chooses the import from folder and runs the application
"Filter" once clicked is to apply criteria from filter fields
"Clear Filter" is to clear the pasted info in the initial sheet
"Help" Prompts this document
Hi,
I am interested in working on the task. I have 7 years of experience working with excel, excel VBA. I can get this done successfully. Read the instructions. Please share files. Looking forward to hear from you.
Best Regards,
Akila.K
Hi there,
I can definitely assist you in VBA Macro multiple filter. I had gone through the work details and assure to get it done.
We are a team of trained professionals with years of experience in MS Excel and VBA programming.
Hit us up and we can talk in detail.
Regards,
Nikita and her team at Affiliazion
HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I has done tons of projects using VBA. I can give my full effort to deliver the project in on time with 100% quality and accuracy...I'm waiting for your kind response.
Hello,
Please review my profile as I have the relevant skills and experience required for this project.
I can start working right now.
Kindly send me a message to discuss further for references, portfolio, and case studies.
Thanks,
Muhammad
Hi, I will summarize provide you with clear, concise notes. I'm interested in this project. If you award me the project I'd be very happy to discuss this further and get started for you as soon as possible. Thanks! Steve
I've understood the requirements
I'm pretty good at excel to say the least
we can connect and have a demo on this if you want to, with your functionality being available on a macro without actual data, before awarding the deal or your deal closes whichever is earlier
Regards,
Hitesh.
Demo available....
Hi I have done similar kind of projects earlier and this can be done in short span of time. let's discuss this further and start working on it asap.
Hi, I have so many experiences working on Excel/VBA. I am sure I can make this project for you. If possible, could you send me an example of how your Excel file looks like and how files in the folder looks like. So I can be more assertive about it.
Thank you so much and I hope to help you.
André
Hi, this project sounds relatively straightforward and I would be interested in taking it on. Do you have a preferred timeframe for delivery? Based on the description I think this would take me around a week but am pretty certain I can do it.
Hi
I can make the macro by using VBA and if you want can analyze your data by PivotTable.
I can design for you dynamic dashboards for data.
I can use a lot of functions to make our work is easy.
I am an expert in Excel and all programs of Microsoft office.
I am looking forward to working with you and I will start now.
Regards, Hossam