In Progress

Microsoft Excel Spreadsheet CSV Sorting Data - Domains & Email Accounts into Reports

We have a current Excel spread sheet where by we can insert data and it sorts it out into our desired requirements. Attached is this sheet along with samples of the raw .csv files which we input. This is still required and should not be changed.

We would like to either modify this sheet or have a new sheet created whereby we can have new outputs that we require.

These being:

1> Create a a New Sheet Name of our Choice (Customer/reseller name)

2> Specify the domain names that we want under this sheet

3> Output should list the email accounts under the domain. The Size of the Email Accounts. And give a Break down of how many accounts there are. eg 10 x 50GB, 5 x 10GB, 2 x 500MB (Please see examples attached Savuti Recon, Systematix Recon, Stream Line Recon)

ATTACHMENTS

exchange_Stats_Tool - This is our current working Sheet. You will notice 3 x Output Tabs which are generated from the attached .csv files. You can delete these 3 tabs and input the .csv files to see the operation.

3 x .CSV Files - EXMAIL, EXMAIL2, SPURGROUP These are the raw logs inputed into the sheet to create the existing report.

3 x PDFS - Savuti, Systematix, Streamline - These are examples of what we are looking for in this Job.

a) Add CSV eg exmail

b) Name a new Sheet (Eg Reseller/Customer)

c) Specify the domains that should included in this report

d) Output should be as per example.

Skills: Excel, Data Processing, Visual Basic, Data Entry, Microsoft Access

See more: convert excel spreadsheet csv upload, microsoft excel spreadsheet templates birth date pools, microsoft excel spreadsheet managerial work, office 365 email activity report powershell, office 365 email reports, office 365 export list of users with license type, sort email addresses by domain name online, how to sort by email domain in excel, excel extract domain from email address, office 365 sent and received mail report, office 365 email activity report shared mailbox, excel spreadsheet analyze stock data, convert microsoft excel spreadsheet apple numbers, partime excel spreadsheet form filling data entry, convert microsoft excel spreadsheet numbers, microsoft excel query csv file, excel spreadsheet csv template, excel spreadsheet containing sales data, merging microsoft excel spreadsheet different text files, excel spreadsheet merge row data word

About the Employer:
( 9 reviews ) Bedfordview, South Africa

Project ID: #24078431

32 freelancers are bidding on average $21 for this job

ssuet123

Hey there, Hope you are doing fine. I have been doing work in Microsoft scripting, VBA, formulas, graphs and dashboard creation using pivots, for the past 5 years. I have checked your attached sheets and read all the More

$10 USD in 1 day
(25 Reviews)
6.3
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets More

$30 USD in 1 day
(99 Reviews)
5.7
skgtechnologies

Dear Client, I am a full time virtual assistant having all round knowledge and ability to perform various tasks. My services include social media management, blog management, internet research, and internet market More

$30 USD in 1 day
(24 Reviews)
5.2
SamehFrag

Hi I have taken a look at the attachments. I can do this project at a reasonable price and in high quality And in a short time I will give you a sample from my work on Excel, Word and PDF

$20 USD in 2 days
(1 Review)
1.6
satramdas1965

hi there, how are you?, i had read the description you provided about the project, i know how to do this job and i can do your work very effectively in very less time possible. open chat to get started now............. More

$11 USD in 1 day
(2 Reviews)
0.7
sulanlotha

Hire me Relevant Skills and Experience I'll do this for you

$25 USD in 1 day
(0 Reviews)
0.0
mohit181990

Advanced knowledge of MS Office and have 8 Years of experience in Project Management with technical details. working on excels from last 10years now.

$23 USD in 7 days
(0 Reviews)
0.0
sambehappy36

Sir I can work on your project and can sort the data after import into master [login to view URL] automate the sorting process too.

$25 USD in 3 days
(0 Reviews)
0.0
leiyonz

Leave a message and more detail info to work on then I can show you some result in few hours if you want to Bring it on... I've been playing with: Data Warehouse | ETL | Business Intelligence | Analytics | Data Insi More

$30 USD in 7 days
(0 Reviews)
0.0
khaliqasyed

Hi My name is Khaliqa Shahmeer. I’m expert in making projects and assignments on MS Office ( Word,Excel,Powerpoint,etc.). I’m Experienced in data entry, web research and coding in C++. I will complete your work on time More

$10 USD in 1 day
(0 Reviews)
0.0
khilles

if you asking for some one to say its a piece of cake will it's me how can do that for you i'am a civil engineer who is pro when its come to Excel And MS program and others of course so you can be confidant enough an More

$20 USD in 1 day
(0 Reviews)
0.0
hardikvasoya4126

hello sir/mam, i have excellent skill for typing in ms word and excel file.i would make this new sequence in proper way without any kind of [login to view URL] me a chance to work with me to create a culinary output from i More

$25 USD in 7 days
(0 Reviews)
0.0
devkotabharat134

i am an Electrician and i have completed my 12 from college and i like hard work i have completed my higher education i have following skill which i have written to remind myself . Data entry,Microsoft word document,ex More

$20 USD in 7 days
(0 Reviews)
0.0
chynitesh

I work fine Relevant Skills and Experience 2 Year

$25 USD in 1 day
(0 Reviews)
0.0
arunkr04565

Hello sir, I'm read your project. I'm interested for this project.t Please hire me. Relevant Skills and Experience I have good knowledge in excel.

$25 USD in 3 days
(0 Reviews)
0.0
akashss1988

I can do quality work with low cost as I have been a professional in this field for over 12 years. I have varied experience in the job expected from this assignment

$15 USD in 2 days
(0 Reviews)
0.0
spnayakelectric4

I will be able to transcribe large amounts of information accurately and quickly. Good time-management and interpersonal skills I will be able to describe strategies I use to ensure that they're accurately transcribing More

$10 USD in 7 days
(0 Reviews)
0.0
iOmarHabib

Hello! •I'm a fast writer with writing speed of "54~62 WPM" and "271~308 CPM". •Very good with "Microsoft office" Package. Just know if i applied to work on your task then i'm 100% devoted to it.

$20 USD in 2 days
(0 Reviews)
0.0
bramarambikavns

Hello and thank you for visiting my profile. Being a full time freelancing professional I am mostly online for communication with my clients. Freelancing is my profession as well as my passion. I have over 2 years of e More

$20 USD in 7 days
(0 Reviews)
0.0
rk38486

I have the ability to do this work within time, but the remuneration should be met at the right time

$20 USD in 7 days
(0 Reviews)
0.0