In Progress

Excel - Form to link to spreadsheet

This is a 2nd repost of a job that I erased as a result of an admin error with the budget allocation - sorry for any inconvenience.

I am looking for an Excale VBA script (Compatible with Excel 2003 - 2010) that populates a form - as shown in the attached file.

There must be 4 text panes in the form. The first pane on the form contains a list of Tasks (The list of Tasks available is fixed). When the user clicks on the Task list, depending on what the user selects, a list of subtasks will be diplayed on the next pane from which the user can select a sub task. On selecting the sub task the third pane will be populated with the standard activities associated with that Task & Subtask combination. The contents of all three these panes are fixed and sourced from the values in the Database sheet containing the source values (see attached file for the desired structure). The fourth pane is an input text area where the user can add additional information. That information needs to be copied back to the database when the user clicks on the "Accept and Exit" button.

If the user comes back to that task at a later stage the contents of each of the panes needs to be shown - including any additional comments saved previously. In other words the form needs to be pre-populated based on the contents of the associated database sheet.

I have included a screen shot of the form (I have been working on it, but have run out of time to get it completed) so it shoud be relatively simple to create from that screenshot. Do not worry about the "Code & Colour on Sheet" input as this is not applicable

Skills: Excel, Visual Basic for Apps

See more: link form spreadsheet, link form attached spreadsheet, spreadsheet script, looking job excel, excel source, vba error, three form, additional comments, budget spreadsheet, visual basic form excel, task allocation, spreadsheet input, excel visual basic, excel vba script, excel form, create spreadsheet, excel database visual basic, sheet excel job, simple vba excel script, excel colour, excel contains, spreadsheet vba code, excel simple vba script, excel vba tasks, sheet excel visual basic

About the Employer:
( 21 reviews ) Sydney, Australia

Project ID: #2516439

Awarded to:

rengrish

I have already done this type of task. Please check your mailbox for more details.

$40 AUD in 2 days
(22 Reviews)
4.0

12 freelancers are bidding on average $86 for this job

mrbrave

Excel Expert VBA coder here.....get it done in a day..

$60 AUD in 1 day
(78 Reviews)
5.4
Krusche

Hello. We are a German Company with a team of 3 dedicated VBA developers and we've done the similar projects. We assume high quality work both in terms of technical background and time frame issues. Please check your More

$90 AUD in 2 days
(21 Reviews)
5.2
Nhcuong

Hi, I can do it in excel 2010. Im programmer for years and very familair with VBA for excel automation. I suggest to add task id (unique) to track tasks. Best regards, Cuong NH

$70 AUD in 3 days
(20 Reviews)
4.8
shanki161

Hello Peter, Ready to deliver our best services.We can develop the similar script.Waiting for the project awarding.We can complete it ahead of time.Thanks

$100 AUD in 3 days
(13 Reviews)
4.5
naveenvarthaan

Hi, Am working on this. Will send you FIRST VERSION in next few hours. Best Regards, Naveen

$35 AUD in 1 day
(14 Reviews)
4.2
manishadk

Please check PMB for details.

$80 AUD in 2 days
(11 Reviews)
3.8
vikashgadia

We r excel expert macro expert from india

$65 AUD in 1 day
(15 Reviews)
3.6
HosElectro

hi im a visual basic programmer with experience for more than 7 years i can do your work and im so familiar with excel scripting.

$60 AUD in 4 days
(3 Reviews)
3.3
AdamT82

Dear ph1965, I have already finished your project. I have sent you ready file to check. I have based on information and data, that you were prepared.

$250 AUD in 2 days
(1 Review)
2.5
sumeet00

Hi, I have some very important suggestions regarding your requirement. Please check the same in PM and we can discuss more on this. Regards, Sumeet.

$80 AUD in 3 days
(2 Reviews)
2.1
vnprocoder

Hello, Greetings from CIS (consulting and IT services) We have reviewed your project post and can help you to develop the project and make sure run successfully, and also glad to tell you we have developed many websi More

$100 AUD in 7 days
(0 Reviews)
0.0