Hello there,
I've got two databases in Ms Excel 2000.
The first (Sheet 1) contains; Name-Workdate-Hours
The Second (Sheet 2) Contains; Name-Hourly Rate Period 1-Hourly Rate Period
2-Hourly Rate Period 3
As I tried to match those using a single formula; I stumbled upon some
difficulties. Thus I decided to look for a way to make a macro pick the
needed formula.
As Sheet 1 is filled with information; in collumn 'S' I want to fill in the
Formula from Sheets(Sheet3).Range("S1") if the Date in Collumn 'E' is in
Period 1; Sheets(Sheet3).Range("S2") if the Date in Collumn 'E' is in Period
2, etc...
Does anyone have clue how I can make this work? Thanks in advance!
Bookmarks