Create Spreadsheet Code

$250-750 USD

Closed

Posted

over 4 years ago

$250-750 USD

Paid on delivery

My name is Dulce, I am looking for some help with a spreadsheet. We have data that is changing sometimes daily. My goal is to make the workbook semi-automated. I have multiple sheets and will be adding more in the future, where they all have different data in it but I need all sheets to speak to the main sheet in the same workbook. The detail in this is that some of the data sometimes does not match row and column-wise from sheet to sheet. I need all sheets to consolidate into one and have the data merge using one identifier that is the same in all the sheets because it's the ID Number for our database. I was able to do this by using a regular query and using the name as what the data match with and that worked for the moment but as we added more sheets and more data, that was not able to sustain the spreadsheet in order. I need help making the data match in one sheet using the ID Number instead of the name. I know that was a bit confusing and I hope that makes sense. Please let me know if this is something doable and how much it will cost, time and money wise to accomplish this.

Project ID: 22306928

About the project

28 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

28 freelancers are bidding on average $351 USD for this job

@rajeshsonisl

Hi there, Could you share a sample Excel file with sample data ? I have a 99% project completion rate and a 4.99 reputation (out of max 5.0 from more than 1150 projects from a period of 12 years. Thanks. I look forward to hearing from you Best Regards, Rajesh Soni.

$500 USD in 7 days

4.9

(1071 reviews)

8.9

@schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

$250 USD in 3 days

4.9

(593 reviews)

8.6

@cgullapalli

Hi Dulce, I am good at Excel VBA macros and Data analysis. I can refer all the sheets and bring complete information using matching ID. Please share the file to review the existing formats. Looking forward to discussing in the chat and work on the project. -Chandra

$250 USD in 2 days

5.0

(1177 reviews)

8.4

@asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss. Thanks, Asad Khan FixIT Consultancy

$250 USD in 10 days

5.0

(750 reviews)

8.1

@branislavm

Hello! From your description, I think you are trying to use Excel as a database although it is a spreadsheet program. Have you thought to move the data into the real database? Can you send me your Excel file and I'll give you my opinion of what is best to do? Regards, Branislav Mihaljev

$450 USD in 7 days

5.0

(364 reviews)

7.9

@P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$300 USD in 3 days

5.0

(497 reviews)

8.0

@TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$250 USD in 2 days

4.9

(498 reviews)

7.4

@elqueabandona

Hello Dulce, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. I would like to help you organize and automate the entire process. Contact me to define the details. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards

$300 USD in 3 days

5.0

(329 reviews)

7.4

@Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 290+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """

$300 USD in 1 day

4.9

(278 reviews)

7.1

@ksriniravi

Greetings! I have reviewed your requirements and understand what needs to be done. I can write a macro to get the Master sheet updated with data from all the individual sheets. The fact that match row and column-wise from sheet to sheet can be addressed by macro. I do not see this being a $250 project - it should cost way below that amount. Since you have set the minimum budget as $250, I am not able to quote below that. Please share the actual Workbook. I would provide you with an exact quote. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi

$250 USD in 3 days

5.0

(246 reviews)

7.0

@dfexcel

Hi, With my expertise in the relevant techniques, I will upgrade the existing excel workbook to link multiple sheets to the main sheet as well as provide assistance on the data matching issues from sheet to sheet based on the ID number. Please revert to fix up a Skype call to discuss the finer details in order to finalize. Thanks, DC

$250 USD in 4 days

5.0

(26 reviews)

6.7

@MartinDudumi

Proper skills. Lot of Experience in similar positions. You will be satisfied with what you see . 10 years working with data Macros, vba and queries. Let me know for more.

$388 USD in 2 days

5.0

(52 reviews)

6.1

@zu02

Hello I hope all's well with you. I think better way via Ms Access...but can do directly in Excel using ADO/SQL vba. I'll detail on private chat. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f and see following screens for : "Access Attendance", "Invoice & book-keeping management" and " Create sales and purchases database application" . Those 3 app-s will give you a view what/how I can code for your project via Ms Access. Besides, I can provide access to any my MS Access application. I can code all based on your instructions - professionally and on time. I’m Ms Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab

$500 USD in 7 days

4.7

(73 reviews)

6.5

@VBAautomation

Hi, I have gone through with the details you shared and I think with these requirements MS Access relational database would be perfect. I can provide you best support on Excel or Access whatever you want. Please ping me to discuss the project details in detail and proceed with best solution. Thank you

$611 USD in 3 days

4.9

(41 reviews)

5.8

@dalsaniyasonu123

Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project done as you mentioned in the description. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Sapna Dalsaniya

$250 USD in 3 days

5.0

(49 reviews)

5.2

@sevillajk01

hello Dulce! let me help you with your project. Yes, it can be done. I hope we can discuss more on details of the project. Thanks, Ken

$250 USD in 7 days

4.9

(66 reviews)

5.5

@IgeS

Hi Dulce, It is possible so long as there is a unique identifier like customer ID’s and the header for each column is the same across all sheets. Can give me a screen shot of the masters sheet and the other sheets as well thus I can study its structure and tell me how often do you need to auto-populate the master sheet? Further more, are you using windows pc or Mac? Since I code exclusively for windows pc. My rate for this job is $300 and will take five days to complete. Please message me if this is any of what you need. I’ll be standing by to help. -Reggie

$333 USD in 5 days

5.0

(46 reviews)

5.4

@reubengi

Hi, This sounds like a classic problem in XL when trying to summarise data from several sheets. You have explained the issue well, but to know time and cost could you share a sample file so I can estimate how much work is required,. Regards. Reuben

$250 USD in 7 days

5.0

(25 reviews)

5.2

@dionisiotumbaga

Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.

$250 USD in 7 days