Hi
sample files attached
on workbook "SAMPLE-DATE"
First i'll input the start date on "G1" then the end date on "H1"
Then input the code in "I1" based on column E
From here it will search all the code on column A based on "I1"
If same code, check the date on column B if its in the dates of "G1" and "H1"
Then it will copy the date on column B and time on column C to another workbook "SAMPLE-TEMPLATE"
Including the corresponding name on column F
On workbook "SAMPLE-TEMPLATE" will always start on "A12"
First the name then on the next rows the dates
Times with the same dates will be arranged on the same row
(as in the sample-template workbook, dates may have several data time on it - maximum is 4)
Then on the same row of the date on column G will be shown the time difference as decimal number
(I have a formula to get the decimal difference but don’t know how to automate)
column G
if the date is on a weekday compute time difference between "F11" and latest time on row
if the date is on a saturday compute time difference between "G11" and latest time on row
if the date is on a sunday compute time difference between "H11" and latest time on row
on workbook "SAMPLE-DATE"
if I want to retrieve another name and corresponding dates
I'll just have to change the value in "I1"
and change the dates in "G1" and "H1" if needed
and it'll just add to the next rows on workbook "SAMPLE-TEMPLATE"
would it be possible for the macro to run after I typed the code on "I1" and press enter?
also if possible before I retrieve dates-times how do I delete a row or several rows
on column A-B-C based on a date range on workbook "SAMPLE-DATE"
lets say I input start-end date on "G3" and "H3"
all the dates(row A-B-C only) from "G3" to "H3" will be deleted
as a separate macro
Thanks,
Bookmarks