Käynnissä

Program a simple Excel Macro to Do a Task

I need help programming a simple excel macro to copy data from one sheet to another in the same workbook. There are some validations that need to be made and the macro has to be simple and not cause performance issues.

There is a Sheet called Project Data Entry that will be a data entry form. People will enter data into that sheet. Column C is where the value that should be copied exists. Colum D and E represents the row and column number in the Table Named "InitiativesInfo" to which the value should be copied to. These will be entered by me only (people who enter data will not see them). Some these cells have functions that will be copied as values only.

The sheet Summary contains the table "InitiativesInfo" to where the data will be copied (destination). This table might change.

The Database sheet contains lists for data validation. Please note that some cells in the Project Data Entry are confined by data validation. There also cells in the IniativesInfo that are also confied with data validation.

The core function of the macro loop through the Project Data Entry sheet (mainly through Column C) and copy the value of the cell to its destination (based on Column D and E which represent the row and column number in the table not the sheet).

Here are other key notes and requirements:

1. The data formatting in the table Initiatives info should not be ruined and kept even after copying.

2. There are equations in the Initiatives info table so not all rows will have data entered to them. For example AZ is a function that will calculate based on data entered in other columns. And the first column in the table as well.

3. The code should be easily understood by myself (someone with basic VBA understanding) as I will continue to update the code and modify it. Because the table might have some additional columns added. The Data Entry sheet also will be expanded. So i want to copy past blocks of code and just edit labels or names.

4. The macro only works once a button (transfer data) is clicked.

5. After the macro runs the data entry person is asked if they would like to erase the content in the Project Data Entry and accordingly the macro either erases or keeps it.

Here are other nice to haves in the macro:

1. When someone is entering data, they are asked if they would like to edit a row or enter a new one. If they want to edit an existing row the macro uses the row number entered (whether this row is actually blank or not). If they opt for add new row, the macro creates a new row in the table after the last row (whether is is empty or not).

2. It would be nice if the macro does a quick check that all names of columns in Column A in the Projects Data Entry Sheet are compatible with the ones in the table (based on column number entered in Column E) and give an error that names are incompatible.

Taidot: Excel, Visual Basic, Tietojenkäsittely, Excel Macros, Excel VBA

Näytä lisää: excel macro lock program day trial, excel 2000 simple sort macro, excel macro programming cut paste, excel macro programming outsource, macro programming excel data input, run external program excel macro, macro automate task excel, task automation using excel macro, excel macro simple input output, create simple print macro excel, excel macro copy data program, excel macro programming job, excel macro programming jobs, excel macro programming read pdf, ms excel macro programming, twitter simple excel macro, work home excel macro program, excel macro visual basic help needed urgent, excel macro paste program

Tietoa työnantajasta:
( 1 arvostelu ) Amman, Jordan

Projektin tunnus: #31611906

6 freelanceria on tarjonnut keskimäärin $38 tähän työhön

(51 arvostelua)
5.4
merinsinha

Can do it. Excel VBA , Macro Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticip Lisää

$40 USD 1 päivässä
(115 arvostelua)
5.4
(78 arvostelua)
5.5
(4 arvostelua)
3.8
kmfaisal99

Dear Brother,Assalamualaikum warahmatullahi wabarakatuh Hope you are healthy and well. There is a lot of joy inside with your family. I want you to be well in all circumstances. I have been able to understand your desi Lisää

$15 USD 1 päivässä
(1 arvostelu)
0.0
Shahzaibali723

Hi. I read your project requirements and I would like to work on your project. I have experience of 2 year's in excel at different pvt companies. I can provide you the output in less time and very accurate and also pro Lisää

$20 USD 7 päivässä
(0 arvostelua)
0.0