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 [login to view URL] is assigned to 3 destination cells).
Each image shall be assigned and resized to the following cells in the worksheet REPORT:
[login to view URL] -> AI25
[login to view URL] -> AI39
[login to view URL] -> AJ728; AJ945; C1103
[login to view URL] -> X1103
[login to view URL] -> C1131
[login to view URL] -> X1131
[login to view URL] -> C1159
[login to view URL] -> X1159
[login to view URL] -> C1189
[login to view URL] -> X1189
[login to view URL] -> C1217
[login to view URL] -> X1217
[login to view URL] -> C1245
[login to view URL] -> X1245
[login to view URL] -> C1275
[login to view URL] -> X1275
[login to view URL] -> C1303
[login to view URL] -> X1303
[login to view URL] -> C1331
[login to view URL] -> X1331
[login to view URL] -> B385
[login to view URL] -> Q385
[login to view URL] -> AF385
[login to view URL] -> B399
[login to view URL] -> Q399
[login to view URL] -> AF399
[login to view URL] -> B413
[login to view URL] -> Q413
[login to view URL] -> AF413
[login to view URL] -> AJ746
[login to view URL] -> AJ764
[login to view URL] -> AJ782
[login to view URL] -> AJ812
[login to view URL] -> AJ830
[login to view URL] -> AJ963
[login to view URL] -> AJ981
[login to view URL] -> AJ999
[login to view URL] -> AJ1029
[login to view URL] -> AJ1047
[login to view URL] -> C1361
[login to view URL] -> C1447
[login to view URL] -> C1533
[login to view URL] -> C1619
[login to view URL] -> C1705
[login to view URL] -> 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.)
I have 10 years experience with Data Processing in Excel and Web Researching. I work with:
Web Search
Web Scrapping
Excel
Access
PowerPoint
Data Processing
Data Collecting (Using Macro)
MS Office
C++
HTML
VBA
Macro
Automation
User Forms
Data Analyzing
PivotTable
Chart
Graphic Presentations
Data Presentations
And any task related to Excel
Feel free to contact me.
Hello
I've 15+ years experience in web scraping and data entry. so i can do your work easily please send me message so i can start your work ASAP.
Thanks