Terminé

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é à:

KozlouAlex

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)
4.5

55 freelance font une offre moyenne de $131 pour ce travail

schoudhary1553

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)
8.0
Webxpert4u

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)
8.0
zekovicm

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)
7.4
ineedWorkJob

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)
7.1
tiaratechies

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)
6.7
dgled

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)
7.0
mrbrave

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)
6.8
datakillers

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)
6.9
Beacon09

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)
6.7
periyannas

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)
6.2
vlayausa

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)
5.9
expertcoder1vw

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)
6.1
sonarkaushik

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)
6.3
Altantsetseg

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)
5.0
sorinacho88

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)
5.1
vsprybhanu

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)
5.5
xinglong717

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)
5.1
urielbaray

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)
5.0
RavinduJayzz

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)
4.9
Sercho56

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)
4.7