Sedang Disiapkan

Excel Spreadsheet Modification and Set-up

We want to update the attached excel spreadsheet with dependent drop down menus and update the pivot table to include the changes. Pretty simplistic task for someone familiar with excel.

The "Categories" sheet contains the basic category list (yellow) that is referenced in Column D-Category on the "Expense Entry" sheet. It also contains the Sub-Category ("Motor vehicle expenses"-orange, "Capital cost allowance"-green, "Business-use-of-home"-dark blue & "Other expenses"-blue) & Rate info associated with the relevant green selection. The "Class 29"-green selection would have 3 associated options that would auto populate after selecting. The other classes have static rates associated.

We want the new data in the "Expense Entry" sheet to have Column E-Sub Category to be dependent on the item selected from Column D and the data in Column F-Rate would be auto populate based on the the data selected in Column E, with the exception of Class 29 (drop down then auto populate based on selection.)

The green Classes would also have a pop up associated with each item found in Column F, Rows 42 to 56. This would be used to assist in selecting the appropriate Class on the "Expense Entry" sheet.

The last item would be to check and confirm that the pivot table in the "Quarter Summary" is functioning with the new features.

Any questions please let me know,

Thanks from Aenco.

Kemahiran: Pemprosesan Data, Excel, Javascript, PHP, Visual Basic

Lihat lagi: Convert the attached spreadsheet to EXCEL. Add to columns for Trade and Trade Sub-Category eg under Concrete supply add a column, excel spreadsheet set, link form attached spreadsheet, please complete attached spreadsheet, refer attached spreadsheet details, guide attached spreadsheet, find attached spreadsheet giving details inputs, excel object programmatically parse rows spreadsheet, excel months projected cash flow spreadsheet, attached spreadsheet, find attached spreadsheet, excel gui pop input data spreadsheet, write excel files mfc microsoft office spreadsheet, data excel spreadsheet set organization, excel macro script insert data spreadsheet

Tentang Majikan:
( 0 ulasan ) Calgary, Canada

ID Projek: #15895408

Dianugerahkan kepada:


Dear Client I have previously carried out a number of projects in excel using vba macro and formulas. I believe I can help you in this project. Kindly contact me Roy

$30 CAD dalam sehari
(225 Ulasan)

4 pekerja bebas membida secara purata $28 untuk pekerjaan ini


Hi, I read project description and i will make Modification and Set-up as per your instruction. I have experience in this field. Let's chat with me for short discussion. Thank You Relevant Skills and Experience Data P Lagi

$27 CAD dalam sehari
(33 Ulasan)
$30 CAD dalam sehari
(24 Ulasan)
$25 CAD dalam sehari
(10 Ulasan)