excel

  1. D

    Vba to create a new excel file and convert all cell formulas to text

    Hello, I'm trying to create VBA code that converts all current formulas in cells to text values and save the entire sheet to a new XLS file. For this purpose I've used the following VBA code, but it doesn't do what I want. The newly created XLS file still contains formulas in the cells. I...
  2. I

    Changing text into numbers

    Hello! I am currently doing my dissertation and I am trying to get my data from Excel into SPSS. However I have quite a lot of quantitative data that I need to turn into numbers to do this. I’m just wondering how I turn a mass amount of qualitative data in Excel into numbers so that I can put...
  3. Ramadan

    Override the last saved sheet as paf file

    I have found a code and modified it to perform my need which is to cycle the drop down list in a sheet and save the filtered data as PDFs in external folder with the currant date after the file name. but because the curranet date is changable of course, the folder still keeping the last time...
  4. S

    How do I fix my options pane? Options pane is greyed out. Workbook & sheets are unprotected.

  5. D

    Excel vba userform trying to filter ado recordset

    I have an excel vba userform from which I connect to an adodb (ms access), But I am trying to filter on the date (Datum) field. Both via sql statement or the recordset.filter method but neither seems to work. Here is my code: Private Sub UserForm_Initialize() Dim con As Object Dim...
  6. D

    Excel userform edit database table

    I have an excel userform where I can search for and create new database entries in an ms access table. But when I try to edit existing entries it gives me an error that the object doesn't support this action. here is my code so far: Private Sub EditButton_Click() Dim con As Object...
  7. Ramadan

    VBA to Navigate Drop Down List and Save page as PDF

    I have a worksheet with a drop down list in "B2" to filter the data and I have a code to save the viewed information in the sheet as PDF to external forlder "D:\Desktop\Daily Tasks" and to name the file based on cell value in "C2" My drop down list has only 5 items (NH01,NH03,NH04,NH05,NH06)...
  8. D

    Populate excel listbox with database table

    Hi, I am trying to make an excel userform that connects to an access database. So far I can search and create new database entries from withing excel. But I can't seem to populate my listbox with a selection of my database table. Here is my code for initializing the userform and fill the...
  9. C

    VBA form not being recognised by the code

    Hi All, I've searched this forum and others without success solving this weird problem. It might be an Excel bug, but I'm hoping it's just something I'm doing wrong. My fairly basic spreadsheet has two userforms. One works perfectly well but the other won't even load. It did when I first...
  10. Ramadan

    How to include my email signature in VBA

    I have found a code on the web to send excel file as attachment and modified it to settle my needs but I need your professional help to add my signature image to the email body and to make the email body text to be set as (Right to Left) here is my code and screenshot of my email signature need...
  11. A

    Detecting when a user has highlighted a row and displaying the contents of that row in another sheet

    Hello, I am pretty new to excel and I am trying to create a macro or by using equations to detect when a row is highlighted, the content in that row gets copied and pasted in another sheet in a specific row. How do I go about doing it? This is an example of the data in sheet2 (where the content...
  12. L

    Sumifs table by header row and column criteria

    Hello, I'm struggling with the sumif function on a table. I want to be able to sum a range based on the header row, and two column criteria (Sub Type and Prod). To get the sum value of Apple in Act Jan for Tag1 - I tried the formula below =SUMIFS(Table3,Table3[#Headers],I5,Table3[Sub...
  13. J

    Prevent Automatic Link Updating/Changing

    I created a spreadsheet to be a search tool for our client directives and instructions. Each entry in the spreadsheet has a link to the actual document. To ensure the security of the data from unauthorized or accidental changes, I upload a copy of the master file to our local network for people...
  14. V

    Excel Link to AppSheet

    Hello everyone. My company just purchased an app for my every workflow. The App is a link AppSheet. My question is that how can I link my excel to the AppSheet? I tried import data from web but it didn’t work. I tried google it, it says go to my account setting in AppSheet but company provides...
  15. S

    Product of 2 tables/datasets with multiple criteria (mix of Column/Row)

    Looking for some help with a formula to calculate the total requirement of a part over multiple variants. Example below: Part list with Type Quantity Type1Type2Type3Type4Type5 Part101234 Part240123 Part334012 Part423401 Part512340 Type demand for each WK WK1WK2WK3WK4WK5...
  16. M

    Increase letter and number sequence in order

    I am creating a SKU system for a huge catalogue of items that will grow and grow over time, I'm looking to future proof with a SKU that can create over a billion variations so I will never run out and is easy to understand I'm looking at the following: AA0A0AA AA0A0AB AA0A0AC up to: ZZ9Z9ZX...
  17. O

    Spreadsheet Compare Output

    I've used Spreadsheet Compare to compare 2 spreadsheets and got Export results sheet as an output. Does the Program have a switch or option functionality of giving me a better, user-friendly output that shows me which rows have been deleted, added or changed on the sheets? I'm not looking to...
  18. R

    Adding a checkmark in Microsoft and MacOS Excel

    I work from both Microsoft and MacOS platforms. I am in need of a macro that will add a checkmark to a cell easily. I have tried using code from a previous request "Using VBA in EXCEL to add a checkmark to a cell" but it will not work on my new Microsoft machine and I am not sure it will work on...
  19. M

    Excel Formula to get "OKAY' between 2 sets of tolerances

    I need an Excel formula that checks for value between 2 seperate ranges. Check if value is between (.0406 and .0483) or between values (-.0483 and -.0406). Either value is OK in the Same Cell I tried and if statement. This one Didnt work however. This is what I have. However the code only...
  20. F

    Cycle through different Rate Sheets

    Hey Team, I'm trying to reference multiple different rate sheets for my estimating sheets. To start simple, all I want to do is have a table on my estimating spreadsheet that shows either the info from Administration 01 on rate sheet 1 or Engineering 01 on rate sheet 2 based on maybe the info...

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