vba & macros

Can someone please point me in the right direction. I have dozens of workbooks in a local folder where I need to import a specific worksheet "General Ledger" into the current workbook. The code I wrote does open the workbooks but seems to break when it gets to "total" even though when checking...

For example, if in the range of A:A cell A8 change then copy D4:I4 and paste it as value in another sheet named as "ADP" at the same place i.e. D4:I4 For that I have tried the following macro which requires some modifications, please suggest the same. any help greatly appriciated. thank you...

Good Evening, I have been searching for some time now for examples online and similar post for what I need with no success. I am here now to ask for assistance. I need a VBA code that will be run by a command button to copy a specific range of cells in a specific row and paste the cells to a...

Hai Dudes, I would like to select the range of cells in one row which contains some merged cells in between. The macro has to be run for many files with different range of cells. For example File1 has to be select from C5:C10, file2 has to select from C5:C20. There are some cells merged in the...

I've been mainly working off this code: https://www.mrexcel.com/forum/general-excel-discussion-other-questions/616616-extract-specific-data-folder-eml-files.html as both the folder of eml files and the output are what I want (except I will have more columns). The problem is my EML data looks...

I have 2 worksheets in a workbook, both have 2 columns as shown in Images below Sheet 1 : <tbody> FLOC COMP ABC-123 C1 ABC.124 C1 ABC.125 C2 ABC.126 C2 ABC.127 C3 ABC.128 C4 </tbody> Sheet 2 : <tbody> Comp MAT C1 A1 C1 A2 C1 A3 C2 A4 C2 A5 C3 A6 C4 A7 </tbody> I...

Hello, I am looking to take two columns of data (A – Name, B –Number) that are around 130 rows each and split them into four even columnseach. (Ex: A,B A,B A,B A,B).I’ve looked around and found some VBA scripts that can split a single columninto many columns, but am unsure about how to do...

Good day friends, I have a macro which selects a folder and then makes a Dir list and counts the number of pages in the pdf. I am needing to replace the folder picker portion of the code with the static path of a folder. (This would prevent me from having to select the same folder every time)...

Hello, a real novice here so excuse the probably simple question but I cannot locate an answer. I have a master workbook which contains lots of file paths to other workbooks. These locations change every month so to get around it I have a sheet which automatically updates the file paths each...

I normally use a basic code that looks into a secondary workbook and scrolls through all that tabs for me (example scroll below). However, what I just realized was that I'm always running this against other macro enabled files. And earlier when I tried it against an ".xlsx" file, it would not...

Hello, everyone. Sorry IF my question is in the wrong section. Today I would like to KNOW about PROBLEM SOLVING personal (!!crafting-way!!) techniques, some kind of notation may be, PLEASE I would like to hear from you, how you guys resolve problems, or something like code interview. In my side...

Hello all I am having trouble with a code to let the user set a path in VBA Right now I have Dim filePathRop_Gamma As Variant filePathRop_Gamma = ThisWorkbook.Worksheets("Setup Tab").Range("K4").Value 'user supplied path 'code to open the file Workbooks.OpenText Filename:=filePathRop_Gamma...

Basically I'm just trying to convert a date and time to a different time zone. Here is my code: dateString = Left(startcell.Offset(i, 0).Value, 10) & " " & Mid(startcell.Offset(i, 0).Value, 12, 5) dateofPeak = DateAdd("h", -7, DateTime.DateValue(dateString)) The dateString input is "2018-06-02...

Hi, I am trying to ignore the blank cell whenever the marco finds it. I need is the output workbook to be copied a blank cell if the Input workbook has one. Instead of this, I am getting the output of values from the input that is in the subsequent cell and everything moves upwards...

Excel macro code for below requirement I have a sheet "Daily Report" which contains 3 Pivot tables for 3 different staff. the pivot table is populated based on the vlookup of the data from various other sheets Engineer 1 Column C - Date of the activity Column D - Name of the staff Column E -...

I have an issue that I don't know how to easily resolve. I need to convert the following line of text. Column 'C1' would typically be this (but will be multiple lengths); Case Is = "400000","400100","400200","400300","400400","400500","400700","400900" Column 'D2' would say 'Revenue' What I...

Hello, Below is the code that I am currently using to copy all the rows on each of the specified worksheets based upon a single criteria (Column N="Y"). The Marco then pastes these rows as values on Sheet 4. This code functions properly however, it is extremely slow. The verison of Excel that I...

I have been working on a project with thousands of rows of multiple choice questions. I was basically creating an answer key by identifying which choice was in red font/text. However when I ran a macro to work through all of the rows outputting the font color values into some temporary columns...

hello I have a spreadsheet with various columns/rows of data. what I am trying to do is if a cell in column A has a string of less than 4 characters (this could be either alphanumerical or symbol) I need to cut & paste the values from columns G,D,E & F only to a new worksheet (in the same...

I'm starting to learn VBA. I've got a list of tasks that are due on various days. They are divided and organized by different departments. What I need to do is scan through the whole range of dates and then automatically send an email with the tasks that are due today. I found some VBA...