Macro to delete rows based on a value using user input box

Hi all!

*EDIT - Forgot to mention that the times/values will be in decimals...not sure if that is relevant, but thought to add in!*

I am looking for a macro that will help me with this scenario.

So I have a bunch of data that looks like this (I know the values look weird, please bear with me):

Time Rate Force
10 0.032 -10.55818
20 0.065 -10.53982
30 0.100 -10.53187
40 0.132 -10.55818
50 0.200 -10.53982
60 0.299 -10.53187
70 0.332 -10.55818

I want to delete some of the data rows from the table/file that I do not need. I want to create a macro that will pop up with a user input box, and I want to look at column A and decide from what time onwards is the data that I want to keep, and the macro will delete rows before that time.

to make it simpler:

> look at column A
> see from which value I want to keep data
> e.g. choose 50s
> input 50 into input box
> macro will delete the rows prior to 50s.

Does this make sense? and is this doable? I tried to do it myself from scratch, but my vba knowledge is poor and I am mainly googling. I have a sample of something I have been trying to work on but a bit confusedif I am going the correct way.

Please Login or Register  to view this content.

Thank you!!!!!

Very easily done

Select any row and then run this macro

You have a choice. Either enter a Value or simply click OK to delete the rows before the active cell.

Please Login or Register  to view this content.

Thanks! :D the code worked!

Quick question, is there a way to just delete the values rather than the rows itself? I have my layout set out in such a way that it contains graphs and titles on the data, when I run this code, it will remove them both. For reference, I will attach an example spreadsheet.

Thanks again!