Create table that returns recent date for multiple rows of matching data; except dat

The code only works for the original data set I sent. I tried using the code for both a smaller and larger data set and it only returns the results for...

Create table that returns recent date for multiple rows of matching data; except dat

The code works. Thank you. Two more questions:

1. Would the code change depending on how many rows there are?
2. What if two more columns of data

Create a new Sheet on Each Row

DUPLICATE THREAD CLOSED _ONE THREAD ONLY IS ALLOWED PER ISSUE HERE

Continue in the first thread here: https://www.excelguru.ca/forums/show...et-on-Each-Row...

Create a new Sheet on Each Row

Hi All,

Can anyone please help me out in this scenario? I am trying to add a sheet on each and every row, and as soon as any column update...

Create table that returns recent date for multiple rows of matching data; except dat

This code should do it for you

Public Sub LatestData()
Dim wsthis As Worksheet
Dim wsres As Worksheet
Dim lastrow As Long