Help with complicated macro

mewalker0

New Member
Joined
Jan 24, 2005
Messages
22
Looking to write a macro that will look at the cells above the active cell within a column which has dates in it and IF the date is less than the date in current cell it would look at the numbers in a different column and see if there is a duplicate number. If there is one it would high light the number cell. Any ideas? Or is there a better way to do this?
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Possibly Conditional Formatting?

Can you post an example of what you're dealing with? (Look at the bottom of the page for the link to Colo's HTML Maker, which will let you do that).

Smitty
 
Upvote 0
Book1
ABCDEFGHI
1
2TODAY1/29/2005
3
4NAMENUMBERDATE
5
6AAA3211/7/2005
7BBB1231/8/2005
8COCA2341/9/2005
9AAA4561/10/2005
10BBB1231/11/2005
11COCA3211/12/2005
12AAA5671/13/2005
13BBB3211/14/2005
14COCA3211/15/2005
15AAA3211/16/2005__----IF_C15_IS_EQUAL_TO_F2_IF_TRUE
16THAN_CHECK_AND_SEE_IF_B15_HAS_BEEN
17USED_BEFORE_AND_IF_SO_SHOW_"USED"_IN_D15
18
19
Sheet1
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,184
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top