Excel VBA project
$30-250 USD
Dibayar saat pengiriman
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
ID Proyek: #35269010
Tentang proyek
Diberikan kepada:
28 freelancer rata-rata menawar $111 untuk pekerjaan ini
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.
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
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!
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 Lebih banyak
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 Lebih banyak
Hello. Excel VBA expert is here. I can do it perfectly. Looking forward to hear from you soon Scott
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.
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.
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 Lebih banyak
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 Lebih banyak
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
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.
Respected sir/mam I am expert in excel sheet, Ms office, ms word etc. I will complete your projects under the time limit
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% Lebih banyak
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, Lebih banyak
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 Lebih banyak
hello sir I do this working your data shorting duplicate data removed . We are excited this works .
