Create Spreadsheet Code
$250-750 USD
착불
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.
프로젝트 ID: #22306928
프로젝트 소개
이 일자리에 대한 프리랜서 28 명의 평균 입찰가: $351
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 for 기타
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. Pl 기타
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 discus 기타
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
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 기타
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.
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
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 기타
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 기타
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.
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 pin 기타
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 don 기타
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
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.
Hello, It is an easy data manipulation work, please send me all data and let me make a proposal. Best Regards, Serdar Yalcin