Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have two worksheets, one holds data horizontally for course codes, vertivcally for peoples names, the cells have a y or N to indicate if the course is requred, the second sheet holds the same data drawn from a database with the addition of a date (i.e if the peson has attended the course) This first sheet is regularly refreshed. I would like to be able to take the date from the first sheet and find the same person and code on the second sheet and replace if a y is present with the date, if the y is not present then replace with the date and change the cell colour. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tidy up multiple find and replace code | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Find and Replace code in Sheet modules | Excel Programming | |||
Code to mimic vlookup | Excel Programming | |||
[URGENT]How to mimic the toolbar zoom button from code | Excel Programming |