Search results

Hi Team, I need to add blank row in excel based on there value. If values in row are same and count of those rows are more than one then I need to add blank row at starting of the group and at ending position of group. Attaching sample data for more reference. Thank you!

Hi Rahul, thanks for your reply. But as said earlier in post i need a formula to fetch data from those files saved in folder. It will be possible using SQL query but I don't want to build connection over here. Also please note that file names may be different with different location so want to...

Up to 10 files Rahul and format for all is same

Hi Team, I need a Vlookup formula, which will take values from all files saved in a particular folder. E.g. File 1: Col1 Col2 123 Need to fetch Col2 value from files saved at folder 456 789 There are multiple files saved in folder such as File2, File3, File4, File 5 upto 10 files (Data...

Thank you Chihiro for your suggestions. But now am able to automate this site through vba. I will try to upload the code for reference if possible.

My requirements are as below Currency to convert. USD amount 10eur 5gbp 12 afn 45eur In excel columns user will update there values with currency we just need to convert those amounts to USD from OANDA site only

Thank you Chihiro, but we don't need to pay for this site. As am able to access it. I just want a macro which will convert currency automatically as per mapping provided in excel

Hi Team, I need a macro which will convert currency as per data provide in excel sheet, it may be from USD to EUR or EUR to GBP Website from where i need conversion is : https://www.oanda.com/currency/converter/ Help will be highly appreciated. Thank you in advance :)

Hi Team, I have excel which contains more than 80 sheets, with 27 pivot. Each sheet will not have data more than 10000 rows. I saved the file in binary format but still file size is more than excepted( it around 35 MB). File doesn't contains any object in it. When I delete unwanted rows and...

I have one pivot chart with fixed formatting. Whenever I changed the data source of my pivot at run time with VBA, It automatically change the whole setting of Pivot chart with its data source. Is there any way to refresh Pivot charts with new data source as we do with pivot tables. Thanks in...

Hi Lori, Thanks for your reply. I tried this formula but it doesn't allow me to write it using vba, because array formula has limit of 255 characters in vba. so getting error of 'Unable to set Array property'..

How to write that formula of creating combination in VBA As if am writing the same formula using range().formula=Formula then it giving error as 'Unable to set FormulaArray..' same error if am using range.formulaArray. Is there any solution as I want to use this using VBA only

Hi All, I just wanted to share Camera tool function with you all which is there in excel and it is very useful while creating Dashboards. Thanks!

Hi All, yet am struggling with it and unfortunately not getting any response from anyone:(

Hi All, I am refreshing my pivot table range at run time. But after refreshing the pivot the format of it will changed automatically. Can someone help me to sort it out as I want to keep same format which is ther in file. Also I dont want to assign full range to pivot. Thanks for advance

Ref

I am not getting any idea about how to do this.. :(

Hi, attached are the sample PPT files. There are total 3 PPt files each file contains 3,4,5 slides respectively containing different data(Here it is same as dummy data). So I need one final PPT file which contains all slides from those files i.e. from PPT1.pptx including first slide and for...

Sorry but I have already search that and unfortunately its not working

Thanks Deepak, But I want to write code in excel itself (Excel to PPT).

Hi Team, I need to combine many slides from different PPTs into one. Please share your ideas about how can we implement this using vba. Thanks in advance!

Any help guys

Hi All, Upload file for reference. In this code by default slide is 8. If data exceeds the height it will create new slide and paste data in it accordingly. But I want to create it more dynamic for future use. Please help. Want to create function so will just pass the start slide No and excel...

Attached file for reference

Here I decrease the size of my range but now question is how should I copy that remaining range to new slide?