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
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