names

Hi Is it possible to create a formula which reads subsequent Sheet names? So if I had data in Sheet 1, for example, I'd like cell A1 to read the name of Sheet 2 (which would be called 'Chocolate') cell A2 to read the name of Sheet 3 (which would be called 'Crisps') I know you can use...

On sheet 1, column A1:A5, I have a list of names: Joe, Smith, Mary, Joan, Bill. Column B1:B5 of the same sheet contains reference codes for the names in A1:A5: JSM, SUT, MRE, KIT, and KTM. On sheet 2, column B1:B5, I have a list of codes that includes some, but not necessarily all, the same...

I need help with a formula or set of formulas to match 2 columns of names. One column will have first and last name and the second column will have last comma first name and sometimes a middle initial. How can I compare the 2 to match the data sets without the middle names, suffixes, etc. I...

Hi all, I can't seem to figure this one out by searching. It seems to be such a simple thing! I have a text box that fills a listbox with team names. After the user fills in a bunch of team names, I would like them to be able to click on one of the names in the listbox and edit it. I've tried...

Hi! I am trying to sum up a column that has different product names. For instance a Batavia Grand Vista and a Gazelle Grand Vista both have a sales value and I am trying to sum up all the Grand Vista's. I found a formula using SUMPRODUCT combined with ISNUMBER but I can't get it to apply to my...

So basically we have set up electronic cover sheets and the formula I am looking for is when i am putting names of the bank staff covering the shift i want the corresponding ward to appear above the bank person's name. Anyone help?

Hey everyone, I'm facing the following problem: I have a table where Column A gives me Names and column B gives me the status "done" or "ongoing". I have a ListBox that populates with all names from column A. I want to be able to select an item in the List and click a button to change the...

Hi, I was hoping someone might be able to help me with a VBA query. I have a workbook that my team update monthly with figures for their service levels. Each team member has their own sheet with cell ranges for each of their clients, and within these cell ranges are cells they populate with...

Hi All, I have a summary sheet with all my suppliers on it. is there a way I can colour the supplier names in the summary sheet with colour of their tabs. thanks in advance.

Hello, i was looking for help on an excel doc, its basically allocating the expenses into different categories but the names for the expenses differ, is there any way i can make the names fit into these specific categories or change each name to fit the category? https://ibb.co/rxw47zq EDIT...

Hi All, I am hoping one of you clever clogs can help me. In column A, I have a a list of names. Some have middle names and some have double barrel surnames. What I want is a formula or VBA code that extracts the data from that column and presents it as follows; Title Forename Surname It...

Guys I have this below table where I want to count the number of occurence of each individual but ignore the duplicate instances Dates. Names 1. X 1. G 2. X 2. X 3. G 4. X 5. G 5. G Please help me, it's urgent

Hey everyone, I've been searching around and can't quite piece together how to achieve this. Problem: I want to apply conditional formatting to a pivot table. This pivot table contains a list of names for the rows, and weeks on the columns. The values are the sum of hours. Data that is...

hi all a tricky one for me here:- a vba solution to stay 5 secs on each sheet and then loop back to the first tab like a slideshow The problem is I only want certain sheets to be showing on this slideshow - which I can hide or have selected in a list ? these sheets have specific names too :-)

Width is set to 45 and col names are centered. Somehow I've managed another effect which I can't repeat. The names are vertically aligned so they're about 1/16 of an inch above the bottom of the cell. Not bottom, centered, or any other setting offered by the Alignment tab (Format Cells). Any...

I would like a Macro to add 001 after a name. This will now be a one off press of a button then not used. Some info for you. Worksheet called POSTAGE Column B Range B8:B881 I now need to add "SPACE 001" no quotes to All the names which do not have 002 003 004 etc after them. My list at present...

Print rows as cols without repeats <ins id="aswift_2_expand" data-ad-slot="9830241510" style="text-decoration-line: none; display: inline-table; border: none; height: 250px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 300px; background-color: transparent;"><ins...

Hello Mr.Excel I have multiple set of workbooks where the file name is standard except first two letters. In each workbook I have multiple tabs where the tab names are standard across the multiple workbooks. I am looking for an macro to convert the excel tabs into separate PDF files...

Hi, I have several named ranges which are blocks of 12 columns. How can I identify individual columns within the named ranges for use in a SUMIFS? The key thing is the named range is the starting point (as there are several exact sized ranges but with different names) and then individual...