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.
이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 14명, 평균 입찰가: $114
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
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