Start Date
Immediately after hiring
Employer Facts
Project Description
I need a person who knows good excel and visual basic. I need him to do for us a complicated macro program in excel. Please see my explanation of what I need below.
Please see my explanation of the work that needed to be done:
1. From all sheets to copy data to sheet ( cal ) to copy as values
2. Before copying each sheet to sheet ( cal ) the program should ask where all rows are – The program should ask where in sheet X rows of
a. Item
b. Description
c. Quantity
d. Unit
e. Dollar
f. Shekel
g. NGN
h. Euro
i. BP
j. Rand
3. Then to copy each sheet to sheet ( cal ) according to each row that we input in step 2
4. After copying each sheet to sheet ( cal ) at column C in sheet ( cal ) to put near each line name of sheet that it was copied from
5. After copying all sheets to sheet ( cal ) ask once again where the following columns but now in all the sheets that we are copying data to :
a. Materials
b. Installation
c. Complete
d. Quantity
e. Total
6. After asking all the columns we need no to copy but to link all cells from sheet ( cal ) to all the sheets ( each sheet ) we can know to each sheet from line C in sheet ( cal ) there is written from with sheet the data what taken from.
7. After that we are linking to each sheet from sheet ( cal ) the:
a. Materials
b. Installation
c. Complete
8. After linking in row Total of each sheet we are putting formula Complete * Quantity = Total