Seach All Worksheets for Value >= User Input

Hello All,

Im trying to develop an excel workbook that I can use as a template for PDF's I convert to .xls files in order to search for data and manipulate it.

I've tried messing with VB and I cant seem to get it right. Can anyone help me figure out how to accept user input for a value as well as accept a column letter and then have a macro seach all worksheets in the workbook for any value >= to the input...Then copy and paste it to the first sheet?

IF anyone has any code readily available, or help..I would greatly appreciate it.

I can currently search 1 sheet and cut and paste the exact value of the input but thats it. The code is below.

Thanks


Option Explicit

Const rtDataSheet As String = "Sheet1" 'Change to actual data sheet tab name
Const rtResultSheet As String = "Sheet8" 'Change to actual result sheet tab name

Dim ColName As String
Dim SearchStr

Please Login or Register  to view this content.

Hello Chazm,

Welcome to the Forum!

The title of your post is important. The more descriptive your title is about your problem, the more likely you are to receive a fast response. It will help you get your question answered quickly and correctly as well as help other members and guests to find answers to the same or similar problem.

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

As a member, You have agreed to follow the forum posting rules. Please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules

Hello Chazm,

Your post will be locked until you contact me or another moderator and agree to follow the forum's rules.

Note: Post unlocked after OP contacted me by PM.