Đã Đóng

VBA Macro multiple filter 50CAD FIXED PRICE READ CAREFULLY -- 2

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

Kĩ năng: Visual Basic, Xử lí dữ liệu, Excel, Kiến trúc phần mềm, Visual Basic cho Ứng dụng

Xem nhiều hơn: vba macro excel unicode, excel vba macro paste adjacent column, next empty cell vba macro paste, vba macro trial, vba macro generate report excel word, paste excel vba macro, row column increment vba macro, vba macro click button webpage, inputting multiple data vba macro, access vba multiple filter, read webpage data excel vba macro, read word file vba macro, vba macro filter unique results, vba macro filter sort, magento price slider multiple filter, sort filter data vba macro, SMALL VBA PROJECT - FIXED PRICE, managing updates to shared vba macro code for multiple users, find and replace multiple values in excel using vba macro, how to combine multiple excel sheets into one worksheet using vba

Về Bên Thuê:
( 12 nhận xét ) Montreal, Canada

ID dự án: #29847045

7 freelancer chào giá trung bình$156 cho công việc này

rumarahman

Hi Sir, ✅ I am an Excel Expert ✅ Gone through the job details and happy to help you. I am an expert in excel formulas, dashboards, macros. I will be able to finish before the deadline. Thanks Ruma

$50 CAD trong 5 ngày
(53 Nhận xét)
5.4
shteyger93

Hello How are you? I've read carefully your job description. I have more than five years experience in VBA and Algorithm Parts. Your satisfaction with the project is my top priority! If you give me a chance to work wi Thêm

$100 CAD trong 2 ngày
(8 Nhận xét)
3.4
mna9226

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 Thêm

$80 CAD trong 2 ngày
(2 Nhận xét)
0.5
lehakrizhik02

Hi. I have just read your proposal. What I am really interested in your project is that this is my cup of tea. Moreover in your idea there are more admirable points and maybe that's what attracted me. I am full stack d Thêm

$300 CAD trong 7 ngày
(0 Nhận xét)
0.0
jah42

Dear Employer, I have read your project description When do you need this finished? I'm professional in data entry, data entry into Google sheets, Data processing, Excel, Typing, copy paste, Article writing and such k Thêm

$70 CAD trong 1 ngày
(0 Nhận xét)
0.0
HajiAhmad

I have created 8 MS Office Addin Recently. 1) Search sender Email Address in database and generate reports for the sender Email. 2) Lookup Voice mail phone number in data base and generate Reports for phone number. 3) Thêm

$350 CAD trong 7 ngày
(0 Nhận xét)
1.4
rashmifulchand

I am a multi-skilled Analyst with strong IT skills. I have expert level skills in MS Excel. Having qualified from Loughborough University to postgraduate level in Information Technology and HNC Business and Finance fro Thêm

$140 CAD trong 7 ngày
(0 Nhận xét)
0.0