Excel - Macro - Auto Fill Workbook ook with Data from another Workbook

There is a little more to this job but this all i can fit in

Attached are 2 forms

One Titled BIF_LOG

The Other Business Improvement Form

Both forms are to be kept on a shared server but in different locations

The idea is all users will be able to access The Business Improvement form and fill in the details and the BIF_LOG Form will automatically populate with the details keyed into The Business Improvement Form

To ensure data integrity and accuracy the cells on The Business Improvement form are to all be set up with data validation so the user can select from a list (Ideally preference would be to have the auto predict functionality)

1. On the BIF_LOG form there is a Tab (Worksheet) titled Table Reference – On this tab are all the tables that I would like the Business Improvement form to reference for data validation to create the lists the user can select – I need to be able to add to these tables as time goes by so the data validation needs to be dynamic list

2. On The Business Improvement form in Cell A1 you will notice a directory path currently C:\Documents\BIF LOG – I want this cell to hold the directory path to where the BIF_LOG Form is held on the shared server.

a. So in the code to look up the tables to use for data validation in the Business Improvement form this directory path be used

b. This directory path must be able to be updated/changed when we want to in case the BIF_LOG Form is ever moved to another location on the server

3. When the user opens the Business Improvement form the first thing the need to do is select the BIF Type – The user clicks or tabs into this cell and they select from a list – The list to select from is held in a table titled BIF Type on the BIF_LOG form under the Tab (Worksheet) titled Table Reference

4. Once the BIF Type is selected and the user tabs out of the cell we want the BIF No to automatically be assigned – To do this the code is to look at the BIF Type that has just been selected and looks up the BIF Log workbook by referencing the directory path in cell A1 and then finds the tab (Worksheet) in that workbook that is has the same title – Once it finds the corresponding worksheet in the BIF LOG Workbook it then looks at Column B – it looks for the first blank cell in this column and as soon as it finds a blank cell it looks at the Data held in the cell next to it in Column A and displays that data on the Business Improvement Form as the BIF No

a. For example if the user selects the BIF Type SUPPLY NON CONFORMANCE and then tabs out of that cell, the code finds the BIF LOG workbook and looks at the tab (worksheet) also titled SUPPLY NON CONFORMANCE then looks for the first blank cell in the Column B. When it finds this blank cell it then returns the data held in the cell next to the blank cell held in Column A and returns that data on the BIF LOG as the BIF No

6. The next cell the user needs to complete is the PROBLEM – Again the user is to select from a list – the list to select from is Based on the BIF Type selected earlier. If for example the user selected a BIF Type SUPPLY NON CONFORMANCE then the code is to look up the BIF LOG workbook and under the Table reference worksheet there is a table titled SUPPLY NON CONFORMANCE which holds a list the user can select from

16. At the bottom of the Business Improvement form are 2 buttons – The first is the Email button – If the user clicks on the email button Outlook is to open with this Business Improvement form attached and user can then email the Business Improvement form to desired person

17. The next Button is the save button – When the user clicks on this the information entered on the Business Improvement form automatically populates the BIF LOG Form based on the BIF Type - To do this for example, if the BIF Type selected on the Business Improvement Form is SUPPLY NON CONFORMANCE then all the information entered in the Business Improvement Form n

Habilidades: Excel

Veja mais: list populate table excel, fill data workbook excel, example macro excel automatically fill information workbook, excel macro populate worksheet, auto fill forms data excel worksheet, desired job title, auto populate data in excel, auto fill forms, Excel to Access, data validation, create excel worksheet, automatically fill forms, excel access table, excel macro add, auto form fill, outlook 2013 create macro, create user forms excel, outlook 2013 button, email data access 2013, set outlook users, excel 2013 macro, auto log, form validation select, outlook 2013 add button, outlook add macro

Acerca do Empregador:
( 32 comentários ) MALAGA, Australia

ID do Projeto: #5103287

Concedido a:


Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$250 AUD em 0 dias
(145 Comentários)

6 freelancers are bidding on average $158 for this job


Expert VBA developer with great experience here...I have completed over 100 VBA related projects on this site..I am available to start now and can provide update in 8-12 hours.

$157 AUD in 2 dias
(107 Comentários)

Hi BOFFA, I have studied the requirement and the provided Excel file. I can take on the job and shall deliver the Excel macro meeting your requirement within a day for your review. And one more day for incorporat Mais

$200 AUD in 2 dias
(76 Comentários)

A proposal has not yet been provided

$195 AUD in 3 dias
(4 Comentários)

Hello, I have extensive excel experience which would help me provide you the data you are requesting. However, when you look at my profile, you would see a bad reputation which resulted from a conflict with the employ Mais

$111 AUD em 1 dia
(1 Comentário)

hi, I can do it. I need to contact with you in detail for your project. it is possible for me. please hire me. regards.

$35 AUD in 3 dias
(0 Comentários)

interested...................................................................interested...................................................................interested...................................................... Mais

$252 AUD in 3 dias
(1 Comentário)