Excel VBA project

Job Description:

We would like our project to be written in Visual Basic that can be run as a macro in Excel as opposed to a separate Executable program that needs to be run outside of Excel.

We have an excel workbook with two worksheets. Sheet 1 is Call List and sheet 2 is our database. We need to populate the Call List sheet (sheet1) with the data from our database (sheet2).If the PostedByName column and Company column in both sheets have matching data, then import columns A, B, C, D from Database (Sheet2) into Call List (Sheet1).

CALL LIST (Sheet1)formatting instructions for worksheet1 (Call List):     1) Insert a blank column for A, B, C, D, and E

     2) title the new columns "Direct", "HQ", "Mobile", "Email", and "Notes"

     3) add filters for all columns (data>filter)

     4) delete rows that have "Staffing & Recruiting" in the industry column (column L)

     5) delete rows that are blank in the PostedByName column (column F)

     6) remove duplicate rows based on: Postedbyname, Jobtitle, Company, and Location. (if all four are the same, delete it).

     7) if PostedByName (column F) has duplicate entries, label the duplicate rows (excluding the first entry) as "duplicate entry" in notes (column E)

     8) insert PostedByURL (column O) to the immediate right of PostedByName (It will now be in column G)

     9) make PostedByURL hyperlinks active

     10) add colors and formatting to make the spreadsheet easily readable (look at our example, but it does not have to match exactly).

     11) rename sheet1 to "Call List" and sheet2 to "Database"

DATABASE (Sheet2)We also want to remove duplicate rows from Database (sheet2) based on the PostedByName and Company columns

Навыки: Excel, Visual Basic

О клиенте:
( 3 отзыв(-а, -ов) ) Macungie, United States

ID проекта: #35269010


(25 отзывов(-а))

28 фрилансеров(-а) готовы выполнить эту работу в среднем за $111


Hello, I am an Excel/VBA expert and I would like to help you with your macro. Please check my profile and contact me to discuss further details. Regards.

$200 USD за 3 дней(-я)
(497 отзывов(-а))

Hi! I am skilled Data Entry Expert with skills including Visual Basic and Excel. I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. 1 Больше

$30 USD за 1 день
(64 отзывов(-а))

I AM AVAILABLE RIGHT NOW ------------------------------------------------ Greetings! ----------------- I’m very much interested to your requirements and Job openings. I am a Professional in VBA Macro Excel with more ye Больше

$100 USD за 2 дней(-я)
(137 отзывов(-а))

Hello, I have read project details . I can help with this project. Can do within few hours. Sure. I have 15+ year experience in Excel, Excel VBA, Python and have 100% feedback You can trust, result will be excellent Больше

$55 USD за 1 день
(60 отзывов(-а))

Hi I have 8 years of experience in ⭐ Excel VBA ⭐. I've read the project description carefully and can start work immediately. Let`s discuss about more detail in chat box. Best regards!

$100 USD за 2 дней(-я)
(16 отзывов(-а))

Hello, I could help you Immediately to create the VBA and sheet formatting , and will complete the work as per requirement ASAP. Also sample could be provided. I am a Data Scientist and Excel Expert. I create top-not Больше

$30 USD за 1 день
(20 отзывов(-а))

Hi, Dear Employer, I am Al.A. I am a Ph.D. backgrounder and professional data scraper. I will provide you high-quality Excel file. I have worked on similar projects of excel/Excel VBA/CSV and can deliver professional e Больше

$100 USD за 2 дней(-я)
(5 отзывов(-а))

Hello. Excel VBA expert is here. I can do it perfectly. Looking forward to hear from you soon Scott

$140 USD за 7 дней(-я)
(2 отзывов(-а))

Hey! Excel VBA project is my favourite area of expertise and will be glad to help. I have skills in Visual Basic and Excel. Regards.

$100 USD за 3 дней(-я)
(2 отзывов(-а))

Hi. I"m good at Excel/VBA so I'm interested in your project. I've checked your project and I can do this job. Please get in touch, so we can discuss this further. Regards.

$155.56 USD за 1 день
(1 отзыв)

Hi, I have a lot of experience with data gathering,scrapping & VBA programming and Analysis. I am very detailed oriented with extensive data & QA skills. I also have more than 10+ experience as Business Analyst, Proj Больше

$200 USD за 7 дней(-я)
(1 отзыв)

Hello, I've read your proposal carefully. And that's me who you are finding now. I am careful in detail, so I can build your project successfully. I already have rich experience in - Node.js, React.js, Vue.js - React Больше

$120 USD за 5 дней(-я)
(0 отзывов(-а))

Hi, I can make a macro doing what you ask within this week end. I have done many macro modifying and filtering duplicates in the past. Thanks JPA

$30 USD за 1 день
(0 отзывов(-а))

I am an excel expert & complited my Advance excel course from a recognised coaching. Also worked with Akshar digital as an accountant by using Excel.

$99 USD за 3 дней(-я)
(0 отзывов(-а))

Respected sir/mam I am expert in excel sheet, Ms office, ms word etc. I will complete your projects under the time limit

$140 USD за 7 дней(-я)
(0 отзывов(-а))

Hi there My self Farhan, Having experience in this field for past six years dont worry about new freelancer am professional on it inbox me for more details i required i will done your project within 24 hours with 100% Больше

$40 USD за 2 дней(-я)
(0 отзывов(-а))

Thank you for your reading of my proposal sentence. I can say you Excel, VBA, Visual Basic is the senior skill I had a deal with many data changes, manage projects. business logic, and math formula, I am good at them, Больше

$140 USD за 1 день
(0 отзывов(-а))

Hola, mi nombre es Yaslee, soy capaz de realizar libros de Excel de una forma clara, con calidad y precisa. Soy una técnica graduada de IPL con 4 años de experiencia realizando trabajos en Excel. Me interesa su proyect Больше

$140 USD за 7 дней(-я)
(0 отзывов(-а))

hello sir I do this working your data shorting duplicate data removed . We are excited this works .

$100 USD за 2 дней(-я)
(0 отзывов(-а))