Excel VBA project
$30-250 USD
货到付款
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： #35269010
关于项目
授予：
有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.
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 更多
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 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% 更多
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 更多
hello sir I do this working your data shorting duplicate data removed . We are excited this works .
