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.
55 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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, 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.
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