Suoritettu

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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, tietojärjestelmäarkkitehtuuri, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 3 arvostelua ) Vero Beach, United States

Projektin tunnus: #19617274

Myönnetty käyttäjälle:

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 Lisää

$45 USD 2 päivässä
(23 Arvostelua)
4.5

55 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

$220 USD 4 päivässä
(353 arvostelua)
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 Lisää

$250 USD 5 päivässä
(309 arvostelua)
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 Lisää

$200 USD 7 päivässä
(141 arvostelua)
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 Lisää

$100 USD 1 päivässä
(223 arvostelua)
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.

$250 USD 1 päivässä
(53 arvostelua)
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 Lisää

$250 USD 3 päivässä
(78 arvostelua)
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. Lisää

$60 USD 1 päivässä
(277 arvostelua)
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 Lisää

$77 USD 2 päivässä
(210 arvostelua)
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 Lisää

$300 USD 7 päivässä
(94 arvostelua)
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.

$155 USD 3 päivässä
(106 arvostelua)
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.

$98 USD 3 päivässä
(150 arvostelua)
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 Lisää

$160 USD 2 päivässä
(61 arvostelua)
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

$144 USD 3 päivässä
(112 arvostelua)
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 Lisää

$166 USD 4 päivässä
(18 arvostelua)
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 Lisää

$50 USD 0 päivässä
(53 arvostelua)
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 Lisää

$120 USD 3 päivässä
(81 arvostelua)
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 Lisää

$200 USD 7 päivässä
(31 arvostelua)
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 Lisää

$95 USD 3 päivässä
(31 arvostelua)
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 Lisää

$50 USD 1 päivässä
(15 arvostelua)
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 Lisää

$111 USD 2 päivässä
(11 arvostelua)
4.7