VBA macro that can find predetermined values within huge data set

[mrsak87]

Hi all,

I have a large amount of data on a spreadsheet - 40,000 rows. I'm trying to get a macro which will find a range within this huge data set. So on sheet1 I have the two values below and a button for the macro next to it. The two values below are in H3 and H4

X-correlation range seconds (lower) 1.2000
X-correlation range seconds (upper) 1.2050

a snippet of Sheet2 is shown below. I want the macro to:
1)be able to find "1.2"
2) select from "1.2" down to "1.2050"
3)then select 6 columns across.

Thankyou


1.1975 -2.69E-03 4.23E-05 -3.11E-03 -1.80E-03 3.72E-04 9.85E-04
1.1983 -2.84E-03 -1.69E-04 -3.26E-03 -1.78E-03 5.28E-05 8.04E-04
1.1992 -2.99E-03 -5.79E-04 -3.13E-03 -2.03E-03 -2.00E-04 6.32E-04
1.2000 -3.13E-03 -1.06E-03 -2.70E-03 -2.41E-03 -4.49E-04 3.82E-04
1.2008 -3.09E-03 -1.46E-03 -1.96E-03 -2.75E-03 -6.65E-04 1.12E-04
1.2017 -2.82E-03 -1.71E-03 -1.04E-03 -2.92E-03 -7.96E-04 -1.15E-04
1.2025 -2.43E-03 -1.87E-03 -1.10E-04 -2.95E-03 -8.95E-04 -3.20E-04
1.2033 -2.29E-03 -2.06E-03 4.78E-04 -2.91E-03 -1.19E-03 -6.17E-04
1.2042 -2.21E-03 -2.13E-03 8.23E-04 -2.48E-03 -1.29E-03 -7.96E-04
1.2050 -1.99E-03 -2.06E-03 8.96E-04 -1.76E-03 -1.32E-03 -8.91E-04
1.2058 -1.15E-03 -1.82E-03 1.10E-03 -7.21E-04 -1.20E-03 -8.82E-04
1.2067 2.42E-04 -1.59E-03 1.62E-03 2.07E-04 -1.28E-03 -1.02E-03

[JOHN H. DAVIS]

Does your snippet represent one Column?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[mrsak87]

Works perfectly! I just need to add a bit of code to select the relevant sheets.

Nice one!!

[JOHN H. DAVIS]

What are the relevant sheets?

[JOHN H. DAVIS]

Maybe like this?

Please Login or Register  to view this content.