list

I have a problem, want to mirror a drop down list on 2 sheets so that when one or other is changed they both change to that same value I have created the first drop down list using DATA VALIDATION from a table on another sheet. I have then gone on to my second sheet where I want the mirrored...

Hi everyone, I have a question I'm not sure if excel is able to do. If I have a list of businesses in excel and want to search the web (probably google) for their website address. Is there a formula or a way to upload my list somewhere and have each business googled and return their website...

Hi all, I have a giant database of NBA players and their NBA 2k ratings, what I'm trying to do is automatically pull them into team lists: To get the starting 5 I use this formula in column C...

Hi, Required a formula help to Extract and return a rows which contains alphabetical text, and return a list wise cells values which contains alphabetical text as based on data specified in column(B4:E8) desired results enclosed. Thanks for the help...

Can anyone help me please, I'm trying to find blank cells in a range (O2142:O2206) and the get reference to those cells. And is there a way to only get reference to the row. see image below: I want it to look for the blank cells in column O (Date Job Delivered) because if there is cells...

Dear community, In Excel, I am building a small database with information on employees, clients, invoices, etc. I have a separate file with some macros that I use to generate invoices. There are 3 things that I would like to have, where the first is required and the other 2 are nice to have...

Hey there, First of all, I want to clear that is my first time to dive into excel that deep so please be patient. What I want is to calculate the minimum number of toilet fixtures upon occupancy classification and occupant load. For example: There is a classification called an assembly that...

Hey there, Basically, i want to create an extremely basic version of OneNote but with a retro style. I lack the programming skills to create this (ive been trying), but i was wondering if maybe it could be done in Excel? Is there a way to create a sort of directory tree of excel sheets within...

Hello, I have been trying to find a solution to creating a Data Validation List that shows a default value (the top item in the list). I found a solution on this board that sort of works. Is it Possible for a Drop Down Menu to have Default Selections? Post #3 seems to work....but only to a...

Hi Everyone, I have a function I am trying to build out and could use some guidance/coaching please. I have a worksheet in a workbook that contains a table which is refreshed from a SharePoint list. What I want to do is, whenever this worksheet/table is refreshed it copies across only what is...

Does anyone have any experience with a macro the creates a new button, the new button created then has code created for it based on a template so that when it is run it will do as specified. It creating a list that has a button on each row where you can delete that line or tick done. I also...

Hi all, I’ve got a sheet with 4 tables on it. I have a cell in B2 with data validation set to a list on another sheet. I can currently hide or show the tables based on either columns or rows. As one table is shown the others are hidden. What I’m wandering is if it is possible to hide or...

Hello everybody, I am currently managing a list of materials for different sections: The top of the list looks like this: I have about 6 sections (EM, Formulering, Inspektion & more - please let me know if you want all the names). I want to create some sort of pivot table (I assume? I...

Hi all, I have developed a tool which creates a new list in sharepoint when I run a macro. But its takes datatypes of column only as 1) Single line of text 2) Number 3) Date But I have a column in excel which has a drop down options but after running he marco, when I check my sharepoint list...

Hello everybody, I currently have the following list: I want to create a formula (probably through conditional formatting i'd imagine), that basically says: If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red...

Hi, I have an Excel file that utilize Excel Data Validation - List by link to another sheet. However, the list seems not in the same pattern due to data were add up later in another sheet. so, the row at top part link to a number of rows while the bottom part link to data in more rows which...

Hello Everybody, First of all, thank you so much for using your time in assisting me with this matter and reading this inquiry. It is greatly appreciated! I am currently making an order form in Excel, where I am pulling my product data (material description) from a sheet I have named...

Hi All, I have a list of information in sheet 1, like the following table Country Month Subject Item and in sheet 2, I created a layout with a drop list for Country and Month attributes I want a VBA code that will retrieve/lookup the subject and item based on select...

In column A, I have a list of values from A2-A503, I fill these cells In column B from Column B2 onwards I want to list the unique values from column A ( A2-A503 ) In column C from Column C2 onwards I want the nos. of repetitions of the unique values listed from B2 onwards PLEASE SEE THE...

Can I have some help please? (See attached image) I have 3 tabs. the first sheet has employee’s data. UserID, Name and Level Second sheet is where I want the help. There sheet shows the users name and level, the level cell is a dropdown list containing all the possible levels. (The list values...