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

$40-75 AUD

I përfunduar

Postuar

over 5 years ago

$40-75 AUD

Paguhet në dorëzim

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 e Projektit: 18266526

Rreth projektit

11 propozime

Projekt në distancë

Aktive 5 yrs ago

Po kërkoni të fitoni para?

Adresa e email-it

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj

Paguhuni për punën tuaj

Përshkruani propozimin tuaj

Është falas të regjistrohesh dhe të bësh oferta për punë

I dhënë për:

@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 në 0 ditë

5,0

(791 përshtypje)

7,9

11 freelancers are bidding on average $72 AUD for this job

@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 në 4 ditë

4,9

(285 përshtypje)

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 në 10 ditë

4,9

(57 përshtypje)

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 në 10 ditë

4,9

(24 përshtypje)

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 në 2 ditë

4,9

(29 përshtypje)

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 në 10 ditë

5,0

(15 përshtypje)

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 në 1 ditë

5,0

(7 përshtypje)

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 në 1 ditë

4,9

(8 përshtypje)

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 në 0 ditë

5,0

(16 përshtypje)

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 në 1 ditë

4,6

(10 përshtypje)

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 në 1 ditë