I've been working on a time-sheet file to log-in / log-out of projects we work on each day.
PROBLEM! The file opens very slowly
File Size: 661 KB
Opening time: 28 seconds
QUESTION: Is there a fix or should I start over?
Thanks!
Trying to create a timesheet to track hours on projects.
I'd like to be able to have VBA code that will copy cell A1 (which has =now() in it) and then find the last row of column "D" and paste the value without formatting.
Can this be done?
I've attached my file for reference.
Thanks,
sC.tt
I'm trying to automate my sheet numbers at the beginning of a project. Sometimes the building is so big we have to break it up into several sheets. For example, a project may need 3 sheets to display all of one floor. The sheet numbers for the 1st floor would be:
M101A
M101B
M101C
The second...
Working to create a drop-down to dynamically change the selectable data set.
QUESTION 1: (In the attached file) if "GOTHAM (ICO)" is selected, how can the Wattage drop-down be populated with the correct data?
QUESTION 2: (In the attached file) if a new row is added to the "Wattage" data set...
I have a range of cells named “Projects” which is being used for a Data Validation list. Because the named range includes a ton of cells, there are a ton of blanks in the drop down list.
QUESTION 1: Is there a way to remove blanks so drop down list is short & clean?
QUESTION 2: Can the list...
Is there a way to create a dynamic list of named tables, so that when a new table is added it would appear in a "Named Tables" list? Kind of like pressing "F5" and seeing all the Table names but in a list that can be used in a data validation.
I'm a plumbing designer & I'm working on a calculator to size roof drains. The challenge I'm up against is grouping different roof areas together to see what size pipe would have to be routed though the building.
Here's what I have:
Range: B10:B24 has "Drain ID" numerically sequenced 1,2,3,4...
I can't seem to figure out a clean way to calculate time. I’d like a way to have excel display what time I can go home! For example currently this week, I’ve worked 35:58 out of 40 hours. The current time is 8:41 am. Can anyone help me write something that will calculate this?
Thanks!
I recently downloaded the 2013 calendar from Chandoo's site. I love it!
I’m wondering if someone could help me make a multiple (4) year calendar?
sC.tt
The lookup_value I'm looking for is 38 in col. "A"
Excel returns 2-1/2" since the number 32 is the closest to 38...but I need it to return 3". How do I write a VLookup to look for the number equal to or less than in the array?
A B
1 1-1/4"
3 1-1/2"
16 2"
32 2-1/2"
48 3"
I have two numbers that have numbers associated with them (see example below). I'm trying to solve for a number in between these two numbers.
200 0.28
232 ????
250 0.43
I'd like to be able to type in any number between 200 - 250 and get an interpolated number...hopefully somewhere...