Dashboard Automation & Protection

$30-250 USD

Selesai

Disiarkan

sekitar 6 tahun yang lalu

$30-250 USD

Dibayar semasa penghantaran

I have an Excel document that auto-sorts my 'Date Due (NLT)' column which is exactly what I needed. However, I've learned that I cannot protect the worksheet without losing the auto-sort capability and I need to protect every column except my 'Last Completed' column. My thought was to use vlookups and another worksheet that I can simply hide from the end-users, but I'm not sure how to approach this given the dynamics that the auto-sort coding present. Help, please!

Excel Macros

Excel VBA

ID Projek: 16929763

Tentang projek

6 cadangan

Projek jarak jauh

Aktif 6 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@TechnoGuruu

Hi, I understood your issue. please share your excel file so that I can help you in better way. Apart from functions and excel features we have macro and vba also . So if your problem was unsolvable with functions we can implement macro on it. Please give me opportunity to work on your project. Thanks

$55 USD dalam 3 hari

5.0

(5 ulasan)

4.1

6 pekerja bebas membida secara purata $98 USD 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.

$100 USD dalam 1 hari

4.9

(13 ulasan)

5.1

@rinabuoy13

Hello I am well versed in excel. I can assist you with this project. Looking to hearing from you soon.

$88 USD dalam 1 hari

5.0

(8 ulasan)

3.0

@nelumindralal

Hello, I went thru the description It's pretty challenging. Can you discuss more on that? Maybe I can find you a solution You can see my previous projects and reviews I look forward to hearing from you Thanks Regards Thushara

$100 USD dalam 3 hari

5.0

(2 ulasan)

1.6

@vw2107604vw

I'm an experienced software engineer in the Pacific Northwest. I can help you with your auto-sorting feature in your spreadsheet. I can add a macro to the workbook which will turn off sheet protection, do the sorting, and then turn it back on when a value on the sheet changes. Please message me so we can discuss exactly how your spreadsheet works and what you need so that I can help. Thanks, Gabriel

$88 USD dalam 1 hari