How to select specific data from workbook based on value

[JamesCage]

HI Everyone,

I need to select the past 12 months of data from the H column in a workbook. A new row of data gets added every month. I need code that recognizes the most recent input and also selects the first 11 cells above containing data.

Thanks for any help

 

[VoG]

Maybe like this

Sub test()
Dim LR As Long
LR = Range("H" & Rows.Count).End(xlUp).Row
Range("H" & LR).Offset(-11).Resize(12).Select
End Sub

 

[Smitty]

Welcome to the Board!

A pivot table comes to mind.

What do you need to do once you've selected those rows?

It'll help if you post a shot of your sheet (see the HTML Maker link in my sig for how).