I have several workbook(.xlsx) that have only 1 sheet per workbook. I would like to loop through all the workbooks in the folder one by one and find certain cells with specific keywords and
copy the cell adjacent to it. Next, copy all the cells and paste it in a master file into its respective...
Hello, this is my first post in this forum. I am currently doing a mini attendance sheet for number of employees. I have two different sheets, "A" and "B".
In sheet B, there are a list of employees with each of them have 4 values (date).
In Sheet A, there are column of days of a month. I would...
My objective: Delete specific range based on duplicates in a specific column , and shift cells up.
I have a large spreadsheet with evenly separated data. I have an example attached of the outcome I want, but I would like to have it in a loop, where the script counts the columns and...
Hello everyone. Awesome forum! Hope everyone is having a wonderful Thursday. I was wondering if any of you could help me with this problem I have been having in excel. I am creating a filter function based off of raw data to give me data from that raw data given two date constraints and two...
I’m trying to delete a picture within a certain number of highlighted cells. I’m trying to do this in VBA and every suggested code I’ve tried doesn’t work or requires specific cells to be selected however I’m highlighting the cells via ActiveCell.Offset codes.
The sort of thing I’m after...
Sorry but I'm back again.... I hope everyone is well and good...
anyway I have 2 Sheet (Dummy and Updated) from Sheet Dummy my code would supposedly insert my Sum and CountIfs formula in the designated cell in my Sheet Updated, although it runs but the problem is the total value does not...
I am very new to coding in VBA and am trying to figure out how to make my code run automatically. I want to copy paste values from one cell to another, but nothing happens with my current code, any idea why?
Here below is the code to create a draft email from excel, the current region is correctly selected but it doesn't show in email body correctly, it only shows a word "True", please see attached 2 pics.
Please help as I have googled for days and cannot sort out the problem, thank you so much...
Hi am new to VBA, Could you please help on the below code.
I have 2 workbooks and i want to copy the columns from one to another with the matching header.
It shows an error in the following line as (Runtime Error - 1004 --> Application-defined or object Defined error)...
What the sheet must do.
In column B the number of eggs laid is counted. Once 4+ eggs are laid then the number of days is counted down from 24 in column E.
Should there be a hatchling then the formula should reset for the next 4+ and the count down started over.
I have the first...
I was trying to make a VBA code that would compare a list on a page "Locations", and go through all of the other sheets comparing a column in these sheets to see if there is a match or not. If there was no match, ignoring blanks, the VBA code would go to the cells where the match...
I'm very new to using VBA. I keep receiving a run-time error when I try to get the address of the cell.
SuperRange = Range("D3:D4")
For Each cell In SuperRange
If cell Like "*.*" Then
I have the definition of several ranges of straight lines: 1, 2, 3, 4 and 5, where I define the x- and the y- coordinates only for the start and end points of the lines. I would like to have a "Desired" range that sums the values in every coordinate of the range. I would like to do this...
so I have the sheet as seen in the attachment (I have included a picture)
I have 2 columns, A for machines, B for products. I want to highlight those products that are created from both machines , so something like if duplicate and column A in the range of the duplicates contains...
I have a VBA script error out with "Type mismatch" on the Application.WorksheetFunction MInverse line. How else am I suppose to calculate a matrix inverse? What is the type mismatch? Both arrays are the same size and the matrix defined is invertible.
Option Base 1
I'm looking to edit this script such that if there is no value under the first row and then don't copy it. So only copy the cells with values inside
How do I enter sequential numbers based on cell value start with D9 and end with D7 (30 years term) and I would like to calculate in range Q3:V14.
If I change D7 value to 10 years, in range Q3:V14 should count only 10 years and stop. See my attached XL2BB file.
Thank you so much for your help...
I have a spreadsheet where the columns changed at times (more are added or some are deleted). It's too much work to edit the ranges in all my macros every time. Is there a way for the VBA to figure out what column Q certain header is in and adjust the letters in the range accordingly? I...
I'm using set of VBA but does not compute the range properly! what seems to be the problem? i shall implement it in a loop sequence but the second computation is a bit off
Range("A2:M" & LastRow).AutoFilter 1, "=" & "*DAMAGE TO PROPERTY"
I have taken over a project that someone previously developed the macros for. I would prefer it to work regardless of the dataset being used, but the person that developed it used mostly "fixed" ranges and I would prefer that it determines the range based on the data set.
The beginning of the...