Ditutup

Create Excel Timeline linked to Access Database

For my Wedding Photography Business, I need someone to create a 3 person Excel Daily Timeline template where I will complete each row of each Person’s spreadsheet by as follows:

-First I will manually enter the start time in Cell A2.

- Then in Cell B2, I need a dropdown box populated with info from an open Access Table which will become the Location Information for that location. In this Column, I need the ability to either use the Dropbox Location info or manually enter my own Location info.

- Moving across the speadsheet, I will manually enter info in Cells C2 & D2.

- In Cell E2, I will enter an amount of time (in minutes). When the amt of minutes is entered into E2, cell F2 will automatically update as the new time created by adding the minutes from E2 to the start time in A2.

- I will then manually a number of minutes in G2, cell A3 will automatically update with the number of minutes in G2 added to the the time in F2.

I will then complete as many rows as needed to complete the daily.

Any time that any of the minute cells ( from the E & G columns get changed, all of the corresponding times after that will update.

I need 3 separate pages so I can create timeline for 3 people from this same event.

Then I need the ability to show an overlay of the 3 people’s timelines for the day.

When saved, it’ll be a 3 person timeline form.

Although, it may seem a bit complicated, it’s quite an easy task.

I'm open to suggestions as well

Kemahiran: Pemasukan Data, Pemprosesan Data, Microsoft Access, Visual Basic

Lihat lagi: visio 2010 create timeline from excel, create timeline from excel data, import excel dates into visio timeline, link excel data to visio timeline, visio 2013 timeline import data from excel, link access to excel, link excel to access query, create visio timeline from excel data, microsoft access database for startup company, microsoft access database for start-up company, import excel crosstab data access database, create sharepoint front end access database, create excel price list access, excel data base access database mysql, use excel front end access database

Tentang Majikan:
( 0 ulasan ) United States

ID Projek: #16434310

13 pekerja bebas membida secara purata $55 untuk pekerjaan ini

schoudhary1553

Greeting, I have understood your Create Excel Timeline linked to Access Database 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 Lagi

$150 USD dalam 2 hari
(193 Ulasan)
7.3
avinav606lx

Hi there, I am an expert in Excel/Access VBA user forms with over 5+ years of experience. Ping me to discuss more. Thanks Aman

$111 USD dalam 3 hari
(126 Ulasan)
6.3
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Excel Lagi

$111 USD dalam 2 hari
(45 Ulasan)
6.0
mariusalex86

Hello. I understand the requirements of this project and I am interested to work on it. I am a reliable freelancer, focused on quality and accuracy. Kindly consider my proposal. Thank you.

$30 USD dalam 2 hari
(50 Ulasan)
5.4
tiaratechies

Hello, I can give you the excel template in next couple of hours if you are interested. I would like to work on this project if you give an opportunity.

$20 USD dalam sehari
(32 Ulasan)
5.1
SShtv

I have a successful experience of doing such work. As an example, I bring screenshot of one of the programs. [url removed, login to view]

$25 USD dalam sehari
(30 Ulasan)
4.8
$111 USD dalam sehari
(2 Ulasan)
2.3
$10 USD dalam 3 hari
(3 Ulasan)
1.4
nguyenanh78

A proposal has not yet been provided

$30 USD dalam 3 hari
(1 Ulasan)
1.1
aalbarghouthi

A proposal has not yet been provided

$25 USD dalam sehari
(0 Ulasan)
0.0
GustafStefansson

I possess vast experience in the areas concerned: design, coding, testing and documentation, analyzing and error correction on existing source code (automating where suitable) using the mentioned tools: .NET, Excel, VB Lagi

$40 USD dalam sehari
(0 Ulasan)
0.0
$25 USD dalam sehari
(0 Ulasan)
0.0
shivharenik

Try me please and you won't regret. I have decent excel and CMM level 5 experience working for 10+ years in the industry now.

$27 USD dalam sehari
(0 Ulasan)
0.0