find record latest one

VBABEGINER

Well-known Member
Joined
Jun 15, 2011
Messages
1,128
Hi All,

I have assign x = TxtProjectID.value (text box)

x value are in another workbook called "Timesheet Data" in Col E, with same directory.

x = numeric data.

I have multiple rows in "Timesheet Data". this x value information may exist multiple of times.

What I'm trying to do...

The moment i will paste x value in TxtProjectID.value (in text box), it will find in "Timesheet Data", Sheet2.

from below to up (for latest row record). The moment it will find latest entry..all the corresponding value's are paste in text boxes (which i will mention)

Can any one please help on this, find and paste code..
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

VBABEGINER

Well-known Member
Joined
Jun 15, 2011
Messages
1,128
Code:
[TABLE="width: 620"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Project ID[/TD]
[TD]Activity Type[/TD]
[TD]Project Name[/TD]
[TD]Task Name[/TD]
[TD]Task ID[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]New Case[/TD]
[TD]Admin_All Other FF[/TD]
[TD]Reporting[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]8899[/TD]
[TD]New Case[/TD]
[TD]Admin_Project[/TD]
[TD]Billing[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]New Case[/TD]
[TD]Admin_All Other FF[/TD]
[TD]Reporting[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]New Case[/TD]
[TD]Admin_All Other FF[/TD]
[TD]Reporting[/TD]
[TD]14[/TD]
[/TR]
</tbody>[/TABLE]
I want to find 123 but latest one..i.e. Task id 14, How do i achieve this in code..
 

Watch MrExcel Video

Forum statistics

Threads
1,098,863
Messages
5,465,132
Members
406,415
Latest member
silungwewilliam

This Week's Hot Topics

Top