EXCEL, Macro or some other method: Populating multiple workbooks based off data entered into 1st sheet.


I'm trying to enter data I fill in from Sheet 1, in Workbook1, into multiple sheets, workbooks, other xlsx files, etc. I'm totally open to suggestion on how to improve my process to make the process itself go more smoothly. As is, I'm trying to do it now, but it's taking forever.

A few things to consider:

1. The data entered by me in the source sheet will be in a certain format. However, the data that needs to be placed in the target sheets will vary in sometimes subtle or vast ways. Adding a number, or a letter to the end, or even the beginning. Merging cells or combining data from multiple cells into the final version, which will vary from sheet to sheet; but the source data will be the building blocks for this, and it all flows from that.

2. I will need the data from the source sheet to be inserted into roughly 50 target sheets all of which have varying sub-targets (for lack of a better word) in different columns

The winning bidder will be filled in on the exact details. I feel like I can do all of this, but it will take me literally forever, if someone can think of and produce for me what I'm trying to accomplish in a few days max, you will be my winning bidder. Name your price.

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: how to transfer data from one sheet to another in excel using macros, combine multiple excel files into one workbook vba, extract data from multiple excel files into single file, how to combine multiple excel files into one worksheet using macro, macro to consolidate data from multiple workbooks, combine multiple excel files into one workbook separate sheets vba, macro to pull data from multiple excel sheets, how to pull data from multiple worksheets in excel, excel macro data cell, data net web application excel macro, excel macro move data existing cell, excel macro copy data column, excel macro enter data database, data web excel macro, excel macro data online, excel macro data base entry, excel macro next chart data, excel macro copy paste data application, excel macro copy data windows application, web based data collection excel

About the Employer:
( 22 reviews ) Newark, United States

Project ID: #16944509

58 freelancers are bidding on average $128 for this job


Hello Sir, Thank you for this opportunity. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

$200 USD in 3 days
(604 Reviews)
$200 USD in 2 days
(262 Reviews)

Hello, I can help with you in your project EXCEL, Macro or some other method. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps. We have worked on seve More

$180 USD in 3 days
(275 Reviews)

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD in 3 days
(276 Reviews)

Greetings! We will use certain codes and formulas to insert the data as per your requirement. I would like to request you if can share the file and details with us so that we can create few samples for you. It would b More

$61 USD in 2 days
(311 Reviews)

Hello, I am highly skilled in Excel and VBA and ready to take on this project. Please share sheets and discuss exact details via chat. Thank you, Usman

$160 USD in 3 days
(88 Reviews)

Hi, there. I'm Paris Pallas, an experienced and skilled Excel developer. I have delivered almost 230 projects successfully over the last 5 years and I feel really confident that I can assist with yours as well. Don' More

$180 USD in 5 days
(149 Reviews)

I am very able to creste a macro to suffice your requirement

$99 USD in 1 day
(102 Reviews)

I have excellent command on MS Excel and can populate multiple workbooks as per your requirements. Please share sample data for better understanding the project. I have completed complex projects in Excel before . For More

$150 USD in 3 days
(50 Reviews)

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat More

$111 USD in 3 days
(64 Reviews)

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical More

$120 USD in 3 days
(74 Reviews)

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

$155 USD in 3 days
(40 Reviews)

Hi there! It looks like you need some process automation. Here are some suggestions to help you get started: 1. If you are using Excel 2010 - 2016, lets use Power Query to handle some of the load. It is a powerful d More

$138 USD in 30 days
(17 Reviews)

Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. I can help you with your excel project to populate data from one data entry form to multiple workbooks. I would like to see More

$100 USD in 5 days
(88 Reviews)

Hi, I have multiple years experience in Excel, macros, functions and in data processing. I checked your requirement and as per your requirement I can build one macro as well as functions for you so that all data wil More

$111 USD in 3 days
(34 Reviews)

HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have worked in I More

$111 USD in 2 days
(14 Reviews)

Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv More

$111 USD in 3 days
(59 Reviews)

I am an Excel VBA developer. My specialization is creating Excel macros which can automate repetitive work processes. I am confident that I can customize a sub routine that could do your work requirements. Feel free to More

$150 USD in 3 days
(26 Reviews)

I am experienced in the Data entry, Book Writing and Graphic Designer. I also understand your requirement and my aim is to analyze your requirement in logical way and give you perfect solution. I provide expertise serv More

$50 USD in 3 days
(62 Reviews)

Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing More

$155 USD in 3 days
(23 Reviews)