ability

I like the ability to use conditions, such as [<100], or colours, such as [Red], in custom number formats in cells. But can I use these, or an equivalent, using Format in VBA? My current requirement is something like this: shtCalendar.Cells(rt, cPlace) = shtEvents.Cells(r, cEventPlace) &...

Hello MrExcel Forums! First post, so please let me know if I am performing any forum faux pas on here. I searched/lurked through many threads but couldn't seem to find the answer I was looking for. I made an excel tool for some very not savvy excel people. It is protected and I'm building...

I'm pretty new to VB and userforms and I've searched forexisting templates and modified them slightly but I could not create the searchor update function. I’m wondering ifsomeone has a userform template that has the ability to search and update aparticular row of data as well as having a...

I'm trying to compare two list. I have two list that have the same type of data, but they are from different sources. Both files have a list of departments and the permissions each department has. I need to lookup a department name and determine if that dept has a permission listed next to...

Hi Folks, I know this is a excel forum but I really needs some guidance. I am in need of creating a training database. I didn't know whether their is a forum for databases like their is for excel so I thought I would just throw out the question. I am wanting a database to record training...

I'm a novice with excel. I've used it very basically and am trying to expand the near limitless potential. I have a question. We have a spreadsheet with multiple inputs in different columns with assigned values. I'd like to be able to tally each common input and value over the entire sheet. As...

Hi Everyone, I just recently updated from Excel 2007 to 2016 and trying to figure out what is new that was added since 2007, that would be noticeable. For example, I found: -Power Fill -Ability to move Excel Files to different screens, instead of being on top of each other -Ability to fill...

Hi Guys, I'm using Excel 2016 and trying to retrieve some values from a table, here's a simple example; <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Dept Sub Dept Sales Dept A Dept A1 100 Dept A Dept A2 150 Dept B Dept B1 500...

I have two different queries being pulled from SharePoint. Table 1 has a column which references the unique ID from Table 2. The caveat is the unique ID cell can have multiple IDs separated by spaces (3). Table 1 example: <tbody> Number Name Phone Number Zip Code Story ID(s) 14A Paul...

I have a spreadsheet which has many +COUNTIFS, +SUMIFs in a series. Example =COUNTIFS(A1:A100,"*Name*",B1:100,"*Title*")+COUNTIFS(A1:A100,"*Other*",B1:100,"*Other*")+COUNTIFS(A1:A100,"*Var1*",B1:100,"*Var2*")+ If I redo with something like this below, would this improve excel's ability to...

Have a few macros that would benefit from this greatly, but don't think I have seen this included. Is there any macro code that when added, that can allow any macro that navigates your selection cursor (black rectangle) to a specific cell/row that when it navigates it places the result (row /...

Hi there, Would anyone know where I could find a worksheet very similar to the Smart sheet programs - https://www.smartsheet.com/landing-b - which seems to be excel based? :eeek: I don't need most of the features just the ability to have: - Line based organising with collapsible task with sub...