I have a large database of information in Excel (no other software choice unfortunately) in which others want to insert data into, without worrying about entering the data into the wrong cells and dirtying up the data source sheet. Said others are not Excel-savvy, and as such I need to prepare...
Hi, I have a couple of customizing ribbons. I want to get all the customize ribbon & command details in excel cells as below.
How can I get this?
My all macros are saved in multiple modules in personal.xlsb file.
Hello,
is it possible to complete this code for MS Excel 2013, so when macro runs, it actually asks for folder, but when selected it would be good that when looping through main folder (that was chosen) it loops in all folders and subfolders and execute simple macro (that is in the code already)...
hey; i need your help; i have a sheet containing 500 types of equipment each equipment has 2 or three prices and i need to get from it the min price , average and max prices and returning the supplier name for each value
So I have over 1500 VCF files that I need to export to an Excel spreadsheet
I tried the conventional Windows Import > Export way but it seems to be taking forever to convert just a few files
Does anyone know of a free tool or a convenient way I could do this quickly?
I am running Excel...
I am a complete noob to VBA. We have a macro that runs fine on Excel 2013 but gets a Run-time error on 2016. The part of the macro where it hangs up is trying to copy and paste merged cells. The error states "To do this, all merged cells need to be the same size." They are the same size. It...
Hi!
I've got a question that is fairly hard to describe (hence the topic title) and impossible to google for, so I'm forced to turn to the experts... Bear with me while I paint the picture.
First and foremost: I'm using Excel 2013.
I've got a large table, couple thousand rows by a hundred or...
I recorded a macro in 2016 and it works fine. Two other users on 2016 have also used it with no issues. I sent the file to a user on Excel 2013 and they get an Invalid Procedure Call or Argument error. I even tried recording the same macro from their computer and it gives me the same error...
Sorry if this is answered elsewhere, I could not seem to find the information that I need.
Running Excel 2013 on Win 10
I have a pivot chart which is showing the Report Filter Field buttons with the names of the columns (I have renamed the Source for each to Custom names). I would like to see...
Hi guys.
Im here looking for a solution of a problem im triying to solve:
in the Mos Excel 2013 im reaching 40% in function and formulas section and i dont know why :(
And i am wondering: Which one is the best/proper way of using the functions?
Hi all,
My organisation currently use a 1-4 scale to score our grounds maintenance contractor's workmanship.
However, our contractor use 1-7.
I need a formula that will convert one to another with 1=1 and 4=7. I need the results to show down to 2 decimals i.e.:
1.00 = 1.00
1.50 = 2.00
2.00...
Hi everyone,
I am so glad i joined this forumn, it has already answered many of my questions i had. The one that is left is i cant seem to figure out why my formulas dont seem to work on some salespeople & it does for some. ( back story: I am trying to pull salespeople information using...
Hello everyone.
When you open an empty excel application, it has by default 1 empty workbook, with 3 sheets (this number is configurable). If you then open another workbook (under the same application) with some content, some differences arise between 2007 and 2013:
- in Excel 2007 version...
Hello and thank you for your time. I have created a report that is shared with clients that has a private sub for when the workbook opens. One of my clients is getting an issue with the bold line of code. Here is some basic information:
I wrote the code/created the workbook in Excel 2016...
Hi, relatively new to VBA Coding.
I'm using Excel 2013, Windows 7
I am trying to build a macro to filter a data Table by a specific date(format dd/mm/yyyy). Within my data Table is a specific column (13) that contains the dates I want to filter by.
When I run my macro it seems to convert the...
Related thread: http://www.mrexcel.com/forum/excel-questions/783092-new-computer-3.html
Hello,
I have a weird issue. I have spreadsheet with some macros that parse xml files and presents the data in relevant columns. The code was written in excel 2010 and works fine in that environment...
Hi there, I havean error message "excel found unreadable content in "name of the wb 2013 excel file" do you want to recover the contents of this workbook? if you trust the source of this workbook, click yes"
If i click yes "name of the wb 2013 excel file" [REPAIRED] <<----- file name.. and try...
In an excel 2010 workbook (which I test on a local 2013 version) i have run into the following problem.
After creating a workbook(wb) i need to then close it without saving.
To do this i change DisplayAlerts to false and then back to true after closing.
This works as intended for when I...
Have just recently upgraded from 2010 to 2013. I notice with 2 books open that when I attempt to click within the foreground workbook that my cursor lands on a background workbook. Repeatedly. I generally Alt-tab between to navigate. The only way to make contact with the correct book is to...
I use Office 2013, and often create pivot tables that require I check off the "Add this data to the Data Model" box when selecting the data range. I know that this can only be done in an excel workbook (and not a CSV, etc.) and have never had an issue building this table before. Suddenly, every...
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.