Posts by yegarboy

What about using the Sendkeys command?

SendKeys.Send("{DELETE}")

Hello Ladies and Gentlemen,

How can I identify duplicates in 16 rows and assign a number based on its position? Example Workbook attached. But here is a sample of the issue and desired result

Current

Points Team Score
16 A 100
15 B 100
14 C 90

Desired

Points Team Score
15.5 A 100
15.5 B 100
14 C 90

A macro is needed as there are 20 groups of 16 data sets. Only the Points row needs modified. Thank you!

Greetings Gents,

I'm looking for a way to rank a named range from 1 to 16 with VBA. 16 being top position and 1 being bottom. Now for the tricky part, I need a way to allot for ties "duplicates" in a manner such as this:

Points Name Score
16 Bill 100
14.5 Tom 90
14.5 Mark 90
13 Ryan 80

Notice how 15 and 14 is replaced with (2) 14.5s

Please see my attached workbook example. And thank you for any help with this matter. [ATTACH]n1218161[/ATTACH]

Your very welcome

I linked the Macro to the Save button. Add a few Approved and Rejected cells in Column L and click Save. I hope this works for you. [ATTACH]n1213970[/ATTACH]

Looking now.

Could you give an example of your request? Its a little unclear as to what you want.

Can you attach a sample workbook please? Also, how would you like the Macro to be triggered?

Re: Hide Columns based on Date

Adding...

Application.ScreenUpdating = False
Application.Calculation = xlcalculationmanual

To the top of your code and...

Application.ScreenUpdating = True
Application.Calculation = xlcalculationautomatic

To the end of your code will make it run much faster

Re: Search and edit worksheets date by user form

Yes its possible. Something like this?

forum.ozgrid.com/index.php?attachment/72432/

You will see how your code fits in.

Re: Quickly compare two columns of data

Perhaps?

Sub IsTheSame()


Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual


 Dim x As Integer


 x = 0


 For Each C In ActiveSheet.Range("A1:A100").Cells
    C.Interior.Color = xlNone
       If Not C.Value = C.Offset(0, 1).Value Then
       x = x + 1
         C.Interior.Color = vbYellow
       End If
 Next C
 
 MsgBox x & " Rows Are Not The Same, I Have Highlighted Them For You."




Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic


End Sub

Re: Autofill TB in Userform based on input in other TB

Here's an idea. Create a Sheet with the Dates and Date Period like in this example. The Userform populates today's date and searches my Date Sheet for today's Date and returns the assigned Date Period in the Column next to it.

forum.ozgrid.com/index.php?attachment/72428/

I hope this helps point you in the right direction

Re: Send Data To First Blank Cell Of Named Range

Thank you so much. This is just what I needed.

-Cheers!

Re: Send Data To First Blank Cell Of Named Range

Thank you for all of your help Smallman Unfortunately tho a Macro is needed.

Re: Send Data To First Blank Cell Of Named Range

Thanks for the fast response. However I meant to add I needed this in VBA. Sorry about that.

Re: Send Data To First Blank Cell Of Named Range

Here is a sample good sir.

forum.ozgrid.com/index.php?attachment/67054/

Greetings my friends,

Is it possible to send data to the first blank cell of a Named Range and then continue filling down? There will be 3-5 named ranges.

Example:

Named Range "MyRange" has 10 cells. A1 To A10. I need to send data to the first cell "A1" and fill down until "A10" if needed. I am using a search Macro to grab the data..And it works fine except I need to send data to 3 or more Named Ranges on the same sheet.

Example 2:

My Macro looks for a Name in say Column D. If the name is found it looks for a singe letter in the same row Column B. Then it copies that name into a named range and fills it down.

I hope this makes sense to someone

Re: $15 Create Hyperlinks Dynamically From Template sheet To Index Sheet

Payment Sent

Re: $15 Create Hyperlinks Dynamically From Template sheet To Index Sheet

Payment sent

Greetings friends!

I have a silly request I can't hammer out. I have a workbook with a Template Sheet and an Index Sheet. What I desire is when I create a New Sheet from my Template Sheet, It Creates a Hyperlink on the Index Sheet linking to the New Sheet. I have a column that I wish the Hyperlinks to be populated to on the Index Sheet. The hyperlink text should be the Sheet Name of the New Sheet. Please see my enclosed book for further details. forum.ozgrid.com/index.php?attachment/67032/

CTRL+C "Creates a new sheet"
CTRL+H "Renames the Sheet to the Values In F4, F5 and F6" This is also the macro i would like to create the hyperlinks.

Cheers