Κλειστη

Excel VBA - 13/10/2016 10:36 EDT

Αυτό το πρότζεκτ έλαβε 12 προσφορές από ταλαντούχους freelancers με μέση τιμή προσφοράς $390 USD.

Λάβετε δωρεάν αναφορές για ένα πρότζεκτ σαν αυτό
Εργασία Εργοδότη
Προϋπολογισμός Εργασίας
$250 - $750 USD
Σύνολο Προσφορών
12
Περιγραφή Εργασίας

Task #1:

Click on the green “UPLOAD“ arrow in the worksheet TEMPLATE (row 814) to insert and resize the specified images in the designated cells in worksheet REPORT.

Origin Files:

All image files must be named as specified in worksheet Template/ column Q/rows 807 - 906.

All image files shall be located in the Folder C:/MirfinMP.

File endings “.jpg“ or “.jpeg“ shall be accepted.

There can be up to 45 image files.

File size may not exceed 300KB per image.

Not all specified images may be available, in which case only the available images are inserted in the respective cells.

Destination Cells:

Each image must be sized to fit the size of the destination cell exactly.

Images to have a slight shadow (if possible).

There can be up 47 destination cells (image [url removed, login to view] is assigned to 3 destination cells).

Each image shall be assigned and resized to the following cells in the worksheet REPORT:

[url removed, login to view] -> AI25

[url removed, login to view] -> AI39

[url removed, login to view] -> AJ728; AJ945; C1103

[url removed, login to view] -> X1103

[url removed, login to view] -> C1131

[url removed, login to view] -> X1131

[url removed, login to view] -> C1159

[url removed, login to view] -> X1159

[url removed, login to view] -> C1189

[url removed, login to view] -> X1189

[url removed, login to view] -> C1217

[url removed, login to view] -> X1217

[url removed, login to view] -> C1245

[url removed, login to view] -> X1245

[url removed, login to view] -> C1275

[url removed, login to view] -> X1275

[url removed, login to view] -> C1303

[url removed, login to view] -> X1303

[url removed, login to view] -> C1331

[url removed, login to view] -> X1331

[url removed, login to view] -> B385

[url removed, login to view] -> Q385

[url removed, login to view] -> AF385

[url removed, login to view] -> B399

[url removed, login to view] -> Q399

[url removed, login to view] -> AF399

[url removed, login to view] -> B413

[url removed, login to view] -> Q413

[url removed, login to view] -> AF413

[url removed, login to view] -> AJ746

[url removed, login to view] -> AJ764

[url removed, login to view] -> AJ782

[url removed, login to view] -> AJ812

[url removed, login to view] -> AJ830

[url removed, login to view] -> AJ963

[url removed, login to view] -> AJ981

[url removed, login to view] -> AJ999

[url removed, login to view] -> AJ1029

[url removed, login to view] -> AJ1047

[url removed, login to view] -> C1361

[url removed, login to view] -> C1447

[url removed, login to view] -> C1533

[url removed, login to view] -> C1619

[url removed, login to view] -> C1705

[url removed, login to view] -> C1791

Task #2:

The spelled out number in cell AJ784/TEMPLATE must be all in lower case and the currency must read “rand“ instead of “dollars“.

Task #3:

All inserted objects with assigned macros on both worksheets TEMPLATE and REPORT must be enabled/functional when clicked when the worksheets are in “protected“ mode.

(Currently, when in "protected" mode, clicking the Objects raises the following alert:

Microsoft Visual Basic

Run-time error '1004':

AutoFilter method of Range class failed

[Abort] [Debug]

Please advise the procedure to enable the intended functionality of objects in "protected" mode?

(I have already tried to achieve this by unlocking the cells over which the objects and by unticking the “Locked“ tick-box in the “Format Shape“ window, but without success.)

Ψάχνετε τρόπους για να κερδίσετε μερικά χρήματα;

  • Ορίστε τον προϋπολογισμό σας και το χρονικό πλαίσιο
  • Περιγράψτε την πρότασή σας
  • Πληρωθείτε για τη δουλειά σας

Προσλάβετε Freelancers που ήδη έχουν υποβάλει προσφορά σε αυτή την εργασία

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online