We have an excel list with roughly 14,000 line items that represent batches of clients with multiple policies, but each policy is listed as a seperate item. What we need is an excel macro that checks the name value in a column, matches all similar names, and creates a sum of the data found in rows that match the row/columns with similar names. It should also drop that information into a 2nd worksheet so we're able to find just those multiple line items. However, we also want to include the single line items as well.
We're trying to find a total account value for accounts that have individual lines of business separated out by each row.
If this data would be better imported into a database program such as Access so we can search, filter, and export from a database then I'm interested in pursuing that as an option. So long as I'll be able to export that data in a mail merge, Excel or Access works just fine.
If this project completes successfully, a further one with about 76,000 entries may follow.
Hello. Below is example of similar projects done by me recently: Excel data converted to Access: https://www.freelancer.com.ru/projects/excel/Create-complex-report-from-table/details Post processing data using Excel V Plus
55 freelance font une offre moyenne de $131 pour ce travail
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. Pl Plus
Hello, I am ready to create excel macro or VB code in your given file. I need to discuss in details before tarting. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and Plus
Hi there,I am Excel/Access certified expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it Plus
Greetings sir, I have read your project details and i will develop the excel macro to you to group items in sheets based on names. Sir, i can deliver this project sooner than you expect and will be over your sati Plus
Hello, I can give this data to you in 5 hours, if you are looking to hire an excel professional that has sound knowledge in this domain and worked on similar lines, just drop a message.
Hi, I’ve done many similar projects where the task was to extract data from one sheet to populate it in another sheet as a structured database. I do projects by using algorithms and keywords. You will be able to add ke Plus
Hi, Using macro, I can complete the list within 1 hour with all requirements filled. Additionally, I can give macro to you, so you can use that in future for similar dataset. I am available right away to start. Plus
Hi I am an expert with great skills of data processing, Microsoft Excel, data entry and data management. I have successfully completed lot of tasks here means at freelancer.com. You can view my profile page for my ski Plus
Hi I can create a custom script to process such a file ("New 2020 Estimates" sheet with source data) taken as input, and it will output spreadsheet with highlighted rows, summed values and multiples listed, just like Plus
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
Hello, I am proficient with Excel and VBA and I have a lot of experience with creating macros. I would love to help you with this task. Please contact me for more information.
Hi , This needs to be done from an Access database. The data needs to be imported to Access, and then from there you can query it or export it to CSV files that you can use to mail-merge etc. I can do this for you a Plus
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel
Hi. From your project declaration, it's the kind of project that I have been experienced well. I have been experienced in programming including Ms Access, & excel VBA since 2000. During 2006-2013, I had been working as Plus
Hello, It would be my pleasure to build the macro for you. I have taken a look at the attached file and everything is simple and clear. Please open a chat with me and I will complete the work for you. You can Plus
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached excel file. I can develop a macro to find name in the column and sum of those valu Plus
Hi. I'm have a lot of experiences in JAVA, C, VB ,C++, VB.NET, SQL SERVER , SQL QUERY, .... And I also have experiences in Excel VBA developing and data mining. If you hire me, then I will try my best level for your Plus
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam Plus
Hey there ! This project can be done with Formulas and Macros in Excel ! I would love to help you out with this project. I am a good Virtual Assistant,Data Researcher,Data Entry Operator,Data Scraper,Great with E Plus
I have extensive experience in working with Excel Macros to automate data entry, processing and display. I will write the Macro to meet your directions exactly (as per the directions tab of your included file) and ens Plus