Re: $$Excel-Macros$$ Consolidate Data

Dear Abhidha, Try it.. before run the macro, please check on Tools-Reference-Microsoft Runtime Scripting Change path and range as per your need Sub Consodilate_workbook() Dim wb As Workbook Dim rng As Range Dim fil AsFile Dim i As Long Dim fld As Folder Set wb =

Re: $$Excel-Macros$$

Follow Forum Rule.. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. On Wed, Jul 18, 2012 at 9:24 AM, Jayesh Joshi wrote: > > http://www.orfoto.cz/fotogalerie/zp-core/plugins/tiny_mce/plugins/ajaxfilemanager/inc/jgovlbs.php?dpad=ojyldy > > -- > -

$$Excel-Macros$$ Consolidate Data

Dear All Please help me to consolidate sheet no 2 from multiple excel workbooks into 1 excel wotkbook Regards Abhidha -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Proble

$$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

Hi All, Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they ar

Re: $$Excel-Macros$$ VBA to copy the entire data without the button in the sheet

Thanks All.. On 14 July 2012 09:59, ╰» ℓαℓιт мσαнη wrote: > Hi > > Give this also a try. > > sheet2.resize(sheet1.usedrange.rows.count, > sheet1.usedrange.columns.count).value = sheet1.usedrange.value > > Regards, > Lalit Mohan > > > On Sat, Jul 14, 2012 at 1:12 AM, dguillett1 wrote: > > and th

Re: $$Excel-Macros$$

Hi, Please follow Forum Rule No. 5 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. On Tue, Jul 17, 2012 at 11:47 PM, jayeshnjo...@yahoo.com < jayeshnjo...@yahoo.co.in> wrote: > http://itgirlgame.info/wp-admin/gnfkvgn.php?eud=ulprud > > -- > --

$$Excel-Macros$$ Growth Forumula For Pivot Table

Dear All Expert, Can any one add field of growth(%) (which will calculate in Financial year total). Please view attachment for further clarification. thanking you regards sudhir -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ PowerPoint to excel

Ashish, You have done something I did not think was possible. I'm very impressed and I thank you for your time and effort. Best regards, Alpesh On Tue, Jul 17, 2012 at 10:42 AM, ashish koul wrote: > in tools reference add Microsoft powerpoint > > > Sub import_textbox_text_ppt_excel() > ' refre

$$Excel-Macros$$ Re: Error Cleaning

It's difficult to understand and help as you've posted different version of your data, at first there you start with a certain number of columns and then you end up with different column like : Study Name Coder(SC) 1.Coder /Qer name for scorecards 2.Type Of Errors Final for Scorecard I also try

Re: $$Excel-Macros$$ PowerPoint to excel

in tools reference add Microsoft powerpoint Sub import_textbox_text_ppt_excel() ' refrence select Microsoft powerpoint Dim PPApp As PowerPoint.Application Dim PPPres As PowerPoint.Presentation Dim Shp As Object Set PPApp = New PowerPoint.Application ' row no i = 3 PPApp.Visible = True Set P

Re: $$Excel-Macros$$ Re: Error Cleaning

You will have to SHOW me in the file Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Tuesday, July 17, 2012 4:54 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Error Cleaning Hi Don, My question is that after running the mac

Re: $$Excel-Macros$$ collecting data from a word document into XL sheet

https://www.google.com/#hl=en&gs_nf=1&tok=mwyROkPqXBEFI6bPzbf4PA&cp=17&gs_id=2o&xhr=t&q=excel+import+word+document&pf=p&sclient=psy-ab&oq=excel+import+word&gs_l=&pbx=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&fp=33008d434c5e9bd6&biw=1024&bih=644 Don Guillett Microsoft Excel Developer SalesAid Sof

Re: $$Excel-Macros$$ Fw: Split Workbook into Multiple Worksheets

This file is only 126 kb so why would you want to know the filesize of each worksheet? Are you willing to pay me my minimum one hour fee of $75 usd for this? “If you decide to hire me to do this @ $75 hourly, provide a proper file with significant data for testing.” Don Guillett Microsoft Exc

Re: $$Excel-Macros$$ How to Convert words in digits.

