Lengkap

Build an Excel for Mac template

This workbook/sheet must work in Excel for Mac and be usable as a template. Two sample files are attached. [login to view URL] demonstrates what the layout of the sheet should be. RV_Excel_Job01_Column_Sort_Sample demonstrates the sort buttons that should be attached to headers on cells B6 through K6 (see point 5 below).

The workbook/sheet should be programmed as follows:

1. Column A7 through A16 consists of 10 rows of checkboxes that show/hide columns “B” through “K”. If a checkbox is checked it should show the corresponding column. If a checkbox is unchecked it should hide the corresponding column.

2. Column A should have a width of 25 and not be resizable if possible.

3. The show/hide checkbox at B:4 shows or hides Column A (the Column Picker).

4. The show/hide macros attached to checkboxes in the Column Picker should NOT be hard-coded to their particular column. Any column from B to K should me movable/arrangeable by the user. When a column is moved its corresponding checkbox in the Column Picker should still show or hide the column in its new location.

5. If possible, the headers at columns C through K should each have a sort button attached that sorts Columns B through K based on the column that is chosen for the sort. The spreadsheet “RV_Excel_Job01 Column Sort [login to view URL]” has a sample of the sort buttons attached to headings. Column A should never be sorted.

6. The Column B heading should contain a drop-down list with the following 4 choices:

- 96w x 16h pixels

- 96w x 54h pixels

- 192w x 104h pixels

- 384w x 208h pixels

When a selection is made from the drop-down list, column B’s width should be set to the width value in pixels of the selection and rows 7 through 35 should have their heights set to the height value in pixels of the list selection. A jpeg pict will be inserted here at runtime.

7. Macros and code should be well documented and expandable.

8. The finished spreadsheet, controls, macros and code should be open and unprotected.

Kemahiran: Excel, Visual Basic, Microsoft Office

Lihat lagi: excel app template, build company joomla template, volusion product template html location, build excel pread sheets, excel calculation template, excel spreadsheet template catalog websites, excel hoa template, quickbooks excel invoice template, build excel pivot table, vba excel import template, accounts payable receivable excel spreadsheet template, manage workload excel workbook template, best excel design template, build tableless joomla template css

Tentang Majikan:
( 9 ulasan ) Bensalem, United States

ID Projek: #23402010

Dianugerahkan kepada:

urielbaray

I know your TIME is VALUABLE so, honestly, thanks for reading my proposal. I have read your project and I can do it. I will build the template according to the requirements you have set and I will test it directly on Lagi

$150 USD dalam 3 hari
(44 Ulasan)
5.7

5 pekerja bebas membida secara purata $136 untuk pekerjaan ini

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$250 USD dalam 10 hari
(349 Ulasan)
7.4
mtdevil369

Hi, I have understand the project requirement & interested to work for this project. I will start right now and I will do it within your time . Please send a message so we can discuss more & start the project. Thanks.

$96 USD dalam sehari
(155 Ulasan)
6.2
ankushyadav13

I'm a student and I am fond doing work and my name is Ayush yadav and I live in India so I'm a worthy gay so please give me the job

$30 USD dalam 3 hari
(0 Ulasan)
0.0
$83 USD dalam 8 hari
(0 Ulasan)
0.0