Re: $$Excel-Macros$$ Transpose data

Hi Vaibhav, Bro its superb solution. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ Transpose data

Check this... You need to copy paste row to down to get values for more data. Cheers! On Sat, Aug 30, 2014 at 4:08 PM, Rupesh Patil wrote: > Thanks for reply > Please see workbook attach, > in this workbook sheet1 have input data and in Sheet2 output should like > this. > > > > > On Sat, Aug

$$Excel-Macros$$ Fwd: HELP REQUIRE TO PREPARE CHART

Respected All, Please find the attached excel sheet I want to have one macro or any solution so that i can do the following problem. If i write Term 20 Years in C6 then my Raw chart increase automatically extend up to 20 installments If i write Term 25 Years in C6 then my Raw chart increase aut

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

At A7 sheet Homepage, select Office. GET FILE button to select the file and get into 2014-08-30 22:10 GMT+07:00 Eugene Bernard : > Mr Basole, > > Thanks for the attachements, > > I am getting an error msg as in the attachment, even after adding Ms-ado > object library. > > [image: Inline image

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

Was precisely the error: problem with the file name. * xls. To work well, every day change the name, for example: 31/08/2014 and rename to (T3108.xls). Then do the test with your file. If you have any problems, please send me an example of your file (Tddmm.xls). Regards, Basole. 2014-08-30 12:

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

Dear Basole, Please ignore my earlier mail, I removed the slash in between dd/mm from the below statement from your example fileXLS = "T" & Replace(Format(Date, "dd/mm"), "/", "") & ".xls" like below, fileXLS = "T" & Replace(Format(Date, "ddmm"), "/", "") & ".xls" and example sent by you star

Re: $$Excel-Macros$$ Filter

B2 select and click the Filter button to filter, Type in C2 or D2 and click the Filter button to filter. 2014-08-30 19:20 GMT+07:00 daya p : > Hi Friends, > > I need help regarding filter data > form with 3 combo box & label > > 1st combo i select INDIA > next if i select State (in2nd combo)

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

Mr Basole, Thanks for the attachements, I am getting an error msg as in the attachment, even after adding Ms-ado object library. [image: Inline image 1] TIA. Eugene On Fri, Aug 29, 2014 at 11:06 PM, Ricardo® wrote: > Ok, is attached files. > To test, hold the 2 files in the same folder >

$$Excel-Macros$$ Invitation to the Excel Modeling World Championships 2014

Dear members, We’d like to invite members of the discussexcel.com community to the annual Excel and Financial Modeling World Championship 2014 Event (*ModelOff, www.modeloff.com *). The Advanced Excel educational competition helps celebrate Excel in Financial Services

$$Excel-Macros$$ Need macro to covert pdf to excel

Hello, Need your help to convert pdf file to excel without changing the format of pdf. Also the pdf file converted to excel result should be into different sheets(As per attached invoice forming one workbook). i have attached two sample files. Awaiting for your positive solution. Thanks, Uj

$$Excel-Macros$$ Filter

Hi Friends, I need help regarding filter data form with 3 combo box & label 1st combo i select INDIA next if i select State (in2nd combo) name as Gujrat 3rd combo vl show Gandhinagar Country State Capital INDIA Karnataka Banglore INDIA Maharashatra Mumbai INDIA Goa Panaji INDIA Gujarat Gan

Re: $$Excel-Macros$$ Transpose data

Thanks for reply Please see workbook attach, in this workbook sheet1 have input data and in Sheet2 output should like this. On Sat, Aug 30, 2014 at 3:56 PM, Ashish Kumar wrote: > What kind of output you want….! > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups

RE: $$Excel-Macros$$ Transpose data

What kind of output you want….! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Saturday, August 30, 2014 3:08 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Transpose data Dear Expert, I need one micro or formu

$$Excel-Macros$$ Transpose data

Dear Expert, I need one micro or formula which transpose data. Sample file attach with mail with explanation. please help me out Thanks and regards Rupesh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this fo

Re: $$Excel-Macros$$ Compile Error Hidden Module: This Workbook

Send original file. Cheers On Aug 30, 2014 10:58 AM, "Ishor Singh Shreesh" wrote: > > > I wanted to used this form send by bank to do all the transactions. But in > the beginning only it show some error. I can not do anything as the macro > is password protected and moreover I do not know much a