Search results

No problem Narayan. Thanks for your reply :) Good Night! Ravi.

Hi Narayan, I am not able to solve this yet. I would be greatful, if you can help me with this. Regards, Ravi.

Thanks for the help Narayan. I'll wait for your solution. I'am trying to modify Krist's macro. If I am able to crack, I'll post it for sure. Good Night, cheers, Ravi.

Thank you Krist. I'll try your code. Honestly, either VBA or Formulae solution suits me fine. :) I made a mistake and uploaded the wrong sample workbook. I detailed my requirements once again in my last post. I'll try and let you know the result. cheers, Ravi.

Hi Narayan, Thanks for pointing the mistake. Silly me, the dates are mixed up, and I am wondering why I am not getting any response from the experts. Obviously it didn't make any sense. I updated my sample workbook in this attachment: http://speedy.sh/qqqK2/Allocation-Template.xlsx Yes...

Hi Gurus, Sorry for my delay in getting back. I did try the VBA approach suggested by Debraj, but it seems like getting complicated. Is there a way to achieve this using some complex formula :) I am sure it will work with a good array formula. But I am an illiterate in the area of...

Thank Narayan. I found that I can use Hotfile through the sticky post. I uploaded the file to Allocation Template I didn't understand how to edit my previous post. So re-posted the link above. I'll be very glad to crack this issue. I am banging around it for a while. Thanks, Ravi.

Hi, I am trying to develop an excel application for an Event house. They have two houses and each will have business slots booked throughout the year. These slots will be in hours. They are open for 8 hours every day. Slots are booked in the following way. 5th April to 7th April for 20...

Dear Narayan, Thank you very much. Got my problem solved. Your code helped me find out the mistake. I am concatenating the Date and Time value instead of adding them up. Very stupid of me. Anyways, thanks for your patience. And I learned a LOT today. Regards, Ravi.

Dear Narayan, I did go through all the posts just now and observed a bit of confusion. Sorry its my mistake not to observe that. In both the files that I uploaded, the data you are looking at is a bit different. It is no more in text format. That happened because I saved the file before...

Thanks Narayan. I used the following code: Do Until ChkRow > LRow ChkValue1 = DateValue(Cells(ChkRow, 3)) ChkTValue1 = TimeValue(Cells(ChkRow, 3)) ChkValue2 = DateValue(Cells(ChkRow, 4)) ChkTValue2 = TimeValue(Cells(ChkRow, 3)) Cells(ChkRow, 3) = ChkValue1 & " " & ChkTValue1...

Wow! That worked Narayan. But I am loosing the Time, which the key point for my analysis. How do I retain the time as well? Regards, RK.

Hi Narayan, The report is developed in such a way that each value is presented as text in a formula. ="VALUE". For all data in the report. I am just converting it into numbers, dates and text to be able to use formulas on them for a dashboard. I tried your suggestion and used this code...

Dear Gurus, I have a very typical problem with Date Format. I run an online report every day, export it into excel and then run it through a tracker. Once I download the file, I need to make some changes. I am planning to automate those tasks and am running into problems tackling the date...

Awesome Luke. Worked perfect. I need the timings to be customized and consider the date as well, which I did some more changes on to the code. Otherwise, the logic is perfect. Stupid of me not to think of that :) Thanks again, Regards, RK

Thanks Luke. The formula is awesome. But I had couple of problems. One is that there will be different "Lot Numbers", which the formula is not tracking. But I can use a Helper column and achieve this. Second issue is that I have the time in A Date-Time format. I am unable to modify the...

Dear Gurus, I have a complex issue to be solved (complex enough for me at this moment). Please help me achieve this VBA code. Please find the link to the sample file here: https://rapidshare.com/files/2211042122/Sample.xlsx I have a list of records with Date and Time, from this we need to...

Hi Excel Gurus, I need help with this small code. I know how to find a date from a range. I tried using the same code where the date is derived through a formula (I am adding up date by 1 day to each subsequent cells and use "FIND" in this range to get the column of the date). Surprisingly...

Thank you Hui. I referred to that posting long back. But am able to solve the issue after some more research. Thank you, Regards, Ravi.

Hi, I have one issue bugging me. I am using Excel 2010. I need to add a Date Picker to the VBA Form. I will be using this on a regular basis and so I want it to be displayed in the "Toolbox", just like a regular ComboBox, ListBox etc., Please let me know how to achieve this. Thanks in...