excel 2010

So, I am fairly new to VBA and I am having a difficult time with this. I have a template that is to be modified and will be saved and create a new file for each modification (is a template for work shift information). For every different file saved, the main database needs to be updated, so...

Any help would be appreciated, I have a workbook where I need to find fuzzy duplicates, however I am not sure how to code in VBA. I was looking to get it put a percentage and row number of the duplicate in the two columns next the data to indicate a duplicate/ possible duplicate. like this...

Hi everybody - I previously had a drop-down box with a Data Validation list. I then created a combo box in order to have auto-complete. I have since deleted the data that was assigned to the drop-down box via the Data Validation list. I want to assign a new set of data to the drop-down box /...

Hi everyone. I'm a complete noob so appreciate any help you all can provide. I'm trying to edit the below code so that when a CommandButton is clicked, it allows me to copy row data from a different tab "QRR Template" and paste/transpose the data on the tab where the button is located. I'd...

Hello, I have a distributable workbook that utilizes custom sort lists. I would like to include a macro in the file that (when someone else opens the file) automatically runs and imports the custom lists. I have a macro that adds the lists but the issue is on repeated use. Currently, if the...

Hello everyone on this forum, I just made a custom function that allows me to check if a string does satisfy a regular expression. If I enter the formula into an empty cell, it works perfectly fine and returns a boolean. However, if I want to use the exact same formula in Data Validation, it...

Hi everybody. I'm having issues with setting up multiple drop-down boxes to auto-complete with a set list of data values. I've got two tabs that have multiple drop-down boxes utilizing the same data values from a third tab. Because some of the drop-downs have multiple selections (Country for...

I've been able to restrict the value of cells to drop down values, whole numbers, dates, etc. I'm trying to restrict the value of cells to a percentage. I don't see percentage as a value for 'Data Validation'. Is there a way to restrict the entry of a value of a cell to a number percentage? For...

I am working with an involved PowerPivot data model in Excel 2010. This model has multiple sources of data and numerous pivot tables. Some of the people on the distribution list use Excel 2016 so to make their lives easier, I am providing a "pre-upgraded" workbook for Excel 2016 for them. I...

I am working with an involved PowerPivot data model in Excel 2010. This model has multiple sources of data and numerous pivot tables. Some of the people on the distribution list use Excel 2016 so to make their lives easier, I am providing a "pre-upgraded" workbook for Excel 2016 for them. I...

Hi group, I am working on a spreadsheet that has a row of formulas that are from the range ("BB4:BX4") what I am trying to do is get a list of the cell location and the formula within that cell. Anyone have any code that can do that? I would need the results on "Sheet1" in cell A2. Example...

Anyone ever see these kinds of issues? My code executes just fine and quickly in excel 2010 but errors out on one line in Excel 2016? *Please forgive the archaic selects all over this code, I didn't write it but I have already re-written but the error still occurs on the same line...

Not sure what is wrong with my code but it is erroring outon one line, I am not sure why the select command is not working? My code Option Explicit '-------------------------------------------------------- '--- Updates ByCostCenter Sheet...

Dear, I have a worksheet, which contains many formulas; I need to copy this worksheet to a separate workbook without the formulas (value only). The problem I am facing is that by using the macro below, it changes results such as 210.000 to 210, and I need to maintain the original result as...

Hi guys, encountering something really weird, I have a workbook that was saved in .xls format (97-2003) and whenever I add some borders under text and bold some text as soon as I save/close and reopen all the format I made has disappeared? Anyone ever have this happen to them? What makes this...

Hi guys, have an issue that is giving me a headache. I have 25 .xls files (formatted for 97-2003 Worksheet). All the files are the same and have the same data in them. The only difference of the files is a few Headers of Territory names (i.e contry names). I have a macro on a seperate .xlsm...

Hi guys, working on a code that I got to work but need a small addition to this code. Currently, the code will loop thru a named range of file names and then opens and deletes specific tabs and then closes and loops to the next file. I need to add a piece of code that will move on if it comes...

Hi guys - working on a project to set some formulas to the lastrow. normally I would use the "Cells(Rows.Count, 1).End(xlUp).Row" type method because it works great for me. But for this worksheet I am unable to use this method so I spotted a column that defines the last row based on a cells text...

Hi group, I am at the last step of my code and I am running into a little issue. I have an emailscript that drafts an email and attaches a link to the activeworkbook to the email and adds a calculated time stamp. Prior to adding the timestamp the code runs fine and without issue. When I add...

Hi all, I have tried using the below code to add an Active X button to automatically send an email. I have gotten this to work but wanted to add some static text to the email body along with the file path of the current workbook and was wondering if someone could help? If possible also I’d like...