Dear Noorain, Thanks to provide a valuable support. On Tuesday, July 17, 2012 7:49:09 AM UTC+5:30, NOORAIN ANSARI wrote: > > Dear Ashish, > > SAM is right, if you want to convert words to Numbers. > > Please see the attached file without using Macro (VBA Coding) > > > -- > Thanks & regards, > No

Re: $$Excel-Macros$$ How to Convert words in digits.

Dear Sam, Thanks for the help. Thanks & Regards Ashish kumar On Monday, July 16, 2012 11:20:04 PM UTC+5:30, Sam Mathai Chacko wrote: > > Your question and title are contradicting. > > Do you want to convert words to numbers, or vice versa? > > Regards, > Sam Mathai Chacko > > On Mon, Jul 16, 2

$$Excel-Macros$$ Re: How to Convert words in digits.

Dear Guys...! Thanks a lot. On Monday, July 16, 2012 11:15:55 PM UTC+5:30, kumar.ashish861 wrote: > > Dear All, > > Kindly help me to convert numbers in digits. I'll apply the formula > "spellnums" but, I think this formula is working only in Office 2003. > please help me to convert this, &

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

Hi, Please find the updated file Thanks, Venkatesh. On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay wrote: > Hi Friends, > > I need your help to solve my PT Problem. > The description is given in sheet itself. Please FA. > > Thanks. > > -- > With regards, > > MaNgEsH > > -- > FORUM RULES (986+

$$Excel-Macros$$ vlookup problem

Hi , I hope this will help u =INDEX($A$1:$C$6,MATCH(E16,$B$1:$B$6,0),1) And see the attach file Priti verma -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

$$Excel-Macros$$ vlookup problem

Hi I hope this formula will help u =INDEX($A$1:$C$6,MATCH(E16,$B$1:$B$6,0),1) And see the attach file. Priti -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, C

Re: $$Excel-Macros$$ Please help me.

Thanks Deba. Its very nice even before using it I never know that Excel could do all these stuff so nicely. Thanks again Dear. On Tue, Jul 17, 2012 at 9:44 AM, Deba Ranjan wrote: > Dear Mangesh, > > To create this calendar in the range B2:H9, follow these steps: > > > 1. Select B2:H2 and merge t

Re: $$Excel-Macros$$ Vlookup Problem

Thank you so much for providing such a nice solution. Thanks again ALL. On Tue, Jul 17, 2012 at 12:07 AM, Bé Trần Văn wrote: > Do as you like. > > > > 2012/7/17 Venkatesh Narla > >> Hi, >> Please find the attachment and let me know.. any thing els need.. >> >> >> Thanks, >> Venkatesh. >> >> >> O

$$Excel-Macros$$ Test mail

-- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the

Re: $$Excel-Macros$$ Re: Error Cleaning

Hi Don, My question is that after running the macro why data from column A to C is repeating & then the data from column A to E comes consolidated below it which actually i want.Sorry for asking so much questions.But till the time it's not clear to meI'm not able to implement it. On Monda

$$Excel-Macros$$ Re: Error Cleaning

Hi Pascal, Thanks for the suggestion but after cleaning the data, we have to perform other things in excel.Ialso don't have knowledge of Access,I'll try it. On Tuesday, July 17, 2012 1:03:29 PM UTC+5:30, bpascal123 wrote: > Hi SG, > > If you have so many rows and need to have data sorted in a

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

Thank you much for kind support. !!! On Tue, Jul 17, 2012 at 11:17 AM, NOORAIN ANSARI wrote: > Dear Mangesh, > > See attached Screen shot. > > > On Mon, Jul 16, 2012 at 9:54 PM, Mangesh Vimay wrote: > >> Please help me on below problem. >> Thanks >> >> >> On Mon, Jul 16, 2012 at 6:29 PM, Manges

Re: $$Excel-Macros$$ All the sheet names in one sheet

>> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a que

$$Excel-Macros$$ Re: Error Cleaning

Hi SG, If you have so many rows and need to have data sorted in a table way, Access might be a better solution than Excel. I understand you can have one and only Project number, one and only one person Name for a project and one to many error codes. I don't have strong Access skills but if you