Đã hoàn thành

Script For Excel To Pull Data and Create New Spreadsheet

This is a simple job for anyone capable of writing a macro. But you must detailed.

I have spreadsheets with rows of data and scores from basketball games. I need a desktop script created where I enter certain values from the spreadsheet, and the script pulls ONLY the games (and all data for those games) with those values - and creates a brand new spreadsheet.

Attached is an example spreadsheet - the script will need to perform the following:

1. There are 4 rows with data for each game

2. The script will pull ALL 4 Rows from left to right on any chosen game when creating a new spreadsheet

3. The script with use column "I" and "R" as value indicators

4. The script will pull only games that have BOTH "I" and "R" indicators, not just one.

5. The script will need to pull from an entire folder with 40 + spreadsheets for each job.

Send questions, and let me know you know what you're doing by mentioning details of this job.

Kĩ năng: Lập trình C, Excel, PHP, Kiến trúc phần mềm, Visual Basic

Xem nhiều hơn: python script to pull data from blog, script to pull data from a website, script for excel data, how to copy data from one excel workbook to another using macro, excel macro import data from another workbook, excel vba import data from another workbook without opening, transfer data from one excel worksheet to another automatically, excel import data from another workbook vba, excel macro to create new workbook based on value in cells, excel pull data from another workbook, how to extract data from one sheet to another in excel using vba, how to pull data from a website into excel 2016, how to pull data from multiple worksheets in excel, how to pull data from a website into excel macro, how to pull data from a website into excel 2010, how to pull data from a website into excel 2013, macro to pull data from multiple excel sheets, how to pull data from multiple workbooks in excel, how to pull data from another sheet in excel, script to pull data from website

Về Bên Thuê:
( 189 nhận xét ) Henderson, United States

ID dự án: #18760081

Được trao cho:

aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$50 USD trong 1 ngày
(79 Đánh Giá)
5.4

10 freelancer đang chào giá trung bình $110 cho công việc này

TonmoyRoy111

Hello client I understand the scope of work involved in the project. I can surely do this project for you with perfection. Kindly contact me. Roy

$120 USD trong 1 ngày
(296 Nhận xét)
6.6
mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on several excel projects, i can help you in getting yours done as you need. Will provide you form in the excel where you can provide inpu Thêm

$77 USD trong 3 ngày
(118 Nhận xét)
6.0
lightingdavid

Hello. How are you? I am highly interested to work on the "Script For Excel To Pull Data and Create New Spreadsheet". I am a full stack Excel/VBA developer. I have more than 7 years experience in "C Programming, Ex Thêm

$155 USD trong 3 ngày
(80 Nhận xét)
5.9
Capitan0Trueno

The way the data is laid down in the spreadsheets is not very efficient for retrieval based on filtering criteria, but I assume is the data you have. It would probably be worth considering a format change to make filte Thêm

$140 USD trong 2 ngày
(24 Nhận xét)
4.6
dungchan44

Hi, bro! I'm very happy to put my bid on your project. I've read your requirement. I have a wealth of experience with data processing using Excel formula and VBA. I have finished many projects like this. I can sh Thêm

$30 USD trong 0 ngày
(8 Nhận xét)
3.3
shiwani6390

Hi, I am expert in developing websites, web portals, web applications and mobile sites through PHP, Wordpress, Shopify, Codeigniter, Larvel, Magento, Drupal, Angular, PSD design, bootstrap, HTML, HTML5, CSS, Jquery Thêm

$100 USD trong 3 ngày
(7 Nhận xét)
4.1
tusharvv76

I have FULL CONFIDENCE of completing this project and I am ready to start IMMEDIATELY. I will write an Excel VBA macro for desired functionality in an Excel macro-enabled file and hand it over to you. Few questions: Thêm

$50 USD trong 2 ngày
(4 Nhận xét)
2.1
AngelaZhang94

Dear Sir, I'm a web scrapping master. I mainly use Excel (VBA script), C++ and python to scrape the website. I have good experience with scrapping sports and betting site data into excel. I checked your attachment Thêm

$100 USD trong 2 ngày
(1 Nhận xét)
1.3
Growthnix

Hey I can help you with your project. I have 6 years of experience in Web and App Development I’ve true passion & skills on what I do for my clients with a unique & creative approach towards every project I undertak Thêm

$277 USD trong 3 ngày
(0 Nhận xét)
0.0