Search results for query: *

Thanks Skip! That's exactly what I was looking for. I appreciate the help on this! Enkrypted A+

Hello, I've looked through the FAQ's and past threads regarding conditional formatting, but can't seem to get my sheet working properly. I have a spreadsheet where certain cells are listed as =TODAY(). For example, cell A4 is formatted as =TODAY(), cell A5 is formatted as =TODAY()+1, cell A6 is...

That did the trick. Thanks again Skip!! Enkrypted A+

I'm sorry, I guess I don't understand what you mean by adding 1 to the times. Can you elaborate on that a little? Enkrypted A+

Thanks Skip! That worked. I do have one more question, but how would I factor this for someone that works overnight, such as the highlighted portion on the attached file. It should calculate the 10:00PM and 11:00PM for Friday and then the remainder (from 12:00AM to 7:00AM) on Saturday? That was...

Thanks for this info Skip I applied the name range as you mentioned above and put the above code in P2 as mentioned. When it applied that, it's erroring out with a #REF. I'm not sure if I'm missing something or not. I've attached the updated file if you or someone want to look at it. Thank you...

I've attached the Excel file. Sorry about that Enkrypted A+ https://files.engineering.com/getfile.aspx?folder=f1b1253b-5b3c-42b1-849b-f8fecd7e0a57&file=File.xlsx

I have a spreadsheet that I'm trying get a count by hour breakdown on. It contains a list of people and their shift times and days worked: I'm trying to get it to only count those that are working on a particular day (such as Friday). The COUNTIFS code I have works and it calculates the count...

Thanks Skip! I was able to get everything sorted as needed. Much appreciated for your assistance! Enkrypted A+

This is definitely what I'm looking for and it does just as you described, however the problem I'm running into is the results are not staying sequential. When I run the macro with the first line entered as such The results turn out like this However when adding additional lines under the...

No column headers will be ignored. Original data will be pasted on sheet 2 starting on A1 and will be duplicated on sheet 1 starting on A1 as well Enkrypted A+

Gotcha. It needs to have the information duplicated four times as it gets uploaded to a system that will have other applications (4 apps) use it for ID's within each system Enkrypted A+

Sorry, it's been awhile since I've posted. What do you mean by business case? As for the column headers, I don't have any specific header information set yet. Enkrypted A+

Hello, I'm looking for a macro that will automatically add a new row(s) based upon values being presented in a set of columns/rows, when the macro button is clicked after pasting the information in the cell ranges. I have a set amount of columns that data can be pasted into. The range of data...

I know with SendKeys that the use of the % sign will process it as "ALT", but is there any way to get SendKeys to actually process a percent symbol as a percent symbol? I have a SendKeys line that contains a percent symbol in the keys it's trying to send, but it's processing as the ALT button...

Thanks PHV! This works great! Appreciate the help! Enkrypted A+

This works. Thank you! If I want to add the End Date with that, would it be: =[Forms]![FormWithTwoFields]![StartDate]![EndDate] Enkrypted A+

I have a report with a text control on it currently set to display the date ( =Date() ). I was wondering how I can replace that with information entered into a field on my form. Example: I have a form with two fields labeled StartDate & EndDate. On my report, I want to subsitute the =Date()...

Thank you. That helped out alot! Enkrypted A+

I have the following code: SELECT OptionsValues.AgentAssisted, OptionsValues.CurrentDate, OptionsValues.Duration FROM OptionsValues WHERE OptionsValues.Cable Is Not Null -- Bigger or equal of startdate AND OptionsValues.CurrentDate >= '20140421' -- Smaller...