Hi,
I need to create a nested loop involving a find, copy and paste but don't know how to. There are two sheets, ws and ws2. In ws, where acad_year is a certain value, the first loop goes through the list looking for pop_fin (the unique id of the record) and matching it up in ws2. However...
Hello,
I'm trying to develop a vba code to use excel as a search engine. I have created a cell which bears the input(in sheet(2)). I want excel to search for the input(which lies in the first column of Sheet(1)) , once it's found, take every column corresponding to the result and search for it...
I have created a series of workbook that each have several power query queries in them drawing data from other workbooks. The queries have been setup to use a parameter (a persons name) which is provided in a cell of a worksheet that will be hidden and then passport protected. I am trying to...
Sub Move3Mo()
Dim CL As Range
Dim RNG As Range
Dim WS As Worksheet
Application.ScreenUpdating = False
For Each WS in ThisWorkBook.Worksheets
Set RNG = Range("c9:C200")
For Each CL In RNG
If CL.HasFormula = True Then
CL.Offset(, 3) = CL.Value
ElseIf IsNumeric(CL) = True Then...
I have a macro that will run through a computation given two inputs on the main tab. I'd like make a matrix in a new tab with all of variable A entries across the top row and the variable B entries down the side column. I'm trying to make nested For loops to run the macro through all the...
Hello All,
I'm working on a problem where I'm iterating through possible combinations of components, I have a sheet that has in Col(F) the Min, Col(G) the Max, and Col(H) the steps; similar to how a For Min to Max step Steps function would work.
I've recorded all of these values by
Dim...
I'm working within a nested FOR loop. If you notice when I'm Assigning "ECD" I'm trying to average the cells from J (which is row 1) and column 11 to column 12. It keeps on telling me "Application-Defined or object-defined error". Any help would be appreciated.
Thanks,
Sub copytab()
Dim...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.