Create Spreadsheet Code

종료 등록 시간: 4년 전 착불
종료 착불

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.

엑셀 데이터 입력 마이크로소프트 엑세스 데이터 처리 PHP

프로젝트 ID: #22306928

프로젝트 소개

28 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 4년 전

이 일자리에 대한 프리랜서 28 명의 평균 입찰가: $351

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 for 기타

$500 USD (7일 이내)
(1071 리뷰)
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. Pl 기타

$250 USD (3일 이내)
(593 리뷰)
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 discus 기타

$250 USD (2일 이내)
(1177 리뷰)
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 (10일 이내)
(750 리뷰)
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 기타

$450 USD (7일 이내)
(364 리뷰)
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 (3일 이내)
(497 리뷰)
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 (2일 이내)
(498 리뷰)
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 기타

$300 USD (3일 이내)
(329 리뷰)
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 mor 기타

$300 USD (1일 이내)
(278 리뷰)
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 기타

$250 USD (3일 이내)
(246 리뷰)
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 기타

$250 USD (4일 이내)
(26 리뷰)
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 (2일 이내)
(52 리뷰)
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): [login to view URL] 기타

$500 USD (7일 이내)
(73 리뷰)
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 pin 기타

$611 USD (3일 이내)
(41 리뷰)
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 don 기타

$250 USD (3일 이내)
(49 리뷰)
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 (7일 이내)
(66 리뷰)
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 기타

$333 USD (5일 이내)
(46 리뷰)
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 기타

$250 USD (7일 이내)
(25 리뷰)
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 (7일 이내)
(11 리뷰)
4.9
serdaryalcin

Hello, It is an easy data manipulation work, please send me all data and let me make a proposal. Best Regards, Serdar Yalcin

$250 USD (7일 이내)
(25 리뷰)
4.6