In Progress

Excel spreadsheet data manipulation - repost

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 sample data manipulation, sales entry excel

About the Employer:
( 0 reviews ) AMPARA, Sri Lanka

Project ID: #4923898

Awarded to:

florianfilat

Dear Sir, I did several tasks like that and it is quite easy. I have prepared for you an example on how I would like to approach - you can download it from [url removed, login to view] More

$2 USD / hour
(1 Review)
0.4

37 freelancers are bidding on average $4/hour for this job

rahulrahangdale

I am interested to do work for you. I am having 4 year experience in Research and data entry. I am eCommerce Product uploading Expert in my last organization from 1.5 years.

$5 USD / hour
(7 Reviews)
3.7
smb310570

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

$5 USD / hour
(13 Reviews)
3.3
Ayan

Hey, Being an excel expert, I can promise you this task to be completed within 4 hours. Please let me know if you are interested. Thanks, Ayan

$5 USD / hour
(5 Reviews)
2.4
annajoseph

Hi…I am Anna. I am passionate about writing. I am willing to do your job within your time. No doubt about the quality. I am new here but have 3 years of professional experience in article & short story writing, Web res More

$2 USD / hour
(1 Review)
0.0
adinahana2012

I love to work in Excel, collecting data, it's my favorite work. I have an University degree in Informatics.

$5 USD / hour
(0 Reviews)
0.0
danielailoaie

Hello! I can think of several ways to have your datasheets show exactly what you need. Just give me a chance to prove that to you.

$4 USD / hour
(0 Reviews)
0.0
muhio

Hi, I have several years experience of data manipulation and working with reporting tools, such as simple Excel, MS Access, Business Object or Impromptu. My experience ranges from MS Office data sources to large mainf More

$5 USD / hour
(0 Reviews)
0.0
kanchan1979

Respected Sir, I am a homemaker. I am interested in online jobs. I do take ownership and responsibility for this job to complete it on time accurately. I can spend around 2-3 hours per day to complete the job. More

$3 USD / hour
(0 Reviews)
0.0
harisudha88

I am interested to do this job. I am data entry worker. Waiting for the oppurtunity. Lets start. Thank you

$2 USD / hour
(0 Reviews)
0.0
niraj12345

“Well, I have all of the skills and experience that you’re looking for and I’m confident that I would be a superstar in this project management role.

$5 USD / hour
(0 Reviews)
0.0
gauravsaini2962

This is quiet easy I can give u solution in less than 1 hour just give me a chance it can be the start of my success story I expect a positive response And a phrase also "I m not handsome but i can give my hand More

$2 USD / hour
(0 Reviews)
0.0
evecriz

I am a vibrant, independent person and very passionate in word processing, spread sheet creation and slide show presentation. This position will allow me the opportunity to synergy my qualification working experience More

$4 USD / hour
(0 Reviews)
0.0
tmoore562

15+ years working with / teaching Excel. I have look at your sample and I believe I understand what you need. I can do this job. In fact, I can create a spreadsheet that will automate the process. Let's get to work!

$3 USD / hour
(0 Reviews)
0.0
harshalpuri

Ready for the work ............ Give the demo file to see my work ...... u will we very happy from my work .... i have been make many excel temple from these type of work for many companies

$2 USD / hour
(1 Review)
0.0
wvikas

i got your point sir, you are right there is an easy way for this through filters. i am ready for the project.

$3 USD / hour
(0 Reviews)
0.0
sandragrant

I can have this done quickly and accurately. Available to start immediately. I can provide 20 hours per week but would prefer to work at fixed rate.

$3 USD / hour
(0 Reviews)
4.0
annantjain

I have sound knowledge of MS excel (Advanced) and VBA coding. Certified by Microsoft also in MS Excel. Having more than 5 years of experience

$5 USD / hour
(0 Reviews)
0.0
medikon

Master in Excel and data analytics and have more than 10 yrs experience. Expertise in delivering the quality within the timelines.

$5 USD / hour
(0 Reviews)
0.0
gnspvtltd

Dear Sir, At the outset we would like to thank you for your time. We are a new BPO @ Chitradurga which is 250 kms away from Bangalore. We mean 25% of cost reduction with BPO expenses and hence on your bill... More

$2 USD / hour
(0 Reviews)
0.0
onlyLekha

HI there i can start work anytime...............................................................................

$7 USD / hour
(0 Reviews)
0.0