Quick Excel, VBA help - position of row globally with context of tab

$15-25 USD / hour

ปิดแล้ว

โพสต์

มากกว่า 4 ปีที่ผ่านมา

$15-25 USD / hour

I have an excel sheet with a bunch of tabs. each tab has some rows of items on it. I need two things from this quick project 1- I need to be able to run a function in the deliverable from you that will create a new tab with all of the other tabs combined and in order. basically we have to unwrap all of the other excel tabs and then show all on a single tab. we have been doing this manually and its a ton of work for no good reason. we dont need all of the columns on this new tab, we have a specific set of columns that we can identify with you that should be on this merged view. 2- we will then have a single view of all of the tabs on this one view we need to run some transforms on the data. 1 of the existing cells is a hyperlink. it has a text and has a hyperlink. we will want to split this to two fields so we have label and link as 2 things instead of just 1 today. im needing to get this knocked out really quickly so please place interest and some idea on turnaround time

Excel

Visual Basic

Data Processing

Visual Basic for Apps

Data Entry

รหัสโปรเจกต์: 20824834

เกี่ยวกับโปรเจกต์

34 ข้อเสนอ

โปรเจกต์ระยะไกล

ใช้งานอยู่ 5 ปีที่ผ่านมา

กำลังมองหาการสร้างรายได้ใช่ไหม?

ที่อยู่อีเมล

ประโยชน์ของการประมูลกับ Freelancer

กำหนดงบประมาณและกรอบเวลาของคุณ

รับเงินจากการงานของคุณ

อธิบายข้อเสนอของคุณในภาพรวม

ลงทะเบียนและเสนอราคาฟรี

34 ฟรีแลนซ์กำลังเสนอราคาโดยเฉลี่ย $19 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

$20 USD ใน 40 วัน

4.9

(364 รีวิว)

8.0

@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.

$25 USD ใน 40 วัน

4.9

(348 รีวิว)

7.4

@paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will get data from multiple sheets, manipulate it and present it in another sheet. The Excel file will run on PCs. I will charge you $25/hour and I expect to spend 3-4 hours on it. I can deliver tomorrow at around 11 am Athens time. I'm among the most experienced and skilled Excel, and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 320 projects successfully in six years, and I feel confident in achieving your task as well. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.

$25 USD ใน 10 วัน

4.9

(253 รีวิว)

7.5

@MohsanEijaz

Hi there, I am excel and vba expert, I have complete more than 100 projects with 5star feedback, lets discuss and start your project.

$15 USD ใน 40 วัน

5.0

(88 รีวิว)

6.3

@expertatwork

Available right away. Please reply, we can get started. Thank you.

$20 USD ใน 4 วัน

4.8

(205 รีวิว)

6.1

@nvchien94

Hello there, I am an Excel expert and I can start working right now. I think it is simple project with few script to do. I also working as Cost controller so costing is familiar with me. Please send me a message because I can not direct send you. Thanks.

$20 USD ใน 5 วัน

5.0

(170 รีวิว)

6.1

@rashedkhanrubel

Hi, I have understand the project requirement & interested to compile & segregate data for this project. Please send a message so we can discuss more & start the project. Thanks.

$15 USD ใน 40 วัน

5.0

(99 รีวิว)

5.4

@bhupendrayadav

I am postgraduate with more than 5 years of experience in advanced excel based tools, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you

$20 USD ใน 40 วัน

4.9

(40 รีวิว)

5.6

@vsprybhanu

Hi, I can develop excel vba program to combine all sheets into one and perform required functions. I will finish this project within 1 day. I am experienced Data Analyst and Macro Developer and have done mostly Excel VBA Programming jobs. So, can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra

$20 USD ใน 40 วัน

4.8

(100 รีวิว)

5.8

@afenache

Hi, I can write a VBA script to merge your excel tabs into one sinhle tab with selected columns and split the hyperlink field into to separate fields. I can finish the project thos weekend. Best regards, Florin Enache

$20 USD ใน 40 วัน

5.0

(22 รีวิว)

5.3

@AnowarRatul

$ 15 ONLY!!! In just 5 Hours!! [EXCEL VBA MACRO & FORMULA EXPERT] Sir, please CONTACT with me, I can SEND you a DRAFT project file to ensure my EXPERTISE. If you are 100% satisfied first, then please award me the project. You can see my profile to get overview of what my past employers think about me. I will be very much grateful if I get opportunity to work for you. Thanks, Anowar

$15 USD ใน 5 วัน

5.0

(66 รีวิว)

4.8

@Orientwork

hello sir ! as per work , i am ready to reduce my rate??? please talk to start this work. i can do it as per your instrections, regards

$15 USD ใน 40 วัน

4.4

(71 รีวิว)

5.2

@xinglong717

Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Looking forward to hearing from you. Thanks.

$20 USD ใน 40 วัน

4.8

(11 รีวิว)

4.2

@ielucerotrad1

I can get the job done! About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).

$15 USD ใน 40 วัน

5.0

(21 รีวิว)

4.2

@MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.

$15 USD ใน 40 วัน

4.9

(10 รีวิว)

3.8

@habalghost22

Hi , I am an MBA professional have 4yrs of experience in Analytics, Tableau, Advanced Excel, vba and Python. I have done ample amount of work in this area and would be happy to share it with you to showcase my skills. Being an Analyst I use excel and vba in daily tasks and this should be easy for me. Expecting this project to be completed within a day, if I got the requirements correctly. Looking forward to work with you. Cheers.

$17 USD ใน 30 วัน

5.0

(7 รีวิว)

2.8

@shepherdrichard

Hi I have extensive experience of using Excel and Access VBA, working for large banks and writing software for regulatory reporting. I have written several books on the subject, published by McGraw-Hill in the USA. Search on Amazon using ‘shepherd vba’ to see my books. I am also on LinkedIn – search on ‘Richard Shepherd FCCA’ I can do this project within the next week I hope to hear from you soon

$25 USD ใน 40 วัน

5.0

(2 รีวิว)

2.7

@Ahzakaria

I have an excellent experience in the following: - Data Entry - Scrapping Web Site - Excel Functions - Design KPIs - Design Dashboard - Excel VBA Developer - Access VBA Developer - Outlook VBA Developer - Data Analysis - Logistics & Supply Chain Excel Professional - Able to create Add-Ins for excel program and create automated tools - Java Developer

$20 USD ใน 20 วัน

5.0

(2 รีวิว)

2.7

@rocero

Hi, I've completed very similar job like yours last week. You can check from here: https://www.freelancer.com/projects/excel-vba/Add-summary-table-counting-rows/details I includes, creating a new sheet from other sheets of data, also some columns have hyperlinks, sort and summary of values etc... I have a lot of experience on vba. I can do your job in short time and with high accuracy. Kind regards

$20 USD ใน 20 วัน

5.0

(1 รีวิว)

2.3

@vw1514518vw

Ready to develop the required code to create the automation and split the hyperlinked label and link You can Send or attach the excel book,and specify the set of column or range from each tab to be included in the output tab, I will prepare you a sample and send it back to you free of charge as a demo before awarding the project Estimated time to deliver is 2 to 3 days, depending on some details to be known on implementation, with a minimum of $100 USD and max of $200 USD Regards, Rageh

$15 USD ใน 8 วัน