VBA in Excel | Combine all sheets into one page + conditions

$40-75 AUD

完了済み

投稿日:

5年以上前

$40-75 AUD

完了時にお支払い

Hi there, Looking to have a freelancer update an Excel document's VBA script to provide better outcome. Attached is file (see 'Master_Contact_List' tab), which combines all sheets into a single page. Hoping to have the below achieved for 'Master_Contact_List' tab: #1 Only use columns A-J from other sheets (not collect entire sheet) #2 Have predefined heading and heading columns in master page (right now it is duplicated as copied from each sheet) - this includes new columns that show sheet's name. #3 Where a name appears within a sheet, write 'Yes' under that column #4 Where a name appears in more than 1 sheet (match with first_name and last_name), please show 'Yes' under the sheet's name in these new columns. #5 Only display distinct values (remove duplicate names) #6 Display the master contact list sheet with no additional formatting / colours. Please write 'Master_Contact_List' in your response so I can confirm you have read this brief. I look forward to receiving your bid.

Excel

Visual Basic

Visual Basic for Apps

プロジェクト ID: 18266526

プロジェクトについて

11個の提案

リモートプロジェクト

アクティブ 5年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@cgullapalli

Master_Contact_List HI, I am good at Excel and vba. I have referred the requirements. Looking forward to work on the project to transfer the data between sheets and discuss in the chat. -Chandra

$75 AUD 0日以内

5.0

(791 レビュー)

7.9

この仕事に11人のフリーランサーが、平均$72 AUDで入札しています

@schoudhary1553

Hello, Hope you are doing well. I can help with you in your project VBA in Excel | Combine all sheets into one page + conditions. I can assure you the quality job. I have good experience in Excel, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,

$180 AUD 4日以内

4.9

(285 レビュー)

7.6

@rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

$66 AUD 10日以内

4.9

(57 レビュー)

5.6

@supergana

I am an IT professional with 2 decades of experience. As far as excel is concerned i am quite well versed with the technology which i have mastered over 2 decades. I can handle simple excel with formulas to complex power pivots with macros with ease.

$66 AUD 10日以内

4.9

(24 レビュー)

4.6

@jasalaz100

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.

$77 AUD 2日以内

4.9

(29 レビュー)

4.8

@dalsaniyasonu123

Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

$50 AUD 10日以内

5.0

(15 レビュー)

3.6

@lightingdavid

Hello How are you? I have reviewed "VBA in Excel | Combine all sheets into one page + conditions" .I have good skills for these (Excel, Visual Basic, Visual Basic for Apps). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. I hope to work with you. Thank you.

$70 AUD 1日以内

5.0

(7 レビュー)

3.7

@akritisood94

Dear Recruter As a VBA developer, I have been busy the past few years, designing, analyzing, and developing new VBA applications – with a difference. My experience in this regard is quite vast. Over 4 years of experience in maintaining and improving existing VBA applications, as well as reverse engineer current macros by debugging and stepping through code, makes me an excellent person to consider for a VBA developer position at your company. As a highly analytic and organized individual, I can proactively clarify and question business requirements, in relation to system capabilities. Moreover, these skills help me in effectively analyzing and converting business requirements to develop VB applications, and perform well-placed object oriented designing and analysis. Owing to the fact that I am a diligent individual, I can perform testing work in an exceptional manner, aiming for optimal performance.

$63 AUD 1日以内

4.9

(8 レビュー)

3.5

@paulodayto08

Master_Contact_List Hi Good Day! A serious freelancer here! I can help you to complete this project in less than 1 day. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to complete every project. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!

$50 AUD 0日以内

5.0

(16 レビュー)

3.5

@kumarapush777

"Master_Contact_List" Hi, I will be able to complete this task in quick time. My experience will be of great help for you in optimizing or completing other daily office tasks as well. General Profile Information: Also,I am 12 yrs Experienced in Excel,Python,Php, Office/web Automation & blogging on Office Tricks & tips. I work full time in here & will be able to start your work immediately. Services Provided: 1. Excel Macro (VBA) - Web Scraping & Automation 2. Python - Web Scraping 3. Excel Pivot Charts & Tables 4. Excel Auto Filter, Vlookup, Formula Assistance 5. Excel to Access 6. Sending Email from Excel 7. Extract Data from Webpages Please drop a message once you feel comfortable with my profile & lets get started. Thanks for your time

$45 AUD 1日以内

4.6

(10 レビュー)

2.6

@YasminaKhafagy

I can do the work and deliver exceptional results. I possess a combination of skills and experience that make me stand out from the crowd. regards, Yasmina

$50 AUD 1日以内