Dashboard Automation & Protection

$30-250 USD

Dokončeno

Zveřejněno

skoro před 6 roky

$30-250 USD

Zaplaceno při doručení

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

IČ projektu: 16929763

O projektu

6 nabídky

Vzdálený projekt

Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@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 v 3 dnech

5,0

(5 recenze)

4,1

6 freelanceři nabízejí v průměru $98 USD za tuto práci

@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 v 1 dni

4,9

(13 recenze)

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 v 1 dni

5,0

(8 recenze)

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 v 3 dnech

5,0

(2 recenze)

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 v 1 dni