Build Macros in an EXCEL sheet to automatically populate data from a Master Sheet

完了済み 投稿 Feb 9, 2016 着払い
完了済み 着払い

See attached document tracking Sheet. The first sheet is the master schedule where all data pertaining to drawings is populated. There are four additional sheets that contain data pulled from the master sheet.

The project is to automate the data population of the sheets:

"Drawing Checkout Tracking"

"IFA Submission"

"IFC Submission"

"As-Built Submission"

Use the data already populated in the sheets to understand what the requirements are.

Requirements:

1. All data must automatically populate using a macro or some other automated process. If needed, you can put in a "button" that retreives the data on each sheet so the automation process happens only when desired.

2. The print formatting of the four sheets above must remain intact and be ready to print at any time

To qualify:

1. Review the attached sheet and provide a description on how you intend to approach the problem

2. Provide me an example of your work, either by modifying the sheet provided or by showing me similar work you have done.

エクセル ビジュアルベーシック

プロジェクトID: #9607670

プロジェクトについて

19個の提案 リモートプロジェクト アクティブ Feb 9, 2016

アワード:

vlayausa

Hello, I think I am the perfect candidate for working on this project. I am proficient in Excel and VBA and macros and I would love to show you example of my work. Please contact me for more details.

$121 USD 3日以内
(137レビュー)
5.8

19人のフリーランサーが、平均$104 で、この仕事に入札しています。

Khurramz

Hi! Do you use one file for one project ? Please send me chat so that I can attach sample file. .

$150 USD 3日以内
(353件のレビュー)
7.4
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr もっと

$140 USD 7日以内
(204件のレビュー)
7.3
priyal1997

Dear Sir/Madam, I'm happy to help you on this task. I am an expert in advanced excel features and have already developed such dynamic reporting tools for various business. If you are comfortable with my ratings and r もっと

$250 USD 3日以内
(186件のレビュー)
6.7
flashsaiful

Hi A warm greetings! Thank you for the opportunity to submit a proposal in your job post. Please give me more details so that i could understand the project specification very well. I always work with perfection, もっと

$155 USD 3日以内
(137件のレビュー)
6.5
macroPOL

Hello, I am Excel and VBA expert. I can complete this project. I want to write a macro (VBA). I have done many similar projects - retrieve data from one sheet to another in an automatic way. Here are some exampl もっと

$100 USD 3日以内
(95件のレビュー)
6.0
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 60+ are complex VB/VBA projects, hence i can definitely deliv もっと

$54 USD 3日以内
(75件のレビュー)
5.9
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details もっと

$45 USD 1日以内
(62件のレビュー)
5.7
MoohHHooM

Hi, I am a professional in EXCEL and VBA and VB.net programming so I can help you with this project in minimal time. as I have worked on similar projects many times. what i am thinking of is a simple VB..NET tool もっと

$150 USD 1日以内
(30件のレビュー)
5.4
Technovin

Hello sir, I go through your project description and found it simply doable. I have understood exactly what you want. I have been working on this type of projects from last few years. I have a team of 15 operators もっと

$44 USD 3日以内
(6件のレビュー)
2.3
LumiNysis

We at LumiNysis are the expert in MS Excel, VBA and automation across industries and are able to covert any data into useful results

$35 USD 2日以内
(2件のレビュー)
1.9
KevinZC

Hi Kevin here, I hope you will consider our team for your project. We will assure you a quality end product at a competitive price. I know you will be swamped with bids so thank you for the time. Hoping to hear from yo もっと

$144 USD 3日以内
(0件のレビュー)
0.0
zheiva

I'm an expert on MS Excel. I offer to write a code, which first of all will check whether new rows have been added to the master sheet. Is so, then for eache sheet an array wiil be created, which will contain the info もっと

$70 USD 2日以内
(0件のレビュー)
0.0
jmahaffie2004

A proposal has not yet been provided

$45 USD 2日以内
(0件のレビュー)
0.0