Hi,
The data is as shown below Date in column A, Time in B and values in C. I need to sum the values in coulmn C for the times starting from 7:00 PM a day and ending 6:00 AM the next day. The sum is done for 24 hrs. which would run into the next day. Any help in this area would be helpful.
A...
Hi, I need help here... My weeknum function gives me the week number. Lets say that the date is Feb 3, 2012, weeknum will show the number as "6", Is there any way that the cell shows Feb week 1, Mar week 3 and so on....
Attaching an excel sheet. I need to select the week and the graph should show the changed data. Or there are two buttons placed need to check if that can be done by this button. Dynamic graphs i suppose any help link as given below...
OH ok i understood, i have captured the name in a variable. But this is giving me the name of the file that is been used for the code. My requirement is to capture the name of the file that i open with this code...
any idea, or am i not correct in understanding the basic
Hi SirJB7,
Thanks for the reply, I am new to VBA coding so have not tried. Now i tried and not getting the required result. i have changed the code to
Sub OpenFile()
Dim fileName
fileName = Application.GetOpenFilename
If fileName <> "False" Then...
I am using a code to open file from another file.
Sub OpenFile()
Dim fileName
fileName = Application.GetOpenFilename
If fileName <> "False" Then
Workbooks.Open fileName, Format:=2
End If
End Sub
My requirement is to capture the name of the file (Not the path) which is opened...
Never confusing Narayan, that was well explained. As I said have been reading most of your posts and all are well explained. I need your assistance for most of my cases. I would be posting more. You are one of those guys who explain very well. There is one more a person called Hui i feel, if i...
You Know Narayan .... You are just awesome. i have been going through few of your posts and was always satisfied with the solutions that you give. Just one more question what is the significance of "-1" in this formula -
=OFFSET(F2,MATCH($G$2,$E$2:$E$96,0)-1,0,COUNTIF(E2:E96,$G$2),1)
Hi I am facing problems in here. i have uploaded the file in hotfile link - http://hotfile.com/dl/139854571/4da7eab/Error_Classification.xlsx.html
i am able to get the drop down in the 2nd Level but the list is blank. Please help again
I have a list (Validation) in "A2" and it has ABC and BCD as drop down. Now "C2" should actually show another list depending on the selection of ABC or BCD. Please help
Hi, This is a bit akward stuff. This is an excel sheet. I have row, say A2 to Z2 filled up with alphabets starting with A to Z. I have another cell, say A3 displaying the active cell value. the code i have used is Range("A3") = ActiveCell.Value in the Selection change of the worksheet. Now i...
Hi Fred, its only 8 in the entire range. Sorry for not being specific. Well this is just my second post, so, not so well with it. :-)
Hi Luke, Thanks for this you saved my day. I was actually suming up the work hours for the entire team and wanted to sumup the time which was less than 8 hours...
Hi,
I have a range say A1:D10, All of the cells in this range contain the number 8, except for three cells, which contain 5, 2 and 6. The cells are A2, B2 and C2.
I wanted to write a formula in "A11" or any other cell which would Sum only the cells that contain numbers other than 8,
I am...
Hi Felix,
This is my first time too using the site. Here i have a different thought about it. I might be wrong, but correct me because i might not be aware of it. As per your requirement, i feel that VLOOKUP is a function that would return only one value in a single cell.(This is the part that...