help !

  1. N

    Macro to group data

    Hello, I have a list of product codes, descriptions and locations. I require a macro based on the highlighted list to create 4 columns with headers please. Product Code, Decription, Loc, Count, then the data, then a space and then the header again, with data etc etc. The data is grouped by...
  2. M

    Macro taking a lot of time to execute

    Hello all ! I am fairly new to MACROS and VBA. Recently I wrote a Macro to segregate data of employees as per their job levels. Since it is for a fairly big organization the number of rows (employees) of the data is huge. I made a simple code for copying the title header of the data to new...
  3. M

    VBA Knowledge Required - Automated Sheets Populated Into Templates

    Hi All, I am learning how excel more and more as my job requires me to and try to use it in my personal life where possible. I have created a budgeting workbook and would like to be able to click a button that will extract all the data in the "master calculator (null)" sheet and place it into...
  4. J

    Please help

    Is there a way I can convert the letter A to 13 and B to 15 number won’t be in order with the letter. need to be able to type a word and for it to spit out a very long number. For example if I was to type hello need a number 22 23 26 26 35. its for an old alarm panel I need to program and it...
  5. B

    Complete Rows Highlighted when there is specific data in cell with specific color & Latest Balance Get Auto Color

    Dear All experts , Please forgive me for my bad English as i am not native English guy. I am assigned to carry on some work from my company and i was given a excel sheet which was probably made by my previous colleague , since i am not very familiar with VBA for excel so i am looking for help...
  6. B

    VBA Coding, need help!

    Hi! I am currently trying to figure out a VBA code (I’m not super familiar, but can grasp concept with little experience I have): The coding is for a training tracking sheet. I have a date in one cell, that will get over-written each year with the new training date. the next cell over...
  7. D

    Change borders/gridlines of cells in rows A, B, C & D when cells in row E contains no blanks

    Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...
  8. L

    Tough Golf Tracker

    Hi guys, I could really appreciate some help tracking some golf matchplay results between me and 3 friends. Each month we play a team competition 2vs2, randomly picked teams, with the lowest score from the team being used. Whichever team has the lowest score wins the hole, if they're the same...
  9. M

    Need a quick assistance for a Gantt Chart in Excel

    Hello, After I enter a date range (start date and end date) for a certain task, I want to be able to physically enter each day a value; say 0 for not done and it would show it in red color, and 1 for done and it would show it green color. Also when I put either values 1 or 0, I want the data...
  10. A

    Need help with either Conditional formula or VBA script to solve issue

    Hello I am having an issue figuring out how to get my duty excel spreadsheet to do the below and am looking for either a formula or VBA based solution: Basically I have the below spreadsheet and if there is a value in the additional duty column (starting at I5) I would like the value to be...
  11. D

    Extracting Data From SUMIFS

    Okay so on a pivot table if you double click a search result you get a new sheet showing the results. I am wondering if there is a method to replicate this from data returned by a sumifs formula?
  12. L

    Searchable drop down lists without Combobox

    Hi all - I have a sheet with multiple columns utilizing data validation drop-downs. I need the drop-downs to be searchable due to the large number of options in the drop-down lists (Country column for example). I understand there are limitations with data validation and this can be done with...
  13. C

    Formula Help

    I am trying to come up with a formula to count how many robot batteries are needed. Below you will see the formula that I am using to input the type of robot battery for that type of robot and multiply the quantity of robots in that column by 4 to come out with how many I need (each robot takes...
  14. S

    VBA - Rewriting a code to avoid pressing "ok" on each loop - extracting data excel files on SharePoint hyperlinks

    Hi All, Every month I have this task of collecting data from about 200 reports, into a main central consolidation file. The Report is an Excel file stored on SharePoint. All the Data i need is on a hidden tab in one Range. Process:- 1. I go to the SharePoint site where the files are stored and...
  15. A

    VBA command to open PDF

    Hi All, my first post here :) I am trying to create an interface to select and open PDF reports from Excel. Currently I have got 4 drop down boxes where users can select which report they would like to see. Currently the options are drop down box 1 : Europe, America and Pacific drop down...
  16. L

    i need to replace some values in a column

    Hello, first that all excuse me for my bad english ;( I need your help, im new with power BI I have a table named LECTURA that contains a column named SMS. The column SMS have a lot of values, and i need to change the value of a part of it. The values i need to change have the structure...
  17. P

    conditional formatting help

    Hi, I need to have rows highlighted that have to meet 3 criteria in a table and was unsure what statement would be best, two have to be a specific text and one has to be above a certain number.
  18. K

    Combining multiple cells into one

    Hello! This is my first post on Mr Excel :) I am trying to collate a list of numbers so they have an exclamation mark at the start and a semi-colon at the end. I wish for these to all end up in one cell so I can copy and paste them into a business intelligence system that requires this format...
  19. H

    Checkbox editing

    Hello. new to here need some help with checkbox and conditional formatting, ill explain my problem. i have a column, eg A, which has dates in, so different dates in each cell in column A i have set some conditional formatting to change the colour of the cells in A depending on the proximity of...
  20. C

    Looking to learn a formula to help me with...

    I am extracting data from two different vendors, the data I'm extracting should be the same, however a quick glance indicates it isn't! For example, lets say one file contains a list of 1000 students' names. The other file contains 987 students' names. What's the best way to cross reference both...

Watch MrExcel Video

This Week's Hot Topics

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
Top