Search results

Hi Assuming that your workbook is open along with your macro workbook My Code would be Sub ChangeFormulasToValues() Dim WB As Workbook, WS As Worksheet For Each WB In Workbooks If WB.Name <> ThisWorkbook.Name Then For Each WS In WB.Worksheets WS.UsedRange.Value =...

Kanti, I was able to fix this. Thank you.

Hi Abdul, I need to click on drop down(Cell B1) and select only one Provider. Once the data gets filtered, I have to copy this data to another workbook(new workbook). I have to repeat these steps until I was finished with all the providers. I tried to record while doing so, but it gave me very...

Oh, I See! but my requirement is slightly different. Once it loads one pivot item, it has to clear that item before selecting another one.Sorry for troubling you again and again!!!!

Hi Abdul, Thanks for you quick Response. I should have checked that PivotField was "Providers" not "Provider". Macro is running without error but it is not doing what it is suppose to. Although it is looping but it is not changing the filter in cell B1(Pivot Sheet), hence the data is also not...

Hi All, As you can see in the attached file, I have pivot table where I want to loop through each pivot item in pagefield and do something with the filtered data. I tried with this code but it shows error(screenshot attached in file itself). Kindly help me. Sub LoopThroughPivotItems() Dim PT As...

Sure Vipin, Here we go! Along with Date modified I have included 'Date Created' also.Don't forget to let us know if it works for you. With Regards Rudra

Thank you all.

Hi, Does anyone know if we have an Excel Forum for Indian Vernacular Languages? With Regards Rudra

Hi Tehrani, Why not send a Template with date validation to all of them? One more option is use google form. Have you given them a try? With Regards Rudra

Hi, Here is my version With Regards Rudra

Hi All, In my company many people have office 2010 and few have 2013. What I have noticed is if someone opens any excel file in office 2013, that can't be opened normally by excel 2010. This is happening despite changing the protectedview settings(trust center). Because of this macro is unable...

Hi Abhijeet, You mean to say that you have listed files and folders in excel spreadsheet which you want to delete. Is it so? If yes, I think it is very much possible. I have attached the file to do this work. Kindly let me know if it works. With Regards Rudra

Abhijeet, You have to configure your outlook in such a way that username and password are saved into it. So whenever you run the macro, it simply composes the email and saves in outbox. All you have to do is open your outlook and hit F9. This is how I have been doing it. I took help from IT...

There must be some hidden sheets like chart sheet....I tried with your code and it works perfectly.But when I added a chartsheet it threw error. In your code, I replaced 'sheet' with 'worksheet' and it worked. With Worksheets(i) ' use this code With Regards Rudra

I have downloaded the attachment(with Code), you may go ahead and remove it. Thank you very much for helping me out. With Regards Rudra

Hi It worked fine. Thank you very much for your help! With Regards Rudra

Thanks for the suggestion. I will keep it in mind, henceforth.

Hi Dan, Thanks a lot, Who says this is not good?...you are right this is not good...this is too good!!!It works like magic!!!!. Could you pls modify your code so that Date also comes in the 'Output' Sheet?Sorry for troubling you again!!!! I wish I could code like you!!!! With Regards Rudra

Hi Friend, The best way to learn pivot Table automation is to record macro while you create PT. This is how I learnt (not 100% yet) Looking at your code(to add fields), try adding PT just before .pivotfields like: With PT.PivotFields("Stock Id") 'this should not throw any error...

Hi Excel Gurus, Good Morning! I have an excel file(Sheet-Junk Data) where there are many columns which read as: A1:P1 = Sl.# Date File Name Comments Physician 1 Physician 1's Fax # Physician 2 Physician 2's Fax # Physician 3 Physician 3's Fax # Physician 4...

Hi, Why not use pivot table?

=IF(COUNTIF($A$3:A3,A3)=1,SUMIF($B$3:$B$11,B3,$H$3:$H$11),"--") this is non array formula thanks..

Not sure what type of error you are getting. Have you made reference to outlook by doing VBA=>Tools=>Reference=>Microsoft Outlook(15.0) Object Library(you may not get 15.0 if you are not using office 2013) With Regards Rudra

Oh My God, I never realized that it was offset function. Thank you very much for your explanation. Have a nice day!!!