I just created a custom list in an Excel file that I am using for a Slicer and pivot table filter.
I emailed the file to another person and the custom list did not transfer with the file?
How can I make sure that the custom list stays in the file?
I have a worksheet with a list of properties. Every time an expense is added to the list it goes on the last row for the property, just above the total.
I welcome any kind of solution either a worksheet formula or a VBA solution that would insert the new row and update the =SUBTOTAL( and =Sum(...
I have a workbook with multiple drop down lists. Unfortunately, all the drop downs are not using data validation.
We need to have the list "reset" to the first item of each list. Is there a way to do this with just one Reset Button?
In this scenario I am trying to track how many calls a staff member made in Jan. The catch is there are some calls that are not eligable for tracking. The ineligable call statuses are in a list. Is there a way to do this?
I'm not great with excel, any help is appreciated!
Count if the 'month'...
I have a macro for listing all name ranges in active workbook when a certain worksheet is activated. the code is Sub Rprt()
Dim nm As Name, n As Long, y As RANGE, z As Worksheet
Application.ScreenUpdating = False
Set z = ActiveSheet
n = 8
This whole scientific non-sense that Excel defaults to for some numbers is quite annoying.
I have a list of phone extensions from a PBX. The list includes the port number to which each extension is associated. The following is an example of some of the ports: 01E0205, 01E0713...
i want to select a value from dropdown list and have tried below code, but can't work.
please take a look:
<select name="fldcusval" nchange="fnSetBankName();fnSetCurrencyList()fnGetCustomer();;displayDetails (this);">..</selec>
I am currently using a nested '=find(text,cell)' formula to categorise a list for example.
If the term Doctor, Surgeon, Nurse, OT is in cell containing job title then the formula will return 'Medical'.
This I have done by nesting separate find fictions for each key work with an if statement...
This is my first post so please bare with me. I am trying to make a configurator for work. Here is what I'm trying to do:
B22 is a Drop down list made from Data validation. This list contains different types of equipment that is placed on different Chassis. I want to be able to click...
I have a list in excel that looks similar to this:
I am trying to get the list so that it looks as follows:
Suppose I have a list as per below :-
In my actual excel the list is much larger...
I've got a list of names in Col G from row 14 down.
Users add the name or names of the owner/s of the associated task described on that row. VBA allows the user to enter more than one name in the cell as sometimes two people are involved on a single task.
What I'd like is to have a...
I have big table of monthly spending, i wanna know how can i show results based on Data Validation list choice,
1-List shows Models ( E:E )
2-List shows Department ( B:B )
3-List shows Month
I need formula to return matching all 3 list, can anybody help me please?
Hi! This seems like it should be pretty easy, but I can't get Excel to accept my formula. Maybe there's a better way to do what I am trying to do. There are two relevant tabs, "Total Summary" and "List." I am entering the formula on "Total Summary" to count items that meet specific criteria...
Hi All, I'm working on a spreadsheet that I would like to pick a random name from a list of 10 names using a vba button.
the list of names are in cells C3:C12 and I would like the selected name to appear in cell D3
Thanks in advance.
Hi, I am making a Name List where people can put their name in a cell, and click on a macro-recorded button to automatically add their name to a new row in an existing list.
However, I am trying to add VBA to set a limit to the number of rows that can be filled in this list. So, if I want the...
I did a list as suggested here :
It works very fine.
However, I would like to improve it for my needs.
My list in column F contains cell with many words, separated by a coma : “,”
F3 : house, cat, hospital...
Hello, how would I count the unique in a range like this and extract them in to a vertical list please...?
Any help here would be appreciated greatly.
1 Copy Item A from List A
2 Paste flat to B2
3 Recalculate the result to update C2
4 Copy range B2:C2
5 Paste flat to bottom of List B
6 Goto next cell on List A
Repeat steps 1-6
Stop at bottom of List A...