Excel spreadsheet
- or -
Post a project like this2686
$$$
- Posted:
- Proposals: 25
- Remote
- #1361127
- Awarded
Spreadsheets and Databases Development, Data Mining, Development (VBA, Visual Basic, SQL), Finance, Financial Markets
Denny
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
31556111351941439066143742914323661430565141589014140071371827134527312373831192798
Description
Experience Level: Expert
General information for the business: I need all my data on excel sorted and organised.
Description of excel work: I need all my data sorted and organised.
I will send you all my data I have on excel spread sheets.
I would want it composed onto one spread sheet with a tab for each individual sport. I would want all the columns to be the same for all the sports (club name, address, telephone number, etc.).
There will be approx. 50 tabs with all the different sports (badminton, football, cricket, etc.) but I would also like one tab to be named MASTER. Under the ‘master’ tab, I would want a list of all the clubs together.
If any of the information is updated under the ‘master’ tab, I should automatically update the individual sport tab. If I was to update any of the sports tab, the ‘master’ tab would also be updated.
For example. If I update the telephone number for a Kite Flying club on the ‘master’ tab, then this information should be updated on the ‘Kite Flying’ tab. Also, if I was updating information on the ‘Kite Flying’ tab, then this should be updated on the ‘master’ tab. Does this make sense? If not, please let me know as this is essential.
Also, any duplicates, can you remove them and tidy up the database. Make sure that the club is a duplicate as several clubs across the country have the same name but different address, contact numbers, etc. Before removing any duplicate, please make sure any valuable information isn’t lost or deleted but moved over to the record we are keeping before removing the duplicate.
If this task is for you, can you send me a reply telling me how long this project will take and the cost? Can you also send a small sample to show you understand the concept. I have added a file for you to send back as a sample.
No time wasters or people who do not have the skill set to perform this task. if no sample sent, don't expect a reply.
Extra notes: No time wasters or people who do not have the skill set to perform this task. if no sample sent, dont expect a reply.
Description of excel work: I need all my data sorted and organised.
I will send you all my data I have on excel spread sheets.
I would want it composed onto one spread sheet with a tab for each individual sport. I would want all the columns to be the same for all the sports (club name, address, telephone number, etc.).
There will be approx. 50 tabs with all the different sports (badminton, football, cricket, etc.) but I would also like one tab to be named MASTER. Under the ‘master’ tab, I would want a list of all the clubs together.
If any of the information is updated under the ‘master’ tab, I should automatically update the individual sport tab. If I was to update any of the sports tab, the ‘master’ tab would also be updated.
For example. If I update the telephone number for a Kite Flying club on the ‘master’ tab, then this information should be updated on the ‘Kite Flying’ tab. Also, if I was updating information on the ‘Kite Flying’ tab, then this should be updated on the ‘master’ tab. Does this make sense? If not, please let me know as this is essential.
Also, any duplicates, can you remove them and tidy up the database. Make sure that the club is a duplicate as several clubs across the country have the same name but different address, contact numbers, etc. Before removing any duplicate, please make sure any valuable information isn’t lost or deleted but moved over to the record we are keeping before removing the duplicate.
If this task is for you, can you send me a reply telling me how long this project will take and the cost? Can you also send a small sample to show you understand the concept. I have added a file for you to send back as a sample.
No time wasters or people who do not have the skill set to perform this task. if no sample sent, don't expect a reply.
Extra notes: No time wasters or people who do not have the skill set to perform this task. if no sample sent, dont expect a reply.
Zahid A.
100% (3)Projects Completed
10
Freelancers worked with
10
Projects awarded
45%
Last project
8 Mar 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Zahid,
I have some questions before I submit a proposal.
1. If your data is currently spread across about 50 Excel files, are these in the same format, with the same columns for the address etc?
2. How do you want to handle duplicates where one club provides different sports? If it is the same address but a different sport, are these duplicates or not?
Kind regards,
Simon C.
231023
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