Search results

Hi, Is there a way to use Application.Dialogs(xlDialogSaveAs) to save a single sheet into a new workbook?

Hi! It didn't work. Let's say that Jack can have up to 5-7 entries on the same date, in this case 01.05.2013 and then again the same at 02.05.2013 and 03.05.2013 and this will go on 5 days a week for year the 2013, and 2014 and so on. And! I have 10 employees, and they can all have from 1 to...

Hi! I have these columns: A: Date B: start hrs C: end hrs D: Name I have a working formula that check's if there are duplicate start/end hours at a same date (if that's the case the formula returns the value 1 in column E). Now! my problem is that I can't figure out a formula that...

Can anybody help me? I have a database with following columns A = Id B = Date (i'm using Finnish date format = dd.m.yyyy) C = Start time (Finnish time format = hh.mm) D = End time E = Name F = Overlap? Example: Row 1: 2 1.1.2013 08:00 - 12:00 Bob Overlap!(because same...

The problem is that one person can have 1 to 10 entries per day, normally about 5-6 entries. And when the company have 10 emplyoees, and everyone normally have 6 entries per day = 60 entries totally! Not easy to come up with a working formula. For example, lets take a normal MONDAY...

Hi! I have an Excel database with following columns A= Date, B= start (hrs), C= End (hrs), and D= Person (worker). Rows about 1000, sometimes less. I have a inputsheet where I write data (date, time, and worker). The data will be stored on another sheet. I use this VBA-formula...