Closed

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

Hello,

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 work to enter the data into the sheet, excel macro find replace multiple items, excel macro mail merge multiple templates, home based data entry work excel, excel macro analyze multiple choice data, home based data entry excel, excel based data entry work home

About the Employer:
( 21 reviews ) Nutley, United States

Project ID: #16944509

59 freelancers are bidding on average $127 for this job

jaylancer43

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

$200 USD in 3 days
(577 Reviews)
8.2
$200 USD in 2 days
(262 Reviews)
7.7
schoudhary1553

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
(248 Reviews)
7.5
maverick44000

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
(87 Reviews)
6.9
Dhruvika111

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
(288 Reviews)
7.5
P0L

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
(259 Reviews)
7.0
paris2785

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
(143 Reviews)
6.7
sonarkaushik

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

$99 USD in 1 day
(99 Reviews)
6.2
abhinovpankaj

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
(58 Reviews)
5.6
archanaoswal

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
(35 Reviews)
5.2
periyannas

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
(29 Reviews)
4.9
vsprybhanu

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
(73 Reviews)
5.3
parsermonster

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

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
(81 Reviews)
5.0
prabakarm23

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
(54 Reviews)
4.8
vaidyag

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
(11 Reviews)
4.5
aubrey03

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
(25 Reviews)
4.9
Orientwork

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
(59 Reviews)
4.9
jasalaz100

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
(21 Reviews)
4.7
nurnga1218

Hi, I'm a little bit confused with your project brief. But I think you need a function like macro to make an automatic data from one sheet to another sheet or merge data from many sheets into a sheets. Well, I did some More

$40 USD in 3 days
(38 Reviews)
4.5