table

  1. N

    Formula to change font color in part of cell only

    I have a large table of prices. The column headers in the top row have titles with some duplicates which can't be changed. I can't break up the table into more than one. Those column headers in the top row also are used to produce a validation list. But that list first shows up in a spill list...
  2. W

    Dynamic dropdown list based on database

    Hi all. I have a sheet with selection options in database format: Tag Value A 123 A 234 A 321 B 12 B 34 C 1 On a second sheet I want the cells to have a dropdown list based on the filtered value of the database. The value which should be filtered on is in the header row, e.g...
  3. A

    Show Data Validation Lists in Next Row of Table

    Hi All, I struggled a bit with the title - so I'll try to explain more clearly. I have created a Table in Excel, which I intend to share with a selection of users to populate. This will result in a indeterminate number of rows being populated. Each column in my Table (10 columns in total)...
  4. E

    Add row to table copying formatting

    Hi, Very grateful for anyone's help or advice! I have a table called "CR_Table" - I'm looking to add some VBA code to insert a row to the bottom of the table when I click on a button, copying the formatting/ formula from above. Please could anyone let me know what code would help me do this...
  5. M

    Formatting Finance Tables in Excel for Mac - need advice!

    Hi Everyone, I hope I can find an answer in this forum :) I'm working on formatting 20 finance tables in Excel for Mac and want to create a system for future use. The goal is to make it easy for our finance team to format tables consistently. So I've formatted a table with various styles...
  6. S

    Looking to create dependent dropdowns

    Hi, I have an excel sheet that need to look for values in a table. I want to select from a dropdown a BRAND, then when I select the BRAND I want a unique list of all the models for that BRAND. Then select a MODEL and have the next dropdown have a list of all the SIZES... First picture is the...
  7. Z

    Excel table To split or not to split??

    Hello masters of excel! I need advice... I have a data set or a table with about 6000 rows and about 20 columns of text and another 15 or so with some formulas splitting some strings then DATEDIF and then converting to years and months a few times over.. So.. Not a huge amount of of data but...
  8. M

    Table not deleting rows

    Hi Everyone, I have a 30 column table in excel, and the first 6 columns are getting data from a sharepoint list connection, however when I delete or add a row in sharepoint list only the first 6 columns of the table are being removed/added and the other columns are just shifting up/down. How do...
  9. T

    Pivot/unpivot help

    Hi Using PowerQuery I want to transform the first table into the second so that every 'Number' in a 'Region' shows every 'Location' in that 'Region', with multiple rows per 'Number'. This is just dummy data. I have tried doing this with pivot/unpivot but struggling to get my head around it...
  10. trishcollins

    Reference Dynamic Table Header Name in Hyperlink

    Okay, I have several tables on several worksheets. I have another table that lists all the formulas from the other tables, so that if I ever get hit by a bus, and someone wipes out the original formula in the other table, they can find it here. I am only using formulas in this spreadsheet, as...
  11. X

    Problems when i add new rows in table via userform. Formulas wont get taken over and cell formats are changing

    So i have this table here: DEFGHIJKL4#BewerbungslisteOrtDatumPortalStatusLetztes UpdateTage seit BewerbungKommentar51Roland Deeg GmbHKirchberg an der Jagst23.10.2023Bewerbung per HomepageAbsage22.11.202338Die Bewerbung ist 38 Tage her62JMS AG Jet Maintenance &...
  12. T

    VBA inserting formula's in cells not working

    For Excel VBA, I am trying to make a code which looks at the value in the column "case type" and let it paste a formula or clear a cell, based on said value in the cell of the column "case type". For Case type 1, Column 1 should contain be cleared of any values and Column 2 should contain...
  13. D

    VBA based on cell value search for it in the table and then copy a row (help with existing code)

    I managed to have to make it partially work; however, it copied and pasted a whole range from Data sheet - I want only the row that matches C6 from Entry sheet . Here is the code: Sub Find_Order() Dim entrySheet As Worksheet Dim dataSheet As Worksheet Dim checkSheet As Worksheet...
  14. T

    Linear Extrapolation / Forecast for upcoming months

    Hello Everyone, I have got a data model at hand with several dimensions including date, hierarchical and structural fields as seen in the table below. What I now would like to do is to calculate sales for upcoming months of the current year. How it's supposed to be calculated is shown in the...
  15. S

    Convert table to list (Number)

    Hi I have the following code to convert sheet range to number in power query, The range named "Tests" would accept any thing except number. I know there is minor change I have to do, but I couldn't figure it out. let Source = Excel.CurrentWorkbook(){[Name= "Tests"]}[Content], MyList=...
  16. T

    How copy a Word table into Excel and not lose the formatting ?

    Hi guys, how are you? I need your help because I want ran from boring and hard job to work with PDF and I want to convert the table from PDF to Excel. I read different forums and watch different videos on youtube but cant find the solution. I found only good advice to convert PDF to Word...
  17. oriwitt

    Graph from multiple data series

    Hi, I have multiple data series provided from a source in a format similar to SeriesName1 NameTitle DataPoint1Title DataPoint2Title DataPoint3Title Person1 DataPoint1 DataPoint2 DataPoint3 Person2 DataPoint1 DataPoint2 DataPoint3 etc SeriesName2 NameTitle DataPoint1Title DataPoint2Title...
  18. D

    When cell with formula changes -> edit adjacent cell

    Hi all, I want to know if its possible the below scenario: I have a table, with some formulas here and there, but in column O, I have a formula with some conditions and dependent on other 3 columns in same table. What I want to know, is, if I can have some kind of script that every time...
  19. E

    Please could you help with Named Table

    I need code to stop running when a Table called Table2 is already there. Some reason I can`t get the Function to work with main code? Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim Rng Dim Result As Integer Call DeleteTbl If Selection.Count > 1 Then...
  20. G

    Copy/Pasting a Table

    On Sheet 1, I have a table that gets copied onto Sheet 2. Sheet 2 then has the entire table with some additional information that is manually inputted with each row. Currently I have it set up in each column where it is just ='Sheet1!'A1 for every cell. I get my information from Sheet 1 from...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top