I'm having a lot of trouble on this one. I need to create a form that will auto populate a back page. So, when I hit enter on the form, that date on the other worksheet will fill from the form. I've uploaded the workbook. Sheet 1 is what the report should contain. Statistics Spreadsheet is where I would like it to be auto populated to. Any help is great help thanks!
I'll take a look at it
I have some questions...
- You want a dropbox for a date, what dates must it contain?
- Where must the data for the mission description be stored?
- You want a dropbox for the teamleaders, where can I find them?
- Idem for the teammembers
- Do you want the form to be on sheet 1, or may it be a userform that opens when you open the workbook or by selecting sheet 1?
Last edited by Cheetahke; 10-10-2015 at 07:39 AM.
1. The regular date so the statistics spreadsheet knows where to put the number in as far as month
2. I'm not sure, I suppose a separate spreadsheet
3. Team Leaders A, B, C....U
4. 24 Team members named 1, 2, 3, 4 etc
5. Userform
Thank you
If you mean by regular date the date of today, you don't need a dropbox for it.Originally Posted by financeintern01
These won't be a problem2. I'm not sure, I suppose a separate spreadsheet
3. Team Leaders A, B, C....U
4. 24 Team members named 1, 2, 3, 4 etc
5. Userform
Greetings,
Cheetahke
Hi,
I have other questions...
- What do you mean exactly by "the regular date"? As far as I can see on the example, you only works with the months of a year.
- The "Mission start" and "Mission end" boxes, must that be date and time value?
- The "Mission hours" box, must that be calculated by the entered values in the "Mission start" and "Mission end" boxes?
1. For example 2/2/15, but will only put in in the month box. If it is easier to only put month/year that is fine
2. Mission start and Mission end are times
3. Yes
Yes all good
Another question about the date, how many dates you want to appear in the dropbox?
If you want to enter the date yourself for manipulating the data, it's better to use a textbox instead.
If it's the date of today that must be entered automaticly, it's allso better to use a textbox instead.
I just need it so when you select the date, after you hit enter it will populate the date in accordance with that on the statistics spreadsheet. So which ever is easier.
Hi,
Here's an update of the file I've been working on. I's not ready yet, you still can't save anything.
Some other questions popped up.
How will the start time and end time be entered? With hours, minutes and seconds? Or only hours and minutes? Or some other value?
Same for Total Man Hours and Actual Fight Time. With hours, minutes and seconds? Or only hours and minutes? Or some other value?
Just hours for both. For example, 54 hours
For start time and end time too? I thought for them like 08:00 h as start time and 12:00 h as end time, so the mission hours could be calculated as 12:00 - 08:00 = 4
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks