excel

  1. R

    How to calculate the sum in this situation?

    Hello everyone, In Excel, I entered two numbers in a single cell by using the Alt+Enter command to add a line break. I want to calculate the sum of these numbers, but I don't want to use VBA. I know ChatGPT can write VBA code, but I am looking for a non-VBA solution. Could someone help me with...
  2. D

    Partially Greyed out sheets when opened

    Hi All. I have an MS Office 365 Excel workbook which analyses data and provides charts to show results and "filterable" data. I have buttons for navigation from a dashboard. When I navigate to any sheet for the first time it has parts of the sheet greyed out. If I navigate to another sheet...
  3. Y

    Need help with VBA-generated QR Code

    Hi Tech, Need help with VBA-generated QR Code based on values in certain cells......................... Series, Firstname, Lastname, Math Grade, Stat Grade, English Grade, Email, Tel, Notification. Thank you
  4. M

    Issue with FILTER function

    I'm having an issue with a FILTER function that is just sending back a value of #N/A and the error help obviously doesn't say too much. Hoping someone here can help. My formula is =FILTER(TimetrackedLogs!$A$2:$N$200000,TimetrackedLogs!$N$2:$N$200000="my_value","No results") Column N in the...
  5. J

    Missing Pieces of my Puzzle!! Please Help!!

    Can somebody help me fill in the green column. Please also put what is missing the the formula and show me where to put the correct functions in row 1 too. I was using Clearbit V1 API. initially. GET https://autocomplete./companies/suggest?query= name...
  6. U

    Vba shows total records, instead of record(s) found.

    I have a macro which works the way i want it to except for this part.. Set rng = ws.UsedRange.Columns(1) .Cells(r, "H") = rng.SpecialCells(xlCellTypeVisible).Count it returns y, instead of x in (x of y records found) this happens after autofiltering with vba.
  7. M

    VBA script help for copying same data into different tabs

    Hi there I am looking for help on writing some VBA code for the following. I have an entire data tab (titled "paste 1804") I need copied into 2 different tabs with same format, content, etc..: I have Macro push button labeled "Run data Macro", on a tab labeled "Marcos" Source tab to copy...
  8. N

    Spreadsheet with lots of formulas and named ranges takes time to load and clocks each time a cell is updated

    I have a spreadsheet that is used to manage the annual budget along with monthly forecast, monthly resource costs, vacations etc. in separate sheets in the same workbook. So needless to say there are lots of formulas in these sheets and references across sheets. I am also using named ranges and...
  9. A

    Open, Copy data and Close a workbook based on the names of the tabs in my active workbook

    Hello everyone, Apologies English is not my first language and I am very new to writing VBA codes. So far, I have only copied and adapted parts of the codes to fit my needs. Recently, I have created a workbook, each tab has the name of a treatment site. Daily, I receive data about these...
  10. C

    Copy, paste, change name of file.

    I am working on a quote tracking program in excel and would like to streamline the quoting process. I have an office form my sales staff can fill in which populates an excel table for me to see the information. Within the table I have formulas to do many things and one is to compile a lot of the...
  11. B

    VBA for copying data from multiple ranges until blank into a list

    Hello, I am trying to copy values from Columns R, W, X and Z from the Template (red pic) into columns A, B, C, D. I need a VBA to go through these columns until there is a blank row and then paste it into A,B,C as so it creates a nice list going down. I will need this code to continue multiple...
  12. M

    Sum together the larger amount of two ranges by row

    I have to believe this has been solved before, but I could not find a previous post for my particular problem, so apologies if I missed a previous one. I'm trying to use SUMIF/SUMIFS or some variation of formula to look at two different columns of price amounts, determine for each row which of...
  13. S

    Is there an alternate way to look into an excel sheet instead of connections and queries?

    I have 2 workbooks. One is a Bill of materials (Bom) and the other is a master list (Ml). My bom takes the Ml as a connection, manipulates the data through power query and spits in on a new worksheet in the Bom workbook. I then open a new sheet (within the bom workbook) perform a vlookup and...
  14. Ramadan

    What is the lookup formula to search in multiple columns

    I have a worksheet table with 4 columns containing employee name and 4 columns for ID number for this employee simply and I need a formula to add the employee ID number which is next to the name if the cell match any cell of the employees names in the 4 columns ("B , D , F or H") for example as...
  15. Ramadan

    Retype Macro to run properly

    I have recorded a Macro to re-arrange my table with color and to sort row by date Ascending but later I needed to add 03 rules to remove all filters in the table to show all data then to go to the last row in table and to save the workbook but it seems that they need to be set in a professional...
  16. D

    Calculating a YTD Balance based on end date?

    Not sure if this is possible - but wanted to ask. Need to calculate a "Year-to-date" balance of a savings account while using the TODAY() function as the start date (so it dynamically changes). Ex: Total Goal Amt: 5000 End Date: Dec 2026 Total # of Months till completion: 24 (*calculated...
  17. P

    Seeking Code / Macro to Edit Row Height

    I piece together weekly reports for my team. I keep row heights at a minimum 75.00, 100 pixels and maximum 203.25, 271 pixels. To take a lot of time out of this task and make it automated, I would like to conditionally format (though probably not possible based on my research) or enter a code /...
  18. M

    Getting data from a sheet referenced by VLOOKUP

    Hi All, I'm looking for help on a formula reference using VLOOKUP. I have a table which maps some project names to Sheet names, as the project names are very lengthy but the Sheet names are small enough for the tabs in Excel. Using that table and VLOOKUP, I'm looking to use the output of the...
  19. V

    Calculating coloured/uncoloured cells in a table

    Hi, And again, i need help from some bright "excellers". This time, as per the attached screenshot, there is a table with 14 rows and 6 columns (A2:G17, A2 and A3 merged just to have the title "Name", then whole A4-A17 filled with names, B3-G3 filled with time slots). 14 rows corresponds to 14...
  20. V

    Excel: drop down list colouring based on "dependent" list

    I am looking for a solution for my excel sheet and am not finding any on the internet. I have the following data for the dropdown list. I'd like my dropdown list to reflect Column B and the color from Column D according to Column C value that corresponds to the cell from Column B. I seem to not...

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