vba & macros

Hello! I am trying to write a VBA macro which would sort the worksheets according to the names. For example, sheets containing the word "Termed" should be placed at the end. I have included an example. In the example, "b-termed" worksheet should be placed at the end. I don't have a lot of...

Hi all! I have been trying to write VBA macro to simulate the keystroke (Ctrl + Alt + v + f) to copy and paste formula from an excel cell. I'm a beginner, and so far I've been able to develop the functionality of copying the formula and pasting it relationally. However, the code breaks if it is...

Hello! I have a worksheet that fetches data from a site. (Sheet 1) Now I have used indirect references with a helper sheet (Sheet 2) to fetch the relevant data to a new sheet (Sheet 3). In Sheet 3 I have two columns- Column A - Data Set 1 (Unique IDs) Column B - Data Set 2 (It is time which...

I am running a macro in excel and i am having trouble with this error popping up and highlighting the Year(DATE) formula in my vba. i have searched and searched and have found things on how to replace the referrences but i dont know what reference to use to solve this issue. my program runs...

Hello everyone, my boss has me working on a spreadsheet that pulls information from various tabs into 1 "Summary" tab. We then VBA code to put the information into a table (removing any blank rows in the process) and transfer to a word template called "Proposal" located in the same folder as the...

Hi Guys, I'm using below codes to remove password and save excel files without password. Can you help me modify the codes so I can use this for word files? =================== Sub RemovePassword() Dim xlBook As Workbook Dim strFilename As String Const fPath As String = "C:\My Folder"...

Hi Guys, I'm trying to open and save the files without password using below codes. However after running the codes, I tried opening one file and the password is still there. Is there any way to: 1) After inputting the password, save the files without password 2) Can you help me modify below...

Hi All, Hope everyone is well, I require help with the following, I have a sheet called data, which contains data exported from a piece of equipment. I would like to breakdown this sheet into multiple sheets. I require to create a copy of sheet '1', copy A15;E46 from 'Data', paste this into...

Hi, please help me figure out how to code copying all of current rows of filtered data and paste into another sheet in VBA Thank you

Hi I have a formula that runs in column K of a sheet that pulls a value from a pivot table. This is compared to a value that will be entered in column A. The data in the pivot table that column K pulls from changes regularly but I want to be able to enter a value into column A and when entered...

Hello Everyone, I am not very in detail with macro VBA coding, I have compiled the following code. My project is set on a flat file, vertical format across range (A:D) there is only 4 columns with data. Titled "Bank, Year, Month, Total". Due to the months of the year, below "Year" column I see...

Using VBA, I am trying to convert text files into excel workbooks, open them, and then call a macro on another module (Call DataCleanBehfMRI). Then do the same thing, looping through text files in other subfolders. Folder structure: V:\Behavioral\Twin_behaviorTry\19510196-1\WorkingMemory.txt...

Dear All, I run the following code script, then I get an error: "Variable not Defined. What could be the issue, is there an explanation to what is the correct variable not set in the script code? [CODE:] Sub ListSheetNamesInNewWorkbook() Dim wb As Workbook: Set wb = ThisWorkbook...

Hi everyone, The code I have does what I would like it to do, however, I would like to change how it selects the data. Right now, it copys and paste data based on the location of the cells. Now, I would like to copy and paste the data based on the headers in row 8 of "Activity Tracker -...

Hi. I need to read a file, based on latest date. Using VBA. I really don't know how to do since before this I only put exact name of the filename. I know how to do it using vb.net, I do like this, Dim stamp As String = DateTime.Now.ToString("yyyyMMdd"...

I want my personal macro workbook to reside, or be synchronized to, a location within SharePoint. I have searched off and on over the past 2 years and cannot find a decent response. My hopes are to store all VBA code in the Personal wb, but have that same code in my other pc's if not...

I have a workbook with 40 sheets, I have created query that should provide a Table of Content. What I need is the query to provide the page in sequence with the next TAB providing the next PAGE number, "not the total amount of pages". In other words, if my Executive summary has 3 pages in...

Simple question, I hope. I need to be able to check a textbox to see if the data pasted to it is numeric. I know to use the isnumeric function, I just can't figure out which event to put it under. I don't need much help, just help in figuring out how to check the box if someone does a CTL + v...

Hi to all I am learning VBA and I need you help: I am trying to copy the information from Data Tab to Table tab, but I need to put all the rows for the material in only one row (like transpose). Just only with one condition: the data with information "Not short" in column L is not considered...

Hi, I am trying to change the format of this table (un-pivot)- <tbody> A1 A1 A1 A2 A2 A2 YEAR Floorset Target Instore Newness Target Instore Newness FY20 100 89 25 200 193 55 </tbody> To look like this- <tbody> Business YEAR Floorset Target Instore Newness A1 FY20 100 89 25...