vba help needed

Hi All, I'm looking for some help with this line of code below. It's working fine, except for when there is NO "#N/A" in the dataset, it errors out when it cannot find #N/A to delete. Can someone help me with this.? I think it needs something like, "If #N/A doesn't exist Sub". I don't know...

Hi Excel VBA Experts, I have a few Subs that does what it's supposed to - it takes an Excel Template, makes a copy and populates it with data from multiple Tabs. My objective is to make a copy of the Template ("Master Data Roll Up - Template.xlsx") to "Master Data Roll Up - Template...

Dear VBA experts, I'm not sure if this is possible. I don't know how to write VBA. I usually do a google search and adapt Subs. I have a VBA that copies daily data downloaded (15 Files=15 Tabs-Template) files onto an MS Excel Template. Sometimes, I may miss a download(s). How can I have a...

Hello VBA experts, I have a problem, that seems very simple, but I just can't find the solution. How do I copy a dataset, excluding the row with totals(Lastrow)? Here is my code that I'm using: Sub CopyData() Range("A4").Select Range(Selection, Selection.End(xlToRight)).Select...

I'm using Microsoft 365 for Business - Excel version 2107 I have a workbook with multiple tabs and have the code below that deletes worksheets that are not listed in the array. I run this code on a monthly basis to generate reports, and the code has worked without any problems in the past...

Hello everyone, I have some vba I use on a workbook with multiple tabs. The code copies a selected range from a tab (the range will be a single row - columns A - H) each time it's selected and pastes the selected range to the next available row on the sheet named "List". 2 Questions: 1) I...

I'm on Microsoft 365 for business with Excel version 2006 (Build 13001.20266) Excel is crashing when I run code with .Delete. Any idea how to get around this? I have some code that deletes sheets not listed in an array. This Example 1 code has worked fine in the past but started crashing excel...

I am in need of a VBA macro I can apply to a button to copy range E2:O100 and R2:AJ100 on work sheet titled "Historical Orders" to its own new worksheet beginning at cell A2. The new worksheet can have sheet1/2/3/etc. as a name that does not matter. This process will be repeated every few...

I need help with a VBA to copy a row of #'s from one worksheet to another. It will be a daily process so I will need the new row to go below the day prior if that makes sense.

Hi everyone, I'm trying to modify the VBA found: https://www.rondebruin.nl/win/s4/win001.htm to delete rows based on the cells length instead of the cells content. The website's example deletes rows that contain "ron" and the VBA works as expected. I would to like to modify so that it deletes...

Good Afternoon, I have a spreadsheet with names in column b (Lastname, Firstname or Lastname, Firstname Middlename or Lastname, generational suffix Firstname or Lastname, Firstname MiddleInitial ) I am needing to create a VBA code to rearrange the names and remove everything except for...

I have three different macros that make various format adjustments. 1) intacct_CMA 2) intacct_events 3) Intacct I'm trying to consolidate the three macros into one by using a Select Case Statement based on the Worksheet names. I would like for: - macro #1 to run on the worksheet named...

Hello everyone, I am trying to create an IF statement using VBA to format the cells in a row (columns A:H) if certain text is found in column A. The workbook contains account names in Column A. If the name in Column A = "Total Operating Income", "Total Expense", "Total Non-Operating Income"...

I am currently having to manually count how many times a number appears in a single column ranging from 25-50 rows long. I need a VBA code that allows me to take the numbers in the pasted column and not only count them but apply a value to them. For Example: Pasted on sheet 1 Column A: 111...

Hello everyone. I'm trying to create a macro that will insert a new tab called "SheetList" at the beginning of my workbook. This tab has "Table of Contents" in cell A4. I would like for the sheet names to be listed starting in cell B5 and continuing down until all sheets are listed. Beside the...

Hi There I have in a folder 30 excel files (Each file have same tab names) What I need a vba which will Go to the folder Open each file Go to specific tab (Assuming data tab) Apply filter in data tab based on some name mentioned in other tab (Criteria Tab cell value B6) it will be same...

I have some VBA that has worked in the past without a problem but will not run anymore. The VBA deletes all the sheets in a workbook that are not listed. If searched the forums and there are several posts that suggest replacing "Sheets" with "Worksheets", but this did not work for me. The error...

I'm not very familiar with the VBA part of Excel, more familiar with the normal in-cell formulas. I apologize in advance for technical errors. I'm working on organizing a bunch of data from a few sheets onto one separate sheet (same workbook). I have "Tag Value Names" and "Tag Values", such as...

Need help with vba code that should merge multiple workbooks into one workbook from a folder that the user chooses, but it should only merge the 1st sheet of each workbook. I found this code only it does half of what I need but I'm clueless about the rest. Scheme for macro working: 1st - Ask...