Closed

Excel spreadsheet data manipulation - repost 2

We have a spreadsheet with a large set of sales data in a single worksheet. We sell to a number of organisations each of whom has a number of branches. There is one record for every branch with a number of fields - perhaps 30 or more fields. So the detail (simplified) looks like this:

Company Branch Sales this year Sales last year ...

A 1 124 144

A 2 653 445

A 3 0 25

B 1 25 12

B 2 0 0

.

etc

.

So, to confirm, this is all one worksheet. There will be maybe 10-15 companies and all together about 4000 records.

We want to split the data up so we have 2 extra tabs in the workbook for every unique company in the list(ie A,B...). The first tab for each company contains the records of that companies branches with non-zero sales this year, ie in the example

A 1 124 144

A 2 653 445

Tab name A-Active

and the second tab contains the records of the branches that had zero sales this year, ie

A 3 0 25

Tab name A-Dormant.

Similarly for company B - we get B-active and B- dormant, which are the records for the trading and non trading branches of company B.

I am hoping there is some really simple solution using filters. The company names could probably be "hard wired" since there are only about 15, a more complex solution would look for unique values.

The new tabs should ideally contain simple excel data with the headers (1st row) repeated.

I have a sample full size data set with real data. enclosed show the principle only on a tiny scale.

Skills: Data Entry, Excel, Microsoft Access, Powerpoint, Word

See more: excel spreadsheet companies, data entry worksheet, excel workbook companies, simple excel, row spreadsheet, complex data entry, spreadsheet manipulation, number manipulation, spreadsheet sales, data entry worksheet excel, excel unique, excel sales worksheet, excel split, company name trading, sample excel worksheet, full detail sell, zero data entry, sample list companies names excel, trading excel spreadsheet, excel companies list, number company list excel, excel record entry sample, split full name excel, excel macro create spreadsheet template list data, data entry excel list email phone search

About the Employer:
( 0 reviews ) Chennai, India

Project ID: #4923994

46 freelancers are bidding on average ₹221/hour for this job

pandeypriya2003

Hello, We highly recommend our team for your work. They have vast experience in data entry projects like data mining, data research, email scrapping. We are capable to provide excellent work with sharp accuracy and More

₹154 INR / hour
(513 Reviews)
7.5
smb310570

Please give me the sample full size data set with FAKE data so that I can make a macro to make the tabs as you said. This macro then can be copied to actual worksheet to do the real job. Thanks.

₹150 INR / hour
(13 Reviews)
3.3
SiroosJafary

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. your project solution suppose to be a n More

₹333 INR / hour
(5 Reviews)
2.7
samin59

Have more than 7 years freelance Academic and professional writing experience. My expertise includes: Excellent command over MLA, APA, Harvard, Chicago. Can provide services in finance, statistics, marketing, HRM More

₹421 INR / hour
(5 Reviews)
2.3
danaldea

Hello, Your project is simple enough so I could not ask more with a clear conscience. I've got 5+ years of experience working with MS Office automation (mostly Excel) and I have done some work on [url removed, login to view] (I' More

₹100 INR / hour
(2 Reviews)
1.7
florinfaur

This is very simple, I can do it in a few hours. Send me the file and then I'll tell you exactly how long it will take.

₹111 INR / hour
(1 Review)
0.8
Mvndr4u

It is my great pleasure to take the opportunity to review your requirements and submit a quick proposal. Depending on all of the skills you are looking for, I may be a great fit and the standards by which I work are ba More

₹166 INR / hour
(1 Review)
0.4
kartikprmr

Hi, I am expert in excel. I can do this job very efficiently and quickly. I have created a spreadsheet with hypothetical data (15 different company and each company has branches more than 100). Now I have categorized t More

₹277 INR / hour
(1 Review)
0.0
sujithkumar1989

I understood the project needs. I have good experience in data entry position. work will be completed with in the time limit

₹277 INR / hour
(0 Reviews)
0.0
ExcelSuresh

Hello Raghu, I can do this work for you. Trust me!!! Request you to accept my bidding! நன்றி, சுரேஷ்

₹100 INR / hour
(0 Reviews)
0.0
Toy20

Dear Hiring Manager, I have found this job post in freelancer, and I’m very interested in your job post involving these skills. I have good experience in data entry, web research etc. Documents and MS Office. My typi More

₹111 INR / hour
(0 Reviews)
0.0
GEGG

Hi sriraghu786, I'd like to take a look at the sample data to give you a more accurate proposal, this might be simpler than it looks. Give me a chat if possible. Kind regards,

₹170 INR / hour
(0 Reviews)
0.0
neeta2310

Hi , You have given very good Example. I can work on that part easily. and can also generate extra report by using SQL and MS Access if u required as my value addition. I am engineering graduate with highly analytical More

₹100 INR / hour
(0 Reviews)
0.0
sandyporcincula

I can do this. I have much exposure in Excel and its functions. Hope you can consider me for the job.

₹444 INR / hour
(0 Reviews)
0.0
lukaknol

Hello, so you have more tables or only one? Can I get the data so I can get you the example for free. Regards, Luka

₹277 INR / hour
(0 Reviews)
0.0
dalmiayash

Hi, I am a new freelancer here but I have 2 years of offline experience in working with Microsoft Office. I would take a maximum of 3-4 hours to finish this. I would be using the combination of Company name and branch More

₹173 INR / hour
(0 Reviews)
0.0
casu18

I would do my best to finish this job in time! I have experience working with database. In my 4 years of college I worked with the Microsoft Office package at a high level. I hope you will consider me for this job. More

₹166 INR / hour
(0 Reviews)
0.0
cravisekhar

Hi, I am good at excel and can work on this. I have 8 years of experience working on data entry, excel related works, etc. please revert back to me so that we can work out this.

₹150 INR / hour
(0 Reviews)
0.0
kumars1960

I am experienced in excel sheet send me sample I will do it. Now I have already one compny data sheet.

₹111 INR / hour
(0 Reviews)
0.0
tjigrz

Hi,I can do project sharply and accurately up to your satisfaction. Please release payment when you feel satisfied. Will need more information about how you want to get it done? Many Thanks and Regards

₹222 INR / hour
(0 Reviews)
0.0