i am migrating from one database to another, i need to be able to concatenate multiline data tied to a unique user id and input results into master user table in excel. i have around 7000 contact records.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros.
Check my reviews.
Best regards
$350 USD v 1 dni
4,9 (246 recenze)
7,0
7,0
47 freelancers are bidding on average $348 USD for this job
Hello, I’m an Excel VBA expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
Hello!
I'm Paris, an experienced Access and Excel developer. I read your brief and I've got a solution I've implemented in the past successfully. I suggest having a button on one of your database's form. Once this is pressed all of your records will be exported to an Excel spreadsheet containing macros. When you open the spreadsheet its macro will be initiated and the records will concatenate all data for each user id. The final result will be a sheet that will hold a single line per user. The process will be re-usable and easy to alter in the future due to the comments I will add within the code. I'm looking forward to working with you.
Paris
Greetings!
Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day.
I have 18 years experience in using Excel as part of my daily work life. Over the last 20 MONTHS , I have spent at least 250 HOURS on automation in Excel every month.
If awarded, I can get your work completed to your fullest satisfaction.
Have a Great Weekend!
Srinivasan
Hi: I understand that you have a data set where the data for a user-id is distributed across multiple lines/rows. You want to bring all these data points for a user-id in a single line/row. Please confirm. I believe that I can help you with this project by creating an Excel macro (VBA) which will scan the rows of data and combine them if they are for same user-id. I would request you to share a sample of the data. Please review my profile to know more about my experience and quality of work. Thanks. Looking forward to our collaboration.
Can you please provide me with the sample excel database so that i could look at it. I can write VBA code to concatenate multilne data for unique id..Looking forward to have a chat with you to discuss further.
Hello, I would like to work on your project. I have great experience using excel macros / vba, data formatting and data manipulation in excel, working with multiple files with transferring data with / without changing data format. Regards
I can get the data formatted the way you need. I beleive with vlookups I can Achieve it. I have taken every excel class from 97 to 14 beginner to expert.
Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do the best scripting job in the least time starting right now. I will do all and extra to ensure that you won't regret giving me this project. Thanks
Hi, there
I hope all's well with you.
I see you'r looking for a developer proficient in Ms Access.
Really all my projects I've developed for Ms Access/Excel/VBA
projects.
I'll do your current project via Ms Access with Excel automation very professionally and on time.
Here is my introduction:
I’m a ms Access/Excel/VB programmer, a mathematician and a full time
developer with a strong background developing a wide range of accounting,
economical, statistical and mixed type projects using Ms Access, Ms Excel,
VBA, ADO, SQL , including projects for start-up companies and small businesses.
For over the last 20 years I’ve worked in a variety of industries.
I have a deep passion for coding and guarantee that all of developing is 100% original.
I highly value professionalism and hold myself strictly accountable to represent my client’s
brand. I aim to form a long-term working relationship.
Please, let me know what is needed to secure this bid!
Thank you for your consideration.
Zura
- Can search for the unique ids and have the data related to the unique id concatenated into columns as required.
- Can be done using automation.
- Have done similar concatenation of data based on macros automatically searching and inserting into the excel table.
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,
Hi,
I’ve done number of projects involving VBA programming.
I can manage your work, kindly text me for further details.
You can review my profile to know more about my skills and experiences.
Thanks
Greeting,
I have understood your VBA Developer Needed. task and can do it with your 100% satisfaction. Please ping me for more discussion.
I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps
As an experienced business analyst I have overseen multiple database migrations, and have always been responsible for the data transfer process. Thus far I am yet to experience and data integrity or data loss issues. I have expert level Excel and VBA, as well as over a decade of experience transforming data with SQL server - which may be a better approach for such a large volume of data (the results will still be provided in Excel format).
I would love to chat further about your project! Cheers, Katie
Hello.
VBA ideally suites for matching data by some key. To provide more detailed proposal I'd need to see the actual data structure; best of all if you could share a sample file.
Best regards,
Alexander.