Dashboard Automation & Protection

$30-250 USD

Teljesítve

Kiadva ekkor:

majdnem 6 évvel ezelőtt

$30-250 USD

Teljesítéskor fizetve

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

Projektazonosító: 16929763

A projektről

6 ajánlat

Távolról teljesíthető projekt

Aktiválva: 6 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@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 3 napon belül

5,0

(5 értékelés)

4,1

6 szabadúszó adott átlagosan $98 USD összegű árajánlatot erre a munkára

@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 1 napon belül

4,9

(13 értékelés)

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 1 napon belül

5,0

(8 értékelés)

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 3 napon belül

5,0

(2 értékelés)

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 1 napon belül