Simple Excel Report Automation

$250-750 USD

완료함

게시됨

약 5년 전

$250-750 USD

제출할때 지불됩니다

1. Select 1 to 10 fields from the field mapping tab. (This will be designed so that the number of fields can be expanded to more than 10 or limited to less than 10) DataFileID is required to be the first column of every report and is not counted in the 10 field limit. This process should walk the user through the process of selecting an ordering the selected field. 2. The selected fields will then be used to query out data from the Landing Table. The fields that need to be retrieve from the landing table are: DataFileID FieldMapID FieldName FieldValue 3. The queried data will need to be cross tabbed, and saved as a new tab in the Landing Table Spreadsheet. |FieldName(1) |FieldName(2) |...|FieldName(10) | ------------------------------------------------------------ DataFileID |FieldValue(1)|FieldValue(2)|...|FieldValue(10)| 4. The selected fields need to be recorded, so that this report can be refreshed as needed, when data in the Staging Table is refresh. Without the need to re-select the fields. This system need to be able to hold up to 10 sets of fields. Example has been provided for reference only. [login to view URL] Field Mapping Populated Staging Table Sample Report 1 Sample VBA Form - Mock up of the VBA form to walk the user thru the field selection. Plus additional functional requirements. Example List of selected fields (See Field Mapping tab for example) Sample Queries from the database versions of this tool for requirement clarification.

Excel

Visual Basic

프로젝트 ID: 18722378

프로젝트 정보

30 제안서

원격근무 프로젝트

활동 중 5년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

프로젝트를 수여된 사용자:

@ParisPallas

Hi, Mark! I reviewed the instructions and the attached Excel spreadsheet carefully, and it makes sense everything mentioned in both places. I will charge you $450 and can deliver within five days (a single milestone to release once you're satisfied with the final result). Sincerely, Paris Pallas PS: Hopefully you have a good time while being on your ski trip.

$450 USD 7일에

5.0

(560 건의 리뷰)

8.5

30 이 프로젝트에 프리랜서들의 평균 입찰은 $388 USD입니다.

@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

$500 USD 6일에

4.9

(533 건의 리뷰)

8.4

@asin1987

Dear Employer, I understand what exactly you need and I will write a VBA application for you to achive what you are looking for. Please message me to discuss further. Thanks and Regards, Ash

$500 USD 10일에

5.0

(286 건의 리뷰)

8.3

@zekovicm

Hi there,I am Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

$466 USD 4일에

4.9

(162 건의 리뷰)

7.8

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best regards

$500 USD 10일에

5.0

(330 건의 리뷰)

7.4

@prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do make user form like your sample in attached file in project description :) please ping me now and im free now to start discuss , i just need to make sure everything before start working and im able to start workin today :) Thank you Galih :)

$250 USD 5일에

4.9

(417 건의 리뷰)

7.6

@dgled

I am a financial expert and guru in Excel/VBA/Macro. I have the skills to upload databases from excel files into forms/database in Excel and to generator financial reports, and charts. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, Furthermore, I have experience in dashboards, financial reports, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments, and bank reconciliation. With these skills, I develop financial modules including depreciation schedule, long-term debt, business valuation methodology & ratios. The modules incorporate complex components of business in a simplified and logical manner. I can do the project on Microsoft Excel in Window (and not in MAC) since your request to upload excel files from specific directories

$500 USD 10일에

4.9

(94 건의 리뷰)

7.5

@deepbluetech

Hi, I have had a look at the Excel file and have studied the description. Let me know if you are interested and we can discuss. Thanks, Arul

$400 USD 4일에

5.0

(202 건의 리뷰)

7.4

@ksriniravi

Greetings! Thanks for clear requirements. For the last requirement, is it ok to record the selected fields in the report tab itself (may be in an unused / not easily visible area of the spreadsheet if there is a requirement to avoid display these filter values to the user)? Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi

$250 USD 4일에

5.0

(258 건의 리뷰)

7.2

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Ok. Sure. Will do the reporting tool as instructed in the requirement. Willing to take up your project. Thank you, Regards.

$661 USD 6일에

5.0

(183 건의 리뷰)

7.0

@urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project

$250 USD 10일에

5.0

(61 건의 리뷰)

6.5

@citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

$250 USD 10일에

4.7

(89 건의 리뷰)

6.3

@lightingdavid

Hello. How are you? I am highly interested to work on the "Simple Excel Report Automation". I am a full stack Excel/VBA expert. I have more than 7 years experience in "Excel, Visual Basic". I will make sure the best quality service. Let us work together. Best regards, Yang L.

$250 USD 3일에

4.8

(99 건의 리뷰)

5.9

@kannasanthosh

Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in many data analytics projects involving SAS & R. Also I have worked in projects involving Excel (Pivot Table, Macros) and VBA. I believe I have enough expertise in Excel and VBA to complete this project as per your requirement. I am sure that you will be 100% satisfied with my work. Please get in touch. Looking forward to hear from you. Thanks & Regards, Santhosh

$333 USD 7일에

5.0

(38 건의 리뷰)

5.7

@rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.

$305 USD 1일에

4.9

(27 건의 리뷰)

5.1

@kahilH

Hello I am a highly skilled java developer with a large experience in data processing ,i offer to automate the process you described with a java console program and i guarrantee a very high accuracy Please contact me over chat to discuss more details Thank you in advance

$260 USD 10일에

4.8

(27 건의 리뷰)

5.0

@dataexplorer

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "

$300 USD 3일에

5.0

(18 건의 리뷰)

4.3

@bloowebs

Hello, I AM AVAILABLE RIGHT NOW. If you like we can discuss this project. I am technology specialist with several years experience in the fields of Data Science, Web Development, SEO, Bulk Emails, Document Processing, Web Security and server management. I work on low cost and deliver on time. My first preference is QUALITY. And I can provide your desired results for this project. Let me know if we can talk... Thank you.

$250 USD 3일에

5.0

(10 건의 리뷰)

3.2

@DominikKrivarics

Hi, I've worked on a similar project before so i think i would be a great fit. What's your deadline for this project? BR, Dominik

$555 USD 10일에

5.0

(6 건의 리뷰)

3.0

@VirtualBrainInc

Hello, I have briefly read the description on simple-excel-report-automation project, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well. I reach out to see whether the opportunity is still available. If the job’s no longer available, I’d appreciate you throwing my hat into the ring for any similar opportunities in the future. Thank you for your time, I look forward to hearing from you soon, Best Wishes, Kevin M.

$300 USD 6일에

0.0

(0 건의 리뷰)

0.0

@Michaelmichel

Hello dear.. I’m a technical office engineer and i have experience more than 5 year in data entry, My skills in Data entry is, • Proficient typing skills • Computer skills and a knowledge of relevant software packages • Basic literacy and numeracy skills • Organizational abilities • Administrative skills • Good communication skills, both written and verbal • Accuracy and good attention to detail • The ability to do the same task for long periods of time • The ability to work under pressure and to tight deadlines • A knowledge of health and safety policies • A good understanding of data confidentiality issues So . I can make a simple for free to prove my skills to you .. thank you for your time .

$250 USD 1일에