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.

Compétences : Saisie de Données, Traitement de Données, Excel, Architecture Logicielle, Visual Basic

en voir plus : 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

Concernant l'employeur :
( 3 commentaires ) Vero Beach, United States

Nº du projet : #19617274

Décerné à:


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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(23 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(353 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(309 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(141 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(223 Commentaires)

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(53 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(78 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(277 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(210 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(94 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(106 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(150 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(61 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(112 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(18 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(53 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(81 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(31 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(31 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(15 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(11 Commentaires)