Excel Macro (EASY)
- or -
Post a project like this1978
$30
- Posted:
- Proposals: 20
- Remote
- #2197476
- Awarded
Excel | Google Sheet | User Interface | Web App | Data Scraping | Internet Research | Photoshop Service
Jakarta
Virtual Professional Assistant,Report Generation on Excel,Excel DataEntry, Excel formula entry( Maths of Excel),Online/Offline Data Entry,PDF to Excel, ScanPhotos/Other material t Excel/Word/PowerPt
Islamabad
MS Office Expert | Virtual Assistant | Internet Researcher | Basic IT Helping Hand
Dhaka
VBA Developer with Excel, Reporting with Excel, Analysis with Excel, Data Entry Operator
Secunderabad
Professional Writer, Logo Designing, WordPress, PHP, Custom Web Development and designing , Data Entry, Professional designers,
Bahawalpur
Excel | VBA | Macro | MS Access | MS Word | PowerPoint Program | .Net | C# | VB.Net
Bangalore
179269424518522434774242805424132802413086240516822630582153556188945417115861449433
Description
Experience Level: Entry
I daily receive an excel file which I want to click one button and divide the data rows equally among (x) amount of files.
Ensuring ALL data is correctly showing on every file. And no duplication etc.
eg. I have a file with 300 rows of data. Each row has numerical amount.
The total for example of the numerical data is 1,000,000
I want to divde this file into (x) files. eg 4 files. That means I want 4 files with approximately 300/4 = 75 rows each of data.
The total rows of each individual file should now be 75. And the total of a particular numerical column should be approximately 1,000,000 / 4 = 250,000
I also want to set a maximum numerical per file which is selected daily.
The division of files is different daily. Sometimes 3, sometimes 6 etc.
Should take a excel whiz less than 30 mins or so to complete.
Ensuring ALL data is correctly showing on every file. And no duplication etc.
eg. I have a file with 300 rows of data. Each row has numerical amount.
The total for example of the numerical data is 1,000,000
I want to divde this file into (x) files. eg 4 files. That means I want 4 files with approximately 300/4 = 75 rows each of data.
The total rows of each individual file should now be 75. And the total of a particular numerical column should be approximately 1,000,000 / 4 = 250,000
I also want to set a maximum numerical per file which is selected daily.
The division of files is different daily. Sometimes 3, sometimes 6 etc.
Should take a excel whiz less than 30 mins or so to complete.
Sean L.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
100%
Last project
8 Nov 2018
Australia
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies