Posts by Michael Garrett

Re: Complex Conditional Formatting

After you have the Conditional Formatting on the First Row. You can do a macro that copies that row and paste's values on the whole sheet. This should be relatively simple.

Re: Can you open a Text File on your computer from a Script

I have a Macro/Script inside and Excel Sheet. When it is run it runs a batch file that starts a script from another program. That script creates and excel sheet or multiple sheets depending on the macro. Then it pulls all the data from those sheets into the sheet with the macro and does all my data calculations etc. The problem is, is the 2nd script that the batch file runs is from the other program and it is not an Excel Macro Script it is a script that is run by that software. The problem is that the software has no option of changing the dates or the type of report i want. So i have to manually open that script, changes the dates and the data values to get what i want. I would like to set up a script inside my existing macro that pops up a box with the date and the data values, that edits the script from the other program. Creating a string is the best option but i don't know how to get it to work outside of excel. I think maybe a Visual Basic program is the best option, but i don't know it well enough.

Hope this gives more clarification.

Re: Complex Conditional Formatting

This should get you started. Just look at the Conditional Formatting that i already added.

Here is the delima. I have a script that i run that comes from another program. The way i edit this script is by opening it with notepad and making the changes neccessary and then saving it. It has 2 fields that i want to make an input box for so that i can choose a date and a value to pull specific information. The problem is how to start. I was thinking about creating a script that runs the pop up box, you put in the date and value, as strings. It opens the text file, edits it , then runs that script.

If you have another solution please let me know. Or if you know how to call up this text file and replace the data i would appreciate it the help.

Thanks

Mike

Re: mm/dd/yyyy hh:mm:ss assistance

I need the data to be only the time, not just show the time, meaning that the serial number that Excel see's is different for just 11:20:04 than it is for 2/15/05 11:20:04 PM.

I have attached a sheet that i need some help with. The problem is that the Date is imported as 11/8/2005 11:20:04 AM. I want to seperate the 11:20:04 AM without the date. Does anyone have any suggestions.

Thanks

Mike

I am trying to come up with a formula of macro or script that will search a group of cells and if the Cell color is a specific color then it puts the data from that cell in the cell where the formula is.

Example

a1:a100 has values of 1-100. Odd numbers are red and even numbers are Blue.
In b1:b50 I want it to paste all the numbers that are RED, essentially it will be all the odd numbers.

Thanks for the help in advance.

Mike

Try and add the command Calculate right at the end of the CODE. Just make sure you put an Activate.Workbook, to activate the workbook with the vlookups. This is what i did in mine and it works great.

I am not sure that you can do this with VBA, But you can with using a Batch file. I am not sure all the commands to use but hopefully this will get you started.

This may not make any sense but look at the Example and see if you have any ideas.

Thanks in advance for the help.

It would be = (Cloumn A \ Column B)-1 in Column C and vice Versa.
See attached Example

I believe the reason that this is happening is because the stockingstatus.xls is referencing something from the other sheet.

I did a macro that just copies the values from the workbook that i need and then paste into another sheet and then recopy and paste values only.

This eliminates all the referencing from any other sheet.

This is the best site i have seen so far.

If you need help, Just use the help files they are great.

I only addressed him because he helped me with it last time.
Sorry everyone.

Thanks Derk

I need to make sure that this is correct to make this start over again in 4 hours. I want it to start at 10:10AM in the morning and then run again at 2:10 PM. I ran it once and it started again in 1 hour and then it ran 2 times for some reason. Does this statement look correct to you.

' Restarts in 4 hour
Dim t As Date
If Time > TimeValue("2:00AM") And Time < TimeValue("10:00AM") Then
t = Now - Time + TimeValue("10:10AM")
Else
t = Now + 6 / 24 - (Minute(Now) - 10) / 1440 - Second(Now) / 86400
End If
Application.OnTime t, "Stats"

I think it is under Tools, Options, Error Checking.

Those are the options that allows the little black boxes to pop up.
I don't think you remove the Function Insert button though.

The limit on IF statements is 7 BTW

I think what you need is a Pivot Table.

It looks like you want to Tally or total the number of times that these options are matched.

If that is what you want then look at the Pivot Table Help Files.

This may resolve your issue.

the sample you posted has no formulas in it.

I still don't understand based on the sample what you are trying to accomplish.

CAn you post a sample sheet.

I am sure if we see the sheet we might come up with some idea for you?