Find Jobs
Hire Freelancers

Excel VBA code

$30-250 USD

완료함
게시됨 약 8년 전

$30-250 USD

제출할때 지불됩니다
I have been working on 2 linked workbooks for the last couple of weeks. The 1st workbook is a template for a registry of all of the items we have within our organization. The 2nd workbook is a template for inventory of items assigned to all people, places, and vehicles in our organization. I have formulas that link the 2nd workbook to the first workbook so that each time an item is assigned to a person, place, or vehicle, it will automatically show up on the inventory worksheet. The problem I have is that the formulas are static and require manual updating if we are to add new items to the 1st workbook. I also have a VBA code to lock cells after data has been entered, which is great for protecting data and formulas. However, it does not allow for sorting, which would be a very helpful function to have. Does anyone have some VBA codes that would allow for: 1) automatically creating named ranges for new items added to the 1st workbook so that they will be included in the 2nd workbook? 2) sorting and filtering of locked cells in a protected worksheet Any help would be much appreciated.
프로젝트 ID: 10070955

프로젝트 정보

14 제안서
원격근무 프로젝트
활동 중 8년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
Hi there, regarding the issues specified: 1. I guess you need to make a dynamic named range in wkb 1 and refer to it wkb 2 2. Sorting and Autofiltering is an option to allow when protecting sheet Best regards, Eugene
$35 USD 0일에
5.0 (140 건의 리뷰)
5.8
5.8
14 이 프로젝트에 프리랜서들의 평균 입찰은 $114 USD입니다.
사용자 아바타
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$100 USD 1일에
4.9 (95 건의 리뷰)
6.1
6.1
사용자 아바타
I can do it for you quickly and exactly
$250 USD 4일에
4.9 (53 건의 리뷰)
5.1
5.1
사용자 아바타
Hi, We are experts in Excel reporting, dynamic formula creation, designing dashboard, VBA macro for automation. We can do your job. However if you can share the Excel files it would be great. Regards, Pal
$155 USD 3일에
5.0 (24 건의 리뷰)
4.9
4.9
사용자 아바타
Hello, I am proficient with Excel and VBA and I would love to help you solve this issue. Please contact me for more information.
$55 USD 2일에
4.9 (23 건의 리뷰)
4.1
4.1
사용자 아바타
Hola Soy especialista en tecnologías MS. Lo que te sugiero es migrar tu base de datos a una tecnología más idónea para el almacenamiento de datos como Access o mejor SQL Server. Excel puede acceder facilmente a la data almacenada en bases de datos relacionales Saludos Carlos
$133 USD 10일에
5.0 (15 건의 리뷰)
3.6
3.6
사용자 아바타
I have the way to lock, unlock dynamically your sheets in order to sort them and let it protected before save. Or immediatelly after sorted. I did it for a personal project about a POS, which I use to sale currently. It is tested , and proven. no doubts. Let us chat if interested, Please read the profile and comments from my clients as a reference.
$50 USD 5일에
5.0 (5 건의 리뷰)
3.5
3.5
사용자 아바타
I have extensive experience building models with vba automation. Your solution is in two parts. part 1: manage names ranges so that new data extends those ranges such that the new item is reflected in the inventory... (solution depends on the excel version in use!). Update formulae to be dynamic (if possible) rather than static (again, depends upon excel version in use) part 2: sorting and filtering locked sheets. We can partially replicate this functionality in a button/field combo... the attached code will essentially (unlock the sheet, perform the sort/filter/ relock the sheet) Details will again depend on the excel version.
$200 USD 3일에
5.0 (3 건의 리뷰)
2.1
2.1
사용자 아바타
HI. I AM ENRICO. I BELIEVE I CAN DEVELOPE THE CODE FOR YOU AS MY SKILL SET INCLUDE DATA INTEGRATION, ME EXCEL ,MS ACCESS AND VBA CODING. PLEASE FEEL FREE TO APPROACH ME FOR FURTER ASSISTANCE . KIND REGARDS ,ENRICO
$90 USD 3일에
5.0 (2 건의 리뷰)
1.2
1.2
사용자 아바타
hello if you send an example of the templete thats you are using i could give a soluction, i have a lot experince working with VBA
$155 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I'm a maestro in excel with 6+ years exp. Just a piece of cake for me. Have already created work books like this. You don't even need a VBA code for this. Can be achieved with a combination of excel formulae
$111 USD 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hi there, I would suggest a named range as you mention. With the locking of cells, what is the business process around this? Is the spreadsheet accessed by multiple people, or controlled by one person? What happens if you make a mistake in entering data? I propose two buttons on the second spreadsheet, one to lock/unlock data, the second to sort (with an option to choose which column to sort by) Cheers Josh
$90 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (COLOMBIA)
Bogotá, Colombia
5.0
1
결제 수단 확인
3월 28, 2016부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.