완료

Excel VBA code

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.

기술: 엑셀, 앱을 위한 비주얼 베이직

확대 보기: code vba excel serial hard drive, simplex code vba excel, gnenerate xml code vba excel, vba excel code extractor page web, vba excel ready code, vba excel code optimization, code vba excel primavera critical path, update code project excel vba, optimize code vba excel, vba excel code install add ins

고용주 소개:
( 1 리뷰 ) Bogotá, Colombia

프로젝트 ID: #10070955

수상자:

watersev

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, Eugen 더 보기

$35 USD (0일 이내)
(140건의 리뷰)
5.8

이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 14명, 평균 입찰가: $114

$126 USD (1일 이내)
(229 리뷰)
7.5
elqueabandona

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 rega 더 보기

$100 USD (1일 이내)
(95 리뷰)
6.1
zebracaro

I can do it for you quickly and exactly

$250 USD (4일 이내)
(53 리뷰)
5.1
d2imatrix

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일 이내)
(24 리뷰)
4.9
vlayausa

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일 이내)
(23 리뷰)
4.1
carlosperezit

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 d 더 보기

$133 USD (10일 이내)
(15 리뷰)
3.6
vw7209238vw

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 더 보기

$50 USD (5일 이내)
(5 리뷰)
3.5
tonycoyle

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 inventor 더 보기

$200 USD (3일 이내)
(3 리뷰)
2.1
ENRICOJ

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 ,ENRIC 더 보기

$90 USD (3일 이내)
(2 리뷰)
1.2
Crea8iveZone

Hello, Please check our projects and provide us the requirement. We are really interested on your project and ready to discuss [login to view URL] hopefully you will be 100% satisfied like my other good client. => Portfolio: 더 보기

$200 USD (12일 이내)
(0 리뷰)
0.0
$100 USD (3일 이내)
(0 리뷰)
0.0
masterfermin02

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
$45 USD (7일 이내)
(0 리뷰)
0.0
nivivani

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
joshuadavidpeder

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 더 보기

$90 USD (1일 이내)
(0 리뷰)
0.0