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

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

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.

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #16944509

About the project

55 proposals Remote project Active 5 years ago

55 freelancers are bidding on average $125 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
(787 Reviews)
8.6
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
(382 Reviews)
8.1
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
(404 Reviews)
7.6
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
(271 Reviews)
7.6
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
(421 Reviews)
7.8
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
(91 Reviews)
7.0
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
(126 Reviews)
6.5
sloker18

What you have described in your task can be achieved by macro easily, you can use macro to update multiple workbooks, multiple worksheets at the background at the same time. I am proficient with excel macro/VBA develop More

$100 USD in 3 days
(111 Reviews)
6.3
TechnoGuruu

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
(94 Reviews)
6.1
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
(160 Reviews)
6.4
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
(149 Reviews)
5.8
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
(94 Reviews)
6.0
sonarkaushik

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

$99 USD in 1 day
(103 Reviews)
6.2
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
(103 Reviews)
5.8
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
(66 Reviews)
5.6
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
(15 Reviews)
5.3
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
(47 Reviews)
4.7
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
(32 Reviews)
4.9
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
(59 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
(72 Reviews)
5.2