cellsirow

I have four columns with over 400,000 rows of data labelled (Year, Avg, UIC, Group) that look like (2013, 1.563, 0011, 23). I want to distribute them into 322 separate matrices, one for each Group that have columns labelled by the year: 2013 to 2019 and rows labelled by the UIC from 0001 to...

This is my very first post so please forgive me for anything wrong with this post. I have a workbook with one sheet. Every day, I create a new report and merge the two based off a unique ID in column "AB". This is part of the code: T2 = Worksheets("Sheet1 (2)").Cells(x, 17) 'NHA T3 =...

Hi I have a macro, below, that works just fine but I was wondering if it’s possible to add one condition to it. If someone could just look to see if this is possible I would be very grateful. - The macro searches for any number that is entered in cell B3. - It searches the ranges C3:C20...

I have the following macro Sub AddBlankRows() ' Dim iRow As Integer, iCol As Integer Dim oRng As Range Set oRng = Range("a1") iRow = oRng.Row iCol = oRng.Column Do ' If Cells(iRow + 1, iCol) <> Cells(iRow, iCol) Then Cells(iRow + 1, iCol).EntireRow.Insert shift:=xlDown iRow = iRow +...

Here is the code i found and adapted to my needs and works great. But I want to add an exception, to skip folders starting with ???? and move on to the next folder. Any assistance would be appreciated. So i want: For Each myfile, except. Sub ListMyFiles(MySourcePath, includesubfolders) Set...

I've done some calculations where the output consists of 6 scenarios of 6000 rows of results in 12 separate worksheets. The output for each scenario looks like this, where columns B,C,D would contain values for RMSE, MAE and MASE for scenario 1 and columns G,H,I would contain the values for...

I'm been trying to find out what wrong with my code (In sht.Range....) but I don't see it. Can anyone help me? Thanks so much <code class="western"> ‘</code><code class="western">Move the cell contents to the next cell</code><code class="western"> </code> <code class="western">...

Hi All, Been using this, but need for it to include contents within subfolders, and can't figure out how to do it. Any one suggest the way / provide a steer? Also, is it possible to add a column with details of the last user to save it, or access it? - not sure if that data is held with the...

Hello, I have the following workbook macro that lists all files/folder names from a directory. I would like to exclude all folders from being listed (the only folders that would be in this directory would be .zip folders). Ideally I would not want any folders to be listed in the workbook...

Hi all, I haver the following code that inserts a blank row into the data when the reference changes in column C Is there a way for this to work with ONLY visible data (ie there may be hidden data) Many thanks for any info Sub AddBlankRows() ' Dim iRow As Integer, iCol As Integer Dim oRng...