PDA

View Full Version : ok



Shaun
01-13-2009, 09:06 AM
Ok where do i start I have 3 sheets Front sheet,Timesheet,datasheet

Frontsheet is as depicted with one exception a list of all employees
When an employee fills in timesheet and records the completed sheet to the data sheet (executing a macro) the persons name dissappears from the front sheet.


Timesheet
it has Name,Month,Year
and then times worked (start finish etc)

I have created a datasheet records all the data

ok my problem
Some staff have decided that they would like to fill in the timesheet on a daily basis thus saving the data to the datasheet daily. This causes me a problem as my exsisting macro creates a new line (A2 on the datasheet) then copies all data from timesheet across.

As they will only fill this data in daily i need to be able to do a lookup on the columc A,bc on datasheet (name month year) information originating from Timesheet same fields.
On finding the person
i then need to look for the next blank cell in the same row and write the relevant data to that cell.

eg from timesheet

fred blogs jan 2009

1 07:30
2

this being written to datasheet

A month yr 1 2
Fred Blogs jan 2009 07:30


next time round

Timesheet
fred blogs jan 2009

1
2 07:30

thus search and find

Fred Blogs Jan 2009 07:30 write next here

regards