Search results

Thanks mate, thanks for you quick response,,,still waiting for other excel magician's magic..:) With Regards Rudra

Hi All, I have a workbook with 3 sheets viz. Master,Report 1 & Report 2. Master sheet has all the data in database format and in other two sheets this data is analyzed. I need to share this file with many people in the company. Since master sheet and Report 1 contain some sensitive data, I don't...

@murugan_gv I have got no issue with this addin....I am very happy to get it through you...Infact I have already started using it(successfully) and have made it installed in all the systems of my subordinates. @SirJB7 thanks for your words, indeed we are very fortunate to know these facts...

@murugan_gv Hi thank you very much for this link..I was not aware about this addin.It has got everything you need while combining your data... Thanks guru, you made my day. Regards Rudra

Abhijeet Here is a macro which I use almost everyday to consolidate data from different files. This macro brings data from "Sheet1" only. If your requirement is different, please let us know.This is my first macro. With Regards Rudra

Hi sirjb7 sorry for the confusion, I had to come here again...It was my mistake that I didn't upload the file....Please see the attachment for my good manager's requirement. Data in 1st Col is Junk date which should be converted to valid date with the help of a UDF(as in col B). The clean Date...

@SirJB7, this is exactly I..sorry My Boss...was looking for..thanks a lot. @ All, thank you very much for all your efforts. I am just wondering why wasn't I using this forum earlier?. With Regards Rudra

Hi All, My manager wants me to help him with a UDF to extract date from junk text like below. Does anyone have magic wand here? Junk Text Clean Date Joined on Jan 2nd - 19 days 1/2/2014 Joined on Jan 4th - 17 days 1/4/2014 Joined on Jan 4th - 17 days...

@SirJB7 Works a treat guru..thanks... With smiling face:) Rudra:)

Marc L, Can you modify my macro, Please........

Hi, Why not have this macro work automatically whenever there is change in column A?.. Your boss doesn't have to click button also...:) like... Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then Dim ws As Worksheet Set ws = Worksheets("Sheet1") lastrow =...

@Hui I have not enabled any reference...

Hi, I am not finding my reply either here..(I had done it from home)....may be I got disconnected.but somehow file got uploaded......very funny indeed!!! I use Office 2013 @ office and office 2010 @ home,and my macro works fine on both of my systems(without those commented codes). @SirJB7 thanks...

Thanks a lot friend.. Rudra

Hi Folks, I have a macro which lists all the folders in given path.It also gives me infos like folder created date,lastmodified date and folder size. I want to add one more column which should give me # of files in each folder. Googling was of not much help. Can anyone help me with this? I am...

How do I write this UDF with the help of 'case' function? Function AgingBucket(Age As Integer) As String If Age >= 120 Then AgingBucket = "120 Days" ElseIf Age >= 90 Then AgingBucket = "90 Days" ElseIf Age >= 60 Then AgingBucket = "60 Days" ElseIf Age >= 30 Then AgingBucket = "30 Days"...

@Luke M Tonnes of thanks to you for the macro....It gives me immense pleasure if I get something for free..:) @SirJB7 definitely I will do that......its been two weeks since Valentine's day, you seem to be still in V mood....:)

@ Hui, Thank you very much....I really appreciate it. @ Shrivallabha yes..my string will have always more than 1 space.thanks for your coding help.... With Regards Rudra

Hi All, Good Evening(per IST) In order to give some exercise to myself, I imported data from this forum(Notable members). Excel listed everything in column A. How can I arrange this data in database format? Please see the attached file. Right Side(col A) = Input Right Side = Output

Hi, I want to extract first two words from the string with VBA. Can anyone help? VBA equivalent of =LEFT(A2,FIND(" ",A2,FIND(" ",A2)+1)-1) With Regards Rudra

Hi Anu, Here is my version. Since you had highlighted the columns to be retained, it was easy to delete all others. Make sure to take a backup before you run this macro. With Regards Rudra

Hi Dan, I was able to fix this...Instead of Hard coding, I put the columns in loop...it worked....thanks

Dan, Good Morning! As of now this macro can deal with only six physicians. How can we make it work for any number of physicians? With your suggestion I was able to fix the 'Second' problem. Thanks for that. With Regards Rudra

Hi Dan, All these days this macro worked perfectly fine becuase the maximum number of columns remained unchanged.Now, since the number of columns in this spreadsheet have changed, it is still taking maximum 5 columns only. Could you please modify this macro so that it takes any number of...