Excel Macro and/or Database information

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.

Evner: Dataindførsel, Databehandling, Excel, Software Arkitektur, Visual Basic

Se mere: excel macro enter data database, excel macro websites information, macro excel update database, macros in excel for beginners, how to automate excel reports using macros, excel macros for dummies, excel vba, excel macros tutorial, excel macros 101, excel macro examples, excel macros, macro word information word excel, excel macro require input drop list, macro paste information website excel, excel macro send data access database, excel macro user input drop menu, create excel macro check active directory account status, macro excel find web information, information professionals inc excel macro, excel macro extract information website

Om arbejdsgiveren:
( 3 bedømmelser ) Vero Beach, United States

Projekt ID: #19617274

Tildelt til:


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 Flere

$45 USD in 2 dage
(23 bedømmelser)

55 freelancere byder i gennemsnit $131 på dette job


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 Flere

$220 USD in 4 dage
(353 bedømmelser)

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 Flere

$250 USD in 5 dage
(309 bedømmelser)

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 Flere

$200 USD in 7 dage
(141 bedømmelser)

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 Flere

$100 USD på 1 dag
(223 bedømmelser)

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.

$250 USD på 1 dag
(53 bedømmelser)

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 Flere

$250 USD in 3 dage
(78 bedømmelser)

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

$60 USD på 1 dag
(277 bedømmelser)

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 Flere

$77 USD in 2 dage
(210 bedømmelser)

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 Flere

$300 USD in 7 dage
(94 bedømmelser)

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.

$155 USD in 3 dage
(106 bedømmelser)

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.

$98 USD in 3 dage
(150 bedømmelser)

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 Flere

$160 USD in 2 dage
(61 bedømmelser)

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

$144 USD in 3 dage
(112 bedømmelser)

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 Flere

$166 USD in 4 dage
(18 bedømmelser)

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 Flere

$50 USD in 0 dage
(53 bedømmelser)

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 Flere

$120 USD in 3 dage
(81 bedømmelser)

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 Flere

$200 USD in 7 dage
(31 bedømmelser)

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 Flere

$95 USD in 3 dage
(31 bedømmelser)

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 Flere

$50 USD på 1 dag
(15 bedømmelser)

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 Flere

$111 USD in 2 dage
(11 bedømmelser